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

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

[#2 · Accepted solution]

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.

[#3]

Hi, Daniel.

It works!!!

Thank you very much.

Regards.

Marcos

[#4]

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

KIndly guide.

Thanks

Tanushree Roy