Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Server Failed To Reload

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

3 Replies
Not applicable

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

helen_pip
Creator III
Creator III
Author

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

Not applicable

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?