When Section Access is enabled as per example under the section Dynamic Data Reduction, reloading via Hub fails with the following message:
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.
Reloading via Qlik Management Console manually under Apps > More Actions > Reload now, or by scheduling a task works, but then Hub user is locked out and can only open the app without data. (right-click app > Open without data)
Environment:
- Qlik Sense Enterprise, all versions
Cause:
In the example provided below, the currently logged on user (i.e. NOT the "INTERNAL\SA_SCHEDULER") does not have full ADMIN permissions required to load the REDUCTION field under the "section application;" section. The reload task works from QMC manually or when the reload task is scheduled since the task is run by INTERNAL\SA_SCHEDULER.
section access;
LOAD * inline [
ACCESS, USERID, GROUP, REDUCTION, OMIT
USER, *, ADMIN, *,
USER, *, A, 1,
USER, *, B, 2, NUM
USER, *, C, 3, ALPHA
USER, *, GROUP1, 3,
ADMIN, INTERNAL\SA_SCHEDULER, *, *,
];
section application;
T1:
LOAD *,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;
Resolution:
Assigned the user reloading the app via Hub Section Access ADMIN level permission.
i.e:
section access;
LOAD * inline [
ACCESS, USERID, GROUP, REDUCTION, OMIT
ADMIN, <user logged in>, *, *,
...
