Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DawidDaw
Contributor III
Contributor III

Section access reload error - Unable to reload

Hello,

 

I'm trying to add section access to our application but am unable to reload my app. The error is:

Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

When reloading from QMC, also get an error but the logs aren't very helpful:

DawidDaw_1-1611045578946.png

 

 

My section access looks as follows:

Section Access;

LOAD * inline [
ACCESS, USERID, REDUCTION
ADMIN, WIN-HOSTNAME\xxx-adm, *
USER, WIN-HOSTNAME\finance, FINANCEDEP
ADMIN, INTERNAL\SA_SCHEDULER, *
];


Section Application;
dim_table:
LOAD
AutoNumberHash128(id,date) as table_id,
table_name,
upper(table_id) as REDUCTION;

[dim_table]:
SELECT `table_id`,
`table_name`,
`date`
FROM `schema`.`table`;

#other_tables_in_application_in_separate_script_page#

I have tried different approaches where I swap the names in upper case or lower case, where I remove the section application an try loading the REDUCTION straight from the data, but always the same error.

It looks like he doesn't recognize the usernames, but I copied the name & user directly from the QMC (and it actually matches the windows user directory so it should work).

 

I'm at wits end here, any suggestions?

 

Thanks a bunch!

Labels (1)
12 Replies
Qlik1_User1
Specialist
Specialist

@DawidDaw Everything in Section Access should be in UPPER case, change the highlighted to UPPER Case and than try.

Section Access;

LOAD * inline [
ACCESS, USERID, REDUCTION
ADMIN, WIN-HOSTNAME\xxx-adm, *
USER, WIN-HOSTNAME\finance, FINANCEDEP
ADMIN, INTERNAL\SA_SCHEDULER, *
];

DawidDaw
Contributor III
Contributor III
Author

Thank you for your reply. I had already tried that, but no luck (just tried again) 😞

 

Qlik1_User1
Specialist
Specialist

@DawidDaw Try to run the script in parts and check where its failing 

DawidDaw
Contributor III
Contributor III
Author

Thanks for your reply. The script is not failing as such, it loads fine, but at the end it gives me an error saying the data is not updated because the section access would lock my own user (admin) out, meaning the error is in the section access, but I can't find it.

Whenever I comment the section access, the data loads fine

Qlik1_User1
Specialist
Specialist

@DawidDaw Check if you are logging in with USERID mentioned in Section Access .

DawidDaw
Contributor III
Contributor III
Author

I tried using the admin user & a specific, non admin user, both give the same error. I also tried reloading through the QMC, no luck.

For the user names & server domain, I copied them straigth from the QMC like they appear under the "USER" tab. I tried making them upper or lower case and removing special characters, no luck. It looks like something in my actuals script is wrong

DawidDaw
Contributor III
Contributor III
Author

Thanks again @Qlik1_User1, I do have the INTERNAL\SA_SCHEDULER user as ADMIN. I tried again, chaning that line (adding - instead of * or removing it completely), no luck.

Moreover, I also get the error when loading manually, which is not the case with the person in the other thread, who only gets an error when loading from QMC.

 

Qlik1_User1
Specialist
Specialist

@DawidDaw Try to use '_' instead of '-' in section access.


FROM -- WIN-HOSTNAME\xxx-adm
TO -- WIN_HOSTNAME\XXX_ADM