Qlik Sense Post Upgrade Issue

[Purushothaman]

We have upgraded  Qlik sense from April 2018, Patch 1 to Feb 2021, Patch 7. 

After the upgrade, I have some apps that fail to load from QMC Task, but are fine when I load data using Data Load Editor. The tasks in the red box are those that ran after the upgrade. The 3 selected ones keep failing. I have tried to reload the data using data load editor, then republish the app, and try to rerun the reload from task, but they still fail.

Could you check what could be the issue? Not sure if this will happen for the other apps whose reload tasks are not executed yet...

Attached are the log file and screenshot for your reference. 

[Maria_Halley]

@Purushothaman 

Since this is a question about QlikSense I will move to the QlikSense board

[rzenere_avvale]

Hey there @Purushothaman ,

I believe you're missing the 'INTERNAL\SA_SCHEDULER' user in your section access.
This user is a Service Account user, which is used by Qlik Sense to perform the reload of applications when a task is set.

You can find more here,: Managing data security with Section Access 

I hope this helps,
Riccardo

[Purushothaman]

@rzenere_avvale 

This how my session access looks, Attached is the image.  where should I add the INTERNAL\SA_SCHEDULER

Can you help me to type here for me. Please! 

Thank you

[rzenere_avvale]

Hey @Purushothaman ,

You have two alternatives:

1. (suggested) Add to the Dw_Test.dbo.UserDataAuthorization table a row, with ACCESS = ADMIN, USERID = INTERNAL\SA_SCHEDULER
   This row will then be read by all the applications, and allow task reloads.
   Note that a reload from hub is required after the change, in order to injest the new user into the Section Access
2. Concatenate a row using an inline table like this:
   (at row 14) Concatenate
   Load * Inline [
   ACCESS,    USERID, OUTLET
   ADMIN,    INTERNAL\SA_SCHEDULER,
   ];
   
   This second approach needs to be applied on each application that has section access and I personally find it less manageable over time.

The final choice is up to you/your department, but in the end I suggest the first approach in order to have somewhere (in this case in your database) a table will all the profiled users

I hope this helps,
Riccardo

[Purushothaman · Accepted solution]

Hi, I followed this method, Its working. All Task are able to reload successfully. 

load * inline

[

ACCESS,USERID,OUTLET

ADMIN,INTERNAL\sa_scheduler,*

];