Can't pull from Active Directory after updating to QlikView November 2017 SP5
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.
CONNECT TO 'Provider=ADsDSOObject';
LET arg=chr(01); // Set search start name to a very low value
'UWHIS.HOSP.WISC.EDU' as Domain;
FROM 'LDAP://UWHIS.HOSP.WISC.EDU/OU=All Users,DC=UWHIS,DC=HOSP,DC=WISC,DC=EDU'
where objectClass = 'User'
AND objectCategory = 'Person'
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
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.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.