Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jun 1, 2021 9:21:41 AM
Nov 28, 2014 3:42:29 AM
Reload tasks fail when scheduled or when run manually via Qlik Management Console (QMC) for App(s) that contains Section Access.
When the reload is run via the Hub it concludes successfully. Otherwise the scrip logs exists with "Execution Failed" with no additional clues. See the example below:
2019-06-18 23:09:20 2623 EXIT Script
2019-06-18 23:09:21 Execution Failed
2019-06-18 23:09:21 Execution finished.
Investigating the log file <Servername>_System_Engine.txt shows a warning message similar to:
WARN QlikViewServer System.Engine.Engine 3456 7a129cd7-698f-427f-9379-88b075c76f1f DOMAIN\account Document Load: The document 18bdfe04-0b2d-4fe9-9522-6af78ad34fad failed to load because of no access [5]. INTERNAL sa_scheduler 20141125T143007.230+0100 5848 4028 20141013T151344.000+0200 7a129cd7-698f-427f-9379-88b075c76f1f
or
WARN domain System.Engine.Engine 89 6ac41964-2910-4a17-9162-c40119b2d3d6 domain\qliksense System: DetermineAccess: Failed to access the following document af18ffcb-6b60-4546-9fa5-f385172eebec with the user: 0 INTERNAL sa_scheduler 20181126T181325.903+0100 6864 7120 eaa1c5c2-1850-40cb-a490-0e6158df82b0 af18ffcb-6b60-4546-9fa5-f385172eebec 20181126T181055.000+0100 6ac41964-2910-4a17-9162-c40119b2d3d6
The same script will work in QlikView.
In QlikView you need to add the account running QlikView Distribution Service (QDS) with access ADMIN in Section Access, to make sure the service can open the application during reload.
Assuming QDS is configured to run using Domain Account DOMAIN\qvservice
Section Access; LOAD * INLINE [ ACCESS, USERID ADMIN, DOMAIN\QVSERVICE ];
In Qlik Sense access to resources, such as Apps, are governed by the Repository Service. An internal account for each service is created in the PostgreSQL database during setup, such as the sa_scheduler account above. For the Scheduler to be able to access the App during reload, this account must be added into Section Access, not the account running the actual service.
See also the help documentation:
"The INTERNAL\SA_SCHEDULER account user is required to enable reload of the script in a Qlik Management Console task."
Managing user access to specific data in an app
Make sure the account INTERNAL\SA_SCHEDULER is added to Section Access with access ADMIN.
Section Access; LOAD * INLINE [ ACCESS, USERID ADMIN, INTERNAL\SA_SCHEDULER ];