Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access and automatic reload doesn't work 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.

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 a lot.

Regards

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

3 Replies
Not applicable
Author

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.

Not applicable
Author

Hi, Daniel.

It works!!!

Thank you very much.

Regards.

Marcos

Not applicable
Author

How to add in INTERNAL\SA_SCHEDULER and where? My section access is --

Section Access;

LOAD

    '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);

Section Application;

LOAD

    //'QLICKSENCESERVE\'& USERID AS "USERID",

     UPPER(PROJECT_ID) as PROJECT_NAME

FROM [lib://Section Path (qlicksenceserve_administrator)/projects names with managers.xlsx]

(ooxml, embedded labels, table is Sheet2);

and Table is--

sectionaccess Table.PNG

KIndly guide.

Thanks

Tanushree Roy