topic Section access and automatic reload in Sense in QlikView

Section access and automatic reload in Sense

Tue, 02 Dec 2014 12:43:16 GMT

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

Re: Section access and automatic reload in Sense

Fri, 05 Dec 2014 10:00:47 GMT

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

Re: Section access and automatic reload in Sense

Wed, 10 Dec 2014 15:13:34 GMT

Hello.

Anybody has done a reloading data in a scheduled task?

Re: Section access and automatic reload in Sense

Thu, 16 Apr 2015 16:06:12 GMT

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.

Re: Section access and automatic reload in Sense

Wed, 26 Aug 2015 19:11:39 GMT

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.

Re: Section access and automatic reload in Sense

Anonymous — Thu, 27 Aug 2015 11:48:30 GMT

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