Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
According to Microsoft documentation at https://docs.microsoft.com/en-us/sql/ado/guide/appendixes/microsoft-ole-db-provider-for-microsoft-active-directory-service, OLE DB Provider for Microsoft Active Directory Service is based on the Active Directory Service Interfaces (ADSI). Also according to the Microsoft library page at https://msdn.microsoft.com/en-us/library/aa746414(v=vs.85).aspx, ADSI searches without paging are limited to returning a maximum of the first 1000 records. This is therefore a known limitation of the OLE DB provider.
Note that although the documentation says the limit is 1000 users, the reload may still fail with "FIRST 1000" in the QlikView/ Qlik Sense Load statement. However, the reload works with "FIRST 999". Since the loop eventually loads all users, the exact limitation shouldn't be a problem.
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.