Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Section Access problem

Hi,

The following code works:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, NTNAME, NTDOMAINSID

    ADMIN, domain\user1, S-1-5-21-4212263732-3897499842-2088291733

    ADMIN, domain\user2,   S-1-5-21-4212263732-3897499842-2088291733

   

];

SECTION APPLICATION;

If i try to  read section access list from Excel using the following code - won't work:

LET vDocument = 'TEST';

//Location of User_Accss file

LET vExcelDirectory = 'C:\QlikView\QVWorkspace\User Access';

DIRECTORY '$(vExcelDirectory)';

//Domain ID

LET vNTDOMAINID = 'S-1-5-21-4212263732-3897499842-2088291733';

 

tmpSectionAccess:

CrossTable(Document, Authorized, 3)

LOAD NTNAME ,

     ACCESS,

     '$(vNTDOMAINID)' AS NTDOMAINSID,

     Aanvragen,

     app1,

     app2,

     app3,

     app4,

     app5

FROM

[User Access.xlsx]

(ooxml, embedded labels, table is Blad1)

;

SECTION ACCESS;

 

LOAD

           ACCESS,

           NTNAME  

RESIDENT tmpSectionAccess

WHERE Document = '$(vDocument)';

SECTION APPLICATION;

DROP TABLE tmpSectionAccess;

Trying to executed to task in the server generates the following error:

The task "TEST.qvw" failed. Part of the log file follows:

10-7-2012 14:26:42 Error Document open call failed. The document might require username and password.
10-7-2012 14:26:42 Error The document failed to open. Bad Username and password is the most likely cause of this problem.
10-7-2012 14:26:42 Error Document could not be opened
10-7-2012 14:26:42 Error The task "TEST.qvw" failed. Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors

domain\user1 is a domain admin account which runs the QDS service.

Any idea's? It's kinda driving me crazy...

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Section Access problem

solved it. for non-inline load, UPPER should be used...

1 Reply
Not applicable

Re: Section Access problem

solved it. for non-inline load, UPPER should be used...

Community Browser