Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObject

Last Update:

May 29, 2023 10:11:22 AM

Updated By:

Sonja_Bauernfeind

Created date:

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

select name from.png

 

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

 

Labels (2)
Comments
Nika
Contributor
Contributor

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

Hello  @Nika 

I've updated the article with the correct link.

All the best,
Sonja 

Contributors
Version history
Last update:
‎2023-05-29 10:11 AM
Updated by: