Section Access in Load Script

[mrm]

Hi Experts, please help in resolving this below error in Qlik Sense, when using Section Access; Section Application; in the load script and load data

Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

Data has not been loaded. Please correct the error and try loading again.

please note that prior to the above messages, it correctly shows the Lines fetched from datasource in Section Access and in Section Application

I am loading the data with my ID which is SSO, on Qlik Server. Should my ID have some privileges/settings in Qlik Sense/QMC to get over the above or if something related to my ID should be included in Section Access part. If yes, what and where should they be done. Kindly support. Thanks!

[JordyWegman]

Hi Mrm,

Is your account listed in the section access table?

Jordy

Climber

[VishalWaghole]

Hi,

Could you please try it using Domain\UserName.

Thanks,
Vishal Waghole

[mrm]

Hi Jordy, Thanks for the response.

Yes my ID is included in the table that holds the User permissions (REDUCTION), and that is the table included in the Section Access as below:

Section Access;
AUTHENTICATION:
LOAD
"ACS" as "ACCESS",
"UID" as "USERID",
REDUCTION

RESIDENT rootuser;

rootuser has my ID set-up.

Please advise.

Thanks,

MRM

[mrm]

Hi Vishal,

Thanks for the response.

Please let me know of how to include/try using domain/username. where should i include this in the script? the syntax please.

Thanks,

MRM

[VishalWaghole]

Check below link,

https://community.qlik.com/t5/QlikView-Documents/Introduction-to-Section-Access/ta-p/1478878

Hope this will work for you.

Thanks,
Vishal Waghole

[mrm]

Thanks Vishal, the document was useful. But need clarity on how and where to set up myself as ADMIN, which then would allow me to load and solve the issue. please help.

Thanks,

MRM

[Naor_ISR]

Did you find the solution?