Netscape.ldap.LDAPException: error result (4); Sizelimit exceeded

Hi,

LDAP configuration in BIEE 11 g via Microsoft Active Directory some times its throws below kind of error.

The error is "LDAPException: return code:netscape.ldap.LDAPException: error result (4); Sizelimit exceeded".

Note: the error message say's that you have exceeded the limit the server has been configured to return, (i.e: your request exceeded).by default values is 1000.

Solution:

we need to increase the LDAP user sizelimit -->Go to the LDAP client install drive, then search it ldp.exe file and run as admin then connect it by using ldap domain user id and password, refer the below methods,

1).  the sizelimit can be set the
LDAPConnection.setOption(LDAPv2.SIZELIMIT, new Integer(0)); for example

by Changing maximum results option using ldapconn.setOption(LDAPv2.SIZELIMIT,25000)

i.e: by Changing Look Through Limit to around 25000 in ldap server.

2.) and if you are using the netscape jar to search, do the following:

LDAPConnection ldapCon = new LDAPConnection();
LDAPSearchConstraints cons = ldapCon.getSearchConstraints();
cons.setMaxResults(-1);
ldapCon.search(ldapURL, cons);

For more:

https://kr.forums.oracle.com/forums/thread.jspa?threadID=1155618

Thanks

Deva