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

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

Re: Server Failed To Reload

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
Contributor II

Re: Server Failed To Reload

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

Re: Server Failed To Reload

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?