Section access won't reload app - parameters seem correct

DawidDaw — Thu, 14 Jan 2021 14:23:33 GMT

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, 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!

topic Section access won't reload app - parameters seem correct in Management & Governance

Section access won't reload app - parameters seem correct