Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

[Sonja_Bauernfeind]

QlikView fails to load LDAP data from OLE DB Provider for Microsoft Directory Service (ADsDSOObject) with error QVX_UNEXPECTED_END_OF_DATA

Resolution:

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.

Option 1

Increase the maxPageSize as per  View and set LDAP policy in Active Directory by using Ntdsutil.exe (Microsoft).

Option 2

1. Use EXECUTE command in QlikView to run a vbscript that fetches data from ADsDSOObject, similar to the one in article How to test ADsDSOObject outside of QlikView/ Qlik Sense
2. Direct output of the script to a text file
3. Load AD data from the text file to QlikView

Option 3

Bundle the data and limited the extraction that way.

Example code: 

Table: Load * ; First 1000 SQL Select * From table_name;

Environment

QlikView  

Qlik Internal reference IDs:

QV-14837, QV-15075

[Nika]

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

[Sonja_Bauernfeind]

Hello  @Nika 

I've updated the article with the correct link.

All the best,
Sonja