Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DawidDaw
Contributor III
Contributor III

Section access won't reload app - parameters seem correct

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_0-1610633825683.png

 

My section access looks as follows:

Section Access;

LOAD * inline [
ACCESS, USERID, REDUCTION, OMIT
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`;

 

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 recognise the username, but I copied the name & user directly straight from the QMC (and it actually matches the windows user directory so it should work).

 

I'm at wits end here, any suggestions?

 

Thanks!

 

0 Replies