Section access and automatic reload in Sense

[#1]

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

[#2]

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

[#3]

Hello.

Anybody has done a reloading data in a scheduled task?

[#4]

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.

[#5 · Accepted solution]

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.

[Anonymous]

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