Error "QVX_UNEXPECTED_END_OF_DATA" when loading data with ADsDSOObjectArticle Number: 000053759 | Last Modified: 2019/11/25
QlikView 12.20 fails to load LDAP data from OLE DB Provider for Microsoft Directory Service (ADsDSOObject) with error QVX_UNEXPECTED_END_OF_DATA
This does not happen in QlikView 12.10 and 11.20
The issue also happens when using First XXX statement and XXX is lower than the maximum value (the default maxPageSize is 1000)
The error message shown in QlikView 12.40 IR is EQ_QVX_SIZELIMIT_EXCEEDED
- QlikView 12.20
- QlikView 12.30
- QlikView 12.40
! This is currently being investigated as a defect, and actively being worked on. Information provided on this defect is given as is at the time of documenting. For up to date information contact support at support.qlik.com with the ID QV-15075 for reference.
Possible solutions is as follows:
- 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
- It will be necessary to increase the maxPageSize
! Before making computer system registry changes, please backup your server and server registry before doing so. Incorrect registry settings may adversely impact and damage the health of your Windows Server.
Have a Question?
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.