Discussion board where members can get started with Qlik Sense.
I have an app with section access and reduction data in Sense Server.
If I create a task for reloading data automatically, it doesn't work.
I get an error "access denied".
In QV, if I create a reloading task with section access I can enter user and password. But in Sense Server?? Where can I enter user and pass??
I can reload data inside the app. But I can't do it in qmc.
My section access is like that:
LOAD * inline [
USER, SERVERQLIK\user1, *
USER, SERVERQLIK\user2, 1537
USER, SERVERQLIK\user2, 1539
The task for reloading data in Sense server doesn't work with section access.
If I change the column ACCESS in admin user, like that:
ACCESS, USERID, REDUCTION
the app will be corrupted.
ACCESS, USERID, PASSWORD, REDUCTION
ADMIN, SERVERQLIK\admin, XXX,
the app will be corrupted too.
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, XXX,
Reloading data in a scheduled task is possible with secction access in Sense Server?
Thanks a lot.
Go to Solution.
You have to add the INTERNAL\SA_SCHEDULER User to your Section Access Table. This is missing in the Documentation and will be fixed soon.
Thank you very much.
How to add in INTERNAL\SA_SCHEDULER and where? My section access is --
'QLICKSENCESERVE\'&[USERID] AS [USERID],
Upper( [ACCESS]) as [ACCESS],
UPPER([PROJECT_ID]) as PROJECT_NAME
FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]
(ooxml, embedded labels, table is Sheet2);
//'QLICKSENCESERVE\'& USERID AS "USERID",
UPPER(PROJECT_ID) as PROJECT_NAME
and Table is--