topic Re: Server Failed To Reload in QlikView

Server Failed To Reload

helen_pip — Mon, 14 Jan 2013 12:34:02 GMT

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

Re: Server Failed To Reload

Mon, 14 Jan 2013 12:38:49 GMT

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

Re: Server Failed To Reload

helen_pip — Mon, 14 Jan 2013 12:47:49 GMT

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

Re: Server Failed To Reload

Mon, 14 Jan 2013 13:06:45 GMT

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?