Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
bradmahan
New Contributor

Section Access and Access Point

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.

3 Replies
pradosh_thakur
Honored Contributor II

Re: Section Access and Access Point

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

Learning never stops.
bradmahan
New Contributor

Re: Section Access and Access Point

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

];

pradosh_thakur
Honored Contributor II

Re: Section Access and Access Point

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)

Learning never stops.