1 Reply Latest reply: Jul 11, 2012 6:40 AM by Dror Svartzman RSS

    Section Access problem

    Dror Svartzman

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