topic Re: QlikSense November2018 Path1 Section Access Report failed in App Development

QlikSense November2018 Path1 Section Access Report failed

srinu_qliksense — Mon, 31 Dec 2018 10:42:22 GMT

Hi ,

I am facing issue in Qlik November 2018 Patch 1, Not in Earlier Versions.

I am using section access for one report.

I am able to load(run) the report from hub and it is successfully completed.

After that scheduled the report from TASK Manger window. The Report is failed with "Execution Failed" (log message).

If I Comment the section access part then the report running the successfully.

Re: QlikSense November2018 Path1 Section Access Report failed

Gysbert_Wassenaar — Mon, 31 Dec 2018 14:45:25 GMT

Make sure to include the user INTERNAL\SA_SCHEDULER in the section access table with ADMIN access. Otherwise the document can not be reloaded succesfully using a reload task.

Re: QlikSense November2018 Path1 Section Access Report failed

srinu_qliksense — Wed, 02 Jan 2019 08:41:42 GMT

Thank you ... its helped ...

But want to know what this is not happened in earlier versions of Qlik

Re: QlikSense November2018 Path1 Section Access Report failed

Vegar — Wed, 09 Jan 2019 23:02:33 GMT

Hi I experienced the same issue in November 18 patch 2.

My Section Access is handled in an Excel-file and I noticed that I had an whitepace in the SA_SHEDULER USERID cell, like this: "INTERNAL\SA_SCHEDULER ", when removed the tailing whitepace to "INTERNAL\SA_SCHEDULER" then the task ran successfully.

This has not caused any problem in prior to November 18, so my guess is that Qlik Sense became more sensitive to whitespaces in excel in this release.

Re: QlikSense November2018 Path1 Section Access Report failed

Gysbert_Wassenaar — Thu, 10 Jan 2019 06:37:55 GMT

In the QS November 2018 release a change was implemented that makes it necessary to include the internal scheduler service account in the section access table. This was not necessary previously.

Re: QlikSense November2018 Path1 Section Access Report failed

mborsadw — Wed, 06 Feb 2019 20:32:54 GMT

This means Qlik is not backward compatible. I have to go and fix all my apps now. That sucks!

Does anybody what is Qlik's take on backward compatibility. I am going to file a support ticket issue with them anyway.

Re: QlikSense November2018 Path1 Section Access Report failed

Vegar — Wed, 06 Feb 2019 21:04:04 GMT

It depends on how you look at it.

If you read the help chapter for section access from version 2.0 it states that the INTERNAL\SA_SCHEDULER shold be included for execution in the QMC. I remember I had som issues due to not including the sheduler in 3.x

In this later release Qlik Sense have become more strict regarding this. The good thing is that from now on you can't forget without noticing it.

Re: QlikSense November2018 Path1 Section Access Report failed

stvegerton — Wed, 20 Feb 2019 18:01:30 GMT

Qlik should have put this CHANGE into the Nov 18 release notes.