Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
graham-crooks
Contributor III
Contributor III

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.

grahamcrooks_0-1628610918687.png

 

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.

Labels (1)
2 Solutions

Accepted Solutions
Ranganath_DR
Support
Support

Andre_Sostizzo
Digital Support
Digital Support

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

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂

View solution in original post

3 Replies
Ranganath_DR
Support
Support

graham-crooks
Contributor III
Contributor III
Author

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
Digital Support
Digital Support

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

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up! 🙂

View solution in original post