Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Scheduled task failing in Qlik Sense if App contains Section Access

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Bjorn_Wedbratt
Former Employee
Former Employee

Scheduled task failing in Qlik Sense if App contains Section Access

Last Update:

Jun 1, 2021 9:21:41 AM

Updated By:

Sonja_Bauernfeind

Created date:

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  

 

Environment:


 The same script will work in QlikView.

 

Resolution

 

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.

Example

Assuming QDS is configured to run using Domain Account DOMAIN\qvservice
 

Section Access;
LOAD * INLINE [
ACCESS, USERID
ADMIN, DOMAIN\QVSERVICE
];


Qlik Sense

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.

Example

Section Access;
LOAD * INLINE [
ACCESS, USERID
ADMIN, INTERNAL\SA_SCHEDULER
];




 

Labels (1)
Contributors
Version history
Last update:
‎2021-06-01 09:21 AM
Updated by: