Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 29, 2023 10:11:22 AM
Jul 20, 2018 5:00:36 AM
QlikView fails to load LDAP data from OLE DB Provider for Microsoft Directory Service (ADsDSOObject) with error QVX_UNEXPECTED_END_OF_DATA
This error indicates that you have exceeded the size limit. In later version of QlikView (12.40 and onwards), the message has been adjusted to read EQ_QVX_SIZELIMIT_EXCEEDED and will show the maximum amount of rows that can be retrieved.
There are two possible workarounds.
Increase the maxPageSize as per View and set LDAP policy in Active Directory by using Ntdsutil.exe (Microsoft).
Bundle the data and limited the extraction that way.
Example code:
Table: Load * ; First 1000 SQL Select * From table_name;
Hi @Sonja_Bauernfeind ,
I currently have the same problem and it is not possible to do workaround 2. So I wanted to check out option 1 but the link doesn't seem to work and I can't find the article. Is the article still available?
Thanks.
Nika