Why doesn't this load? (Qlik Sense Section access)

[trappersw]

Why doesn't this load in Qlik Sense server (it loads withing 20" when the section access and section application are commented)

Section access;

Security:

load *;

SQL SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

      union all

SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

           where isnumeric(substring([user_id],5,100))=0 and

         substring([user_id],5,100) like '%.%';

Concatenate

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER,         *

];

Section application;  

Securityapp:

load *;

SQL SELECT

       [KEY_AD_GROUP] as REDUCTION,

       key_business+'_'+key_market as BusinessMarket

FROM [WH_ID_EMEA].[cfg].[AD_Access];

[Gysbert_Wassenaar · Accepted solution]

Have you tried it this way?

Security:

SQL SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN1\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

      union all

SELECT distinct

      'USER' as 'ACCESS',

       upper(ltrim(rtrim([AD_Group]))) as REDUCTION,

      'DOMAIN2\'+ upper(ltrim(rtrim([user_id]))) as USERID

FROM [WH_ID_EMEA].[stg].[AD_Group_Member]

           where isnumeric(substring([user_id],5,100))=0 and

         substring([user_id],5,100) like '%.%';

CONCATENATE (Security)

LOAD * INLINE [

ACCESS, USERID, REDUCTION

USER, INTERNAL\SA_SCHEDULER,         *

];

Section access;

LOAD * RESIDENT Security;

Section Application;

...etc