Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

Sonja_Bauernfeind — Mon, 29 May 2023 14:11:22 GMT

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

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
Direct output of the script to a text file
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

Qlik Internal reference IDs:

QV-14837, QV-15075

Re: Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

Nika — Mon, 06 Mar 2023 10:20:34 GMT

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

Re: Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

Sonja_Bauernfeind — Tue, 07 Mar 2023 09:09:09 GMT

Hello @Nika

I've updated the article with the correct link.

All the best,
Sonja

article Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject in Official Support Articles

Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

Resolution:

Option 1

Option 2

Option 3

Environment

Qlik Internal reference IDs:

Re: Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

Re: Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject