topic Re: Qlik Sense Post Upgrade Issue in Management & Governance

Qlik Sense Post Upgrade Issue

Purushothaman — Mon, 14 Jun 2021 01:47:16 GMT

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.

Re: Qlik Sense Post Upgrade Issue

Maria_Halley — Mon, 14 Jun 2021 08:32:44 GMT

@Purushothaman

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

Re: Qlik Sense Post Upgrade Issue

rzenere_avvale — Mon, 14 Jun 2021 08:37:33 GMT

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

Re: Qlik Sense Post Upgrade Issue

Purushothaman — Tue, 15 Jun 2021 06:28:37 GMT

@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

Re: Qlik Sense Post Upgrade Issue

rzenere_avvale — Tue, 15 Jun 2021 06:35:44 GMT

Hey @Purushothaman ,

You have two alternatives:

(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
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

Re: Qlik Sense Post Upgrade Issue

Purushothaman — Tue, 15 Jun 2021 06:42:38 GMT

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

load * inline

[

ACCESS,USERID,OUTLET

ADMIN,INTERNAL\sa_scheduler,*

];