topic Re: Section Access and Access Point in QlikView

Section Access and Access Point

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Section Access and Access Point

pradosh_thakur — Fri, 13 Oct 2017 18:18:09 GMT

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

Re: Section Access and Access Point

Anonymous — Fri, 13 Oct 2017 18:24:28 GMT

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...

];

Re: Section Access and Access Point

pradosh_thakur — Fri, 13 Oct 2017 18:36:10 GMT

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)