Section Access error Access was denied after reload

[Nao_Baba]

If a Qlik Sense document uses Section Access to restrict user access, the following error may be seen during data load:

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

Environment

• Qlik Sense Enterprise on Windows
• Qlik Cloud Analytics

Resolution

Multiple root causes and matching solutions exist: 

The user loading the script does not have ADMIN permission in Section Access

Verify that the user executing the script has ADMIN access in the Section Access table.

Field data is not upper-case

All field data (such as userID, email) must be written in upper-case.

Column name for Section Access (ACCESS, USER.EMAIL, USERID, etc) is wrong

Make sure the column names are correct. If these are not matched, use an "as" prefix to adjust it.

Example: ACCESS, USERID, USER.EMAIL

LOAD ACCESS, 
  EMAIL as USER.EMAIL, 
  REDUCTION, 
  OMITGROUP; 

SELECT ACCESS, 
  EMAIL, 
  REDUCTION, 
  OMITGROUP

Cause

• The user loading the script does not have ADMIN permission in Section Access
• Field data is not upper-case
• Column name for Section Access (ACCESS, USER.EMAIL, USERID, etc) is wrong

Related Content 

• Managing data security with Section Access (Qlik Sense on-premise)
• Managing data security with Section Access (Qlik Cloud Analytics)