Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I updated our dev and test environments to QlikView 12 November 2017 SP5, both server and desktop. Since that point I have been having issues with scripts that have been connecting to Active Directory. Before the upgrade they were working correctly without any issues, we have't touched the scripts, but since the upgrade, when running them they get the dreaded QVX_UNEXPECTED_END_OF_DATA error message.
Just want to know if anyone else has run into this issue since upgrading. It connects properly but once it starts the select statement it immediately errors out and doesn't pull any records. We are using what has been provided from the community and was working, but I'll include my code as well. Just seems like there has been a change somewhere in the upgrade that is affecting this.
CODE:
CONNECT TO 'Provider=ADsDSOObject';
LET arg=chr(01); // Set search start name to a very low value
DO
UserTable:
First 999
Load
*,
'UWHIS.HOSP.WISC.EDU' as Domain;
SQL select
displayname,
sAMAccountName,
memberOf,
//FROM 'LDAP://$(RootDse)'
FROM 'LDAP://UWHIS.HOSP.WISC.EDU/OU=All Users,DC=UWHIS,DC=HOSP,DC=WISC,DC=EDU'
where objectClass = 'User'
AND objectCategory = 'Person'
AND displayname>'$(arg)'
Order By displayname
;
EXIT DO WHEN ScriptError > 1 // Stop loop if SELECT has error
EXIT DO WHEN NoOfRows('UserTable') = 0; // Stop loop if SELECT returns nothing
EXIT DO WHEN peek('displayname') = '$(arg)'; // If the last "name" read is EQ to arg -- no more entries
LET arg=peek('displayname'); // Set the arg to the last "name" read
trace ($(arg));
LOOP
Hello, Any new about your issue because I have exactly the same one.
You have find any solutions?
Regards
Have a look at the following Microsoft links:
The one thing that comes to mind is I believe R&D changed the API we use to talk to the directory to a newer one, so the above link may help in that regard, as that info was posted around the same time we would have done that update, but that is my best hunch as to why it stopped, the change in the Windows API we are using, potentially. Sorry I do not have anything better here.
Regards,
Brett