topic Re: Function call from Load Script fails when relaoded using command line in QlikView

Function call from Load Script fails when relaoded using command line

bnichol — Mon, 10 Jan 2011 21:23:15 GMT

I am passing a string to a macro function from the Qlikview load script. The load executes correctly when run manually in the developer client, but if fails when I reload using either publisher or the command line.

Here's the function that I'm calling...

Function GroupMembers(DN)
Set objItem = GetObject("LDAP://" & DN)
strmember = objItem.GetEx("member")
ret = ""
For Each Item in strmember
ret = ret & Item & ";"
Next
GroupMembers = Left(ret, Len(ret)-1) ' Drop trailing semicolon
End Function

and the load script snippet, that calls it...

GroupMembers:
LOAD
GroupDN,
subfield(GroupMembers(GroupDN), ';') as UserDN
RESIDENT GroupTable
;

Should I be able to execute this function as part of the load script, or is this a limitaion of Qlikview?

Pertinent Facts: Windows Server 2008, 32GB RAM, QVS v9 SR6, QV.exe v9 SR6

Any suggestions would be appreciated,
B

Function call from Load Script fails when relaoded using command line

Oleg_Troyansky — Mon, 10 Jan 2011 21:36:35 GMT

Check Windows security. It might be running under a different User ID when it's running under Publisher or from the Command Line.

Function call from Load Script fails when relaoded using command line

bnichol — Mon, 10 Jan 2011 22:22:37 GMT

As identified in http://community.qlik.com/forums/p/29431/124146.aspx ... "Publisher ignores all macro calls, and it always has been this way".
I was able to run the load script successfully, once I added the /NoSecurity switch to the command line entry "c:\Program Files\QlikView\qv.exe" /nosecurity /r "FileName.qvw"

Re: Function call from Load Script fails when relaoded using command line

qlikviewforum — Mon, 22 Jul 2013 16:36:58 GMT

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum