Section Access problem

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Section Access problem

Wed, 11 Jul 2012 10:40:50 GMT

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

topic Section Access problem in QlikView

Section Access problem

Re: Section Access problem