Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Reload failed after adding section access

Hi experts,

Our app has been working fine with both manual reload and scheduled task of reload. However, after we add section access, it is fine to load data in script, but failed for both manual and scheduled reload.

Any one know the reason and the solution?

Thanks for you help in advance!

Jing

1 Solution

Accepted Solutions
vlad_komarov
Valued Contributor III

Re: Reload failed after adding section access

Jing,

Have you added a System user to the Section Access:

ACCESS, USERID, REDUCTION, OMIT

ADMIN, INTERNAL\SA_SCHEDULER,*,

ADMIN, AAAAA\YOUR_NAME,*,

You are using your own account to load the app from the script, but you should allow the system user (which is running the scheduled tasks) to do the same.

Hope it helps.

Regards,

Vlad

10 Replies
Not applicable

Re: Reload failed after adding section access

I have other questions: why I cannot download the log. The button is disabled. Where is the log file located?

reloadfailed.JPG

BTW, Engine is running without any problem.

njmaehler
New Contributor III

Re: Reload failed after adding section access

Hello,

The Log file in is the same directory as the model. It will have the same name but a txt extension.

e.g. if your model is called Sales.qvw then the log file is Sales.txt

To make sure you are creating the log file check that under the Settings menu then Document Properties option and on the General tab you have the second checkbox ticked which is Generate LogFile

When you have created your section access then you must check that you have also set these properties.

Again, under the Settings menu then Document Properties option and on the Opening tab then half way down the tab you need to check the checkbox for Initial Data Reduction Based on Section Access and the checkbox for Strict Exclusion too.

This should be enough for the manual reload.

For scheduled reloads you will need to provide the Username and Password for the reload.

You do this in the QlikView Management Console under the Documents tab (select your model you want to reload) then on the Reload tab at the bottom tick the Section Access checkbox and set the username and password.

Also, make sure that you have an admin set up in the section access otherwise you could lock yourself out!

Hope that helps,

Nicky

fkeuroglian
Honored Contributor

Re: Reload failed after adding section access

Hi Jing

For the log you could search in C:\ProgramData\Qlik\Sense\Log\  or

c:\programdata\qlik\sense\log\script

c:\programdata\qlik\sense\repository\Archived Logs\[serverName]\script

For the error in section acces, can you pass what you recently add in your code?

try to put and exit script in some part to the script to know and discovery where the error is.

Fernando K.

vlad_komarov
Valued Contributor III

Re: Reload failed after adding section access

Jing,

Have you added a System user to the Section Access:

ACCESS, USERID, REDUCTION, OMIT

ADMIN, INTERNAL\SA_SCHEDULER,*,

ADMIN, AAAAA\YOUR_NAME,*,

You are using your own account to load the app from the script, but you should allow the system user (which is running the scheduled tasks) to do the same.

Hope it helps.

Regards,

Vlad

dcj
Valued Contributor II

Re: Reload failed after adding section access

Dear Jin,

   Take a look on your script if you inserted the Qlik Sense users services, because this user is responsible to access the app and reload it.

   Also, look this help because is necessary add some other local users like INTERNAL\SA_SCHEDULER

Managing security with section access ‒ Qlik Sense

   Please, mark the CORRECT and/or HELPFULL comments.

Regards,

Not applicable

Re: Reload failed after adding section access

Thanks Nicky. I am using Qlik Sense. How can I set document properties option in Qlik sense?

dcj
Valued Contributor II

Re: Reload failed after adding section access

Dear Jing,

   This is recognized by Qlik on old version (FR 2.1). Currently this issue not occurs.

   Tap on this page on your left/up corner the two arrows and try do download script log.

Regards.

Not applicable

Re: Reload failed after adding section access

Thank you so much Vlad! After I add the system user, everything is working perfectly for me! You made my day!

Not applicable

Re: Reload failed after adding section access

thanks Ricardo!