Issue with section access

[chaudharybilal]

Hi,

We are facing a issue with reloading of application with section access. We have three applications and two reduction fields. App1 is being reduced on reduction1, App2 on reduction2 & App3 on both reduction1 & reduction 2.

We've added the INTERNAL/SA_SCHEDULER user & qlik service account user with all possible values of redcution1 & reduction2. Given access to all applications & data connections.

App1 & App2 are running like a charm. But the reload task of App3 keep on failing without any error in the log. If I try to reload it using script editor it works. All apps have same properties, App3 is just a combination of app1 & app2. 

I've searched the internet and most of the problems are solved by adding internal/sa_scheduler user. But I've already done that, and two of our apps are running fine.

I've tried to restart the services, restart the machine, tried to make a copy of the application but nothing works.

If I remove the section access part, the application runs fine. 

The frustrating thing is that Log files are not showing any error, it says "Execution completed" in the last line.

[tresesco]

Could you post the section access you are using in App3?

[chaudharybilal]

Hi,

Following is the section access for App3:

SECTION ACCESS;
LOAD
ACCESS,
USERID,
PRSNA,
CITY
FROM [lib://DaaS_QVD_Extracts (a0310pnbiapp14_qlik_admin)/ROW_Security.qvd]
(qvd);

SECTION Application;

App2:

SECTION ACCESS;
LOAD
ACCESS,
USERID,
PRSNA
FROM [lib://DaaS_QVD_Extracts (a0310pnbiapp14_qlik_admin)/ROW_Security.qvd]
(qvd)
WHERE PRSNA <> NULL();

SECTION Application;

App1:

SECTION ACCESS;
LOAD
ACCESS,
USERID,
CITY
FROM [lib://DaaS_QVD_Extracts (a0310pnbiapp14_qlik_admin)/ROW_Security.qvd]
(qvd)

WHERE CITY<> Null();

SECTION Application;

[chaudharybilal]

So, now App1 is also failing, even after disabling section access, both App1 & App3 are not running, but App2 is.

Also, I got a weird error in Log>Engine>System and it says something like

command=Doc::DoSave;Result=9001

And in audit I got something like

SaveApp_Internal caught extended exception 9001: Read Failed

Not sure what is wrong. 😕