Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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!
Tried it too, no luck. I also tried a few combinations of upper & lower case, no luck.
I expect the error to be somewhere around the section application section maybe? Maybe I'm not typing it right?
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`;
@DawidDaw , Give a name to section access table , also ',' is missing from INTERNAL\SA_SCHEDULER row, I have highlighted it.
Try now
Section Access;
Table:
LOAD * inline [
ACCESS, USERID, REDUCTION
ADMIN, WIN-HOSTNAME\xxx-adm, *,
USER, WIN-HOSTNAME\finance, FINANCEDEP
ADMIN, INTERNAL\SA_SCHEDULER, *,
];
Section Application;
Still no luck 😞 I will be taking the time tomorrow to build an application from stratch with only inline data and see if it works then following "the book" or other working examples I find online. If it still doesn't work then, I'll open a ticket with Qlik Support.
I'll post back thanks for helping