How to query a result set larger than 1000 records from Active Directory server using TIBCO Adapter for LDAP?
Article ID: KB0086395
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for LDAP | - |
| Not Applicable | - |
Description
Resolution:
By default, when you query a result set larger than 1000 from Active Directory server, an error "Size Limit Exceeded" will appear in the adapter log. To avoid this, the only task needed is to increase MaxPageSize which belongs to AD Server. Change it to a number larger than the search results. For example, if the search results is 1200 increase the MaxPageSize to any value greater than 1200.
For details, refer to
http://social.technet.microsoft.com/wiki/contents/articles/14559.active-directory-ldap-policy.aspx.
Example using ADSI Edit.
1). Open ADSI Edit. Input "adsiedit.msc" in the Run program and click OK.
2). Connect to the domain with "Configuration" Naming Context.
3). Navigate to the entry "CN=Default Query Policy,CN=Query-Policies,CN=Directory Service,CN=Windows NT,CN=Services,CN=Configuration,DC=cdc,DC=tibco,DC=com", here replace " DC=cdc,DC=tibco,DC=com" with your domain.
4. Edit lDAPAdminLimits attribute and set MaxPageSize to appropriate number.
By default, when you query a result set larger than 1000 from Active Directory server, an error "Size Limit Exceeded" will appear in the adapter log. To avoid this, the only task needed is to increase MaxPageSize which belongs to AD Server. Change it to a number larger than the search results. For example, if the search results is 1200 increase the MaxPageSize to any value greater than 1200.
For details, refer to
http://social.technet.microsoft.com/wiki/contents/articles/14559.active-directory-ldap-policy.aspx.
Example using ADSI Edit.
1). Open ADSI Edit. Input "adsiedit.msc" in the Run program and click OK.
2). Connect to the domain with "Configuration" Naming Context.
3). Navigate to the entry "CN=Default Query Policy,CN=Query-Policies,CN=Directory Service,CN=Windows NT,CN=Services,CN=Configuration,DC=cdc,DC=tibco,DC=com", here replace " DC=cdc,DC=tibco,DC=com" with your domain.
4. Edit lDAPAdminLimits attribute and set MaxPageSize to appropriate number.
Issue/Introduction
How to query a result set larger than 1000 records from Active Directory server using TIBCO Adapter for LDAP?
Feedback
Yes
No
Powered by
