Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
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.
Thanks a lot.
Regards
The reload task is completed under the context of the INTERNAL\sa_scheduler user. The only solution I found was to add this user as ADMIN to every section I have defined in section access. After doing this the scheduled reload was successful from the task.
Hi, people.
Any idea?
My section access is like that:
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION
USER, SERVERQLIK\admin,
USER, SERVERQLIK\user1, *
USER, SERVERQLIK\user2, 1537
USER, SERVERQLIK\user2, 1539
];
section application;
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
ADMIN, SERVERQLIK\admin,
the app will be corrupted.
If I change the column ACCESS in admin user, like that:
ACCESS, USERID, PASSWORD, REDUCTION
ADMIN, SERVERQLIK\admin, XXX,
the app will be corrupted too.
If I change the column ACCESS in admin user, like that:
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, XXX,
the app will be corrupted too.
Reloading data in a scheduled task is possible with secction access in Sense Server?
Thanks.
Regards.
Marcos
Hello.
Anybody has done a reloading data in a scheduled task?
That's unfortunate Marcos. I even tried simple section access in Qlik Sense but it says "Access is denied":
Simple Qlik Sense Section Access
Qlik really need to rescue their product and invest on some support for it.
The reload task is completed under the context of the INTERNAL\sa_scheduler user. The only solution I found was to add this user as ADMIN to every section I have defined in section access. After doing this the scheduled reload was successful from the task.
Agreed. The only way I can find to get it to work is like this:
Section Access;
// INTERNAL\SA_SCHEDULER is necessary to allow the data load to run automatically
// [machine name]\Administrator ensures we can log in to administer Qlik
LOAD * Inline [
ACCESS, USERID, _ORGANIZATIONID
ADMIN, INTERNAL\SA_SCHEDULER, *
ADMIN, WIN-8AONVV2DOAM\Administrator, *
];
// Define the actual users' access rules...
Section Application;
(Where _ORGANIZATIONID is the field I use for reduction.)