Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Section access and automatic reload in Sense

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Section access and automatic reload in Sense

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.

View solution in original post

5 Replies
Highlighted
Not applicable

Re: Section access and automatic reload in Sense

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

Highlighted
Not applicable

Re: Section access and automatic reload in Sense

Hello.

Anybody has done a reloading data in a scheduled task?

Highlighted
Not applicable

Re: Section access and automatic reload in Sense

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.

Highlighted
Not applicable

Re: Section access and automatic reload in Sense

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.

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Section access and automatic reload in Sense

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