
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QlikSense: LDAP call fails with Pagesize Exceeded
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please refer to the following article and see if it helps.
Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please refer to the following article and see if it helps.
Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
