Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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
DawidDaw
Contributor III
Contributor III
Author

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`;

Qlik1_User1
Specialist
Specialist

@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;

DawidDaw
Contributor III
Contributor III
Author

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