QlikSense: LDAP call fails with Pagesize Exceeded

[graham-crooks]

Hi All.  Wondering if someone has hit and solved the following issue in relation to QlikSense.

I've established a Generic LDAP connection which reads active directory just fine if I limit the load script to a single record (say, my own details). As soon as I remove that constraint, the load fails with a message to say PAGESIZE has been exceeded.

I drew initial inspiration from an article by Rob Wunderlich, but note that others also encountered this issue, despite the advice given in the article.

https://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/

The suggested use of FIRST 1000 in the load script appears to be ignored by our active directory connection.

Has anyone solved the PAGESIZE failure with appropriate logic?

Any insights you can offer would be welcomed most warmly.

[Ranganath_DR · Accepted solution]

Hi @graham-crooks 

Please refer to the following article and see if it helps.

Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

[graham-crooks]

Hi @Ranganath_DR 

I followed this through to the script link:

https://support.qlik.com/articles/How-to-test-ADsDSOObject-outside-of-QlikView-Qlik-Sense

This reads back records just fine, which from the article appears to bring me back to "I've a problem in QlikSense". What would be the next logical step please?

Kind regards, G

[Andre_Sostizzo · Accepted solution]

@graham-crooks, if you read through the full article it mentions about increasing the maxPageSize value, which indicates it is not a problem with Qlik Sense but due to a MS LDAP Policy which can be changed.

https://docs.microsoft.com/en-US/troubleshoot/windows-server/identity/view-set-ldap-policy-using-ntd...