1 Reply Latest reply: Feb 6, 2013 2:11 PM by Nicole Smith RSS

    Error Count = 5

    Helen Pippard

      Hello

       

      I was wondering whether anyone has any further suggestions for me to try, as I have trawled the interent looking for answers and have tried the following because:

       

      After adding section access to a document, a document fails to run on the Enterprise management console and I get an Error Count = 5

       

      1.  Everything is written in the scrip in UPPER CASE

      2.  I have added the service name as ADMIN to the spreadsheet I.e. .\qlik_serv

      3.  I have reloaded the document before running it on the scheduler

      4. I have tried loading on the scheduler with and without NTDOMAINSID

       

      When I manually run the script, I am doing so on the sever through Qlikview Designer/devleoper

       

      The information in the section access is being pulled through from an excel spreadsheet, and I have attached an example for your reference along with the script I have written

       

      Script:

       

      SECTION ACCESS;
      LOAD
         'S-1-5-21-133631074-2907035605-456469473' as NTDOMAINSID,
           USER as NTNAME,
           ACCESS as ACCESS,
           PATIENT_LEVEL,
           SHEET_ACCESS
      FROM
      C:\QLIKVIEW\DEVELOPMENT\ACCESS\Dashboard_Access.xlsx
      (ooxml, embedded labels, table is ACCESS);
      SECTION APPLICATION;
      ACCESS_CONTROL:
      load * INLINE [
      PATIENT_LEVEL,access_type
      1,Y
      0,N
      ];
      SHEET_ACCESS:
      LOAD *
      FROM
      C:\QLIKVIEW\DEVELOPMENT\ACCESS\Dashboard_Access.xlsx
      (ooxml, embedded labels, table is SHEETS);

       

      Does anyone have any further suggestion? I have contacted our supplier, and they have suggested all of the above and they still do not have an answer

       

      Thanks

      Helen

       

        • Re: Error Count = 5
          Nicole Smith

          Even though everything we had was uppercase, we still had to use the upper() function to get our section access to work.  Here is what ours looks like (and it's working properly on desktop and server):

           

          Section Access;

          LOAD upper(ACCESS) AS ACCESS,

               upper(USERID) AS USERID,

               upper(ENTITYID) as SECTIONACCESSENTITYID;

          SQL EXEC procExtractSecurityMatrix 'ALL';

          Section Application;