Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Could someone kindly provide me with some advice to what to check next
I have a document which I had scheduled on the enterprise managment console and it was reloading O.K. this morning
I then added in section access information and I think the document then starting failing to reload
I decided to comment the section access out and start again and turned the Relaod Schedule to None
I ahve rescheduled and the document now fails every time it tries to reload
I have turned on "Generate Log" in the QVW but this is not being generated
Does anyone have any suggestions?
Thanks
Helen
If you added section access, make sure, that the admin user, reload engine is using, is added to section acess.
If you commented it out, it should work like it used to worked. (did you leave the doc name the same...)
Hello
Thank you for your reply and advice
Below is the section access I have been using....Does it look sufficient to you?
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\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\ACCESS\Dashboard_Access.xlsx
(ooxml, embedded labels, table is SHEETS);
I keep the set up of usernames in a spreadsheet
Thanks
Helen
I use such version.....
Section access;
LOAD * INLINE [ ACCESS, NTNAME, NTDOMAINSID
ADMIN, USER1, XXXXXXXXXXX
ADMIN, USER2, XXXXXXXXXXX
ADMIN, USER3, XXXXXXXXXXX
ADMIN, QVSERVICE, XXXXXXXXXXX // I have this user as my admin user.....
USER, USER4, XXXXXXXXXXX
USER, USER5, XXXXXXXXXXX
USER, USER6, XXXXXXXXXXX
];
Section Application;
Do you have „your“ QVSERVICE (this is the user, witch QMC is using to reload files) written into your xls spreadsheet - Dashboard_Access.xlsx?