Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I have been having difficulty moving a Qlikview application with access point from dev -> production (Access Point). I have successfully partitioned access to users using Section Access and confirmed using test values. However, when I go to load the application on QMC Server the task errors out when I try and run it.
I've looked back on some posts and it seems that this was a problem years ago, does anyone have or heard of a solution for this problem yet?
Thanks for your help.
Have you added the service account user as admin in the section access script? Are you using username password or ntname authentication?
Share the section access script if possible.
Regards
Pradosh
No I have not added a service account user as admin, how do I do that?
I am using username password...
Section access;
LOAD ACCESS,
UPPER(USERID) AS USERID,
UPPER(PASSWORD) AS PASSWORD,
REDUCTION AS [DISTRIBUTOR NO]
FROM [..\QVD\SectionAccess.QVD] (qvd)
WHERE 1=1;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, DISTRIBUTOR NO
ADMIN, ADMIN, LYCOMING, <ALL>
USER, USER1, DIST1,3397
etc...
etc...
];
Ask for your service account user name and use it in the inline load. It should be domain name /sa name. Use * instead of all use upper( reduction field)