Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;