topic QlikSense: LDAP call fails with Pagesize Exceeded in Connectivity & Data Prep

QlikSense: LDAP call fails with Pagesize Exceeded

graham-crooks — Tue, 10 Aug 2021 15:56:42 GMT

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.

Re: QlikSense: LDAP call fails with Pagesize Exceeded

Ranganath_DR — Wed, 11 Aug 2021 16:48:11 GMT

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

Re: QlikSense: LDAP call fails with Pagesize Exceeded

graham-crooks — Thu, 12 Aug 2021 13:01:12 GMT

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

Re: QlikSense: LDAP call fails with Pagesize Exceeded

Andre_Sostizzo — Fri, 27 Aug 2021 19:30:33 GMT

@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-ntdsutil