Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

helen_pip
Contributor II

Error Count = 5

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

1 Reply

Re: Error Count = 5

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;