Having issues on loading data in Section Access

[#1]

Hi Qlik,

I'm currently using Qlik Sense 3.0. So I'm having issues on my script in the section access. I'm trying to access/load data from the qlik sense repository database.  No issues with it. But once  I load the data from a previously loaded table it locks my account. Here's my code:

LIB CONNECT TO 'ABC';
Users:
NoConcatenate
LOAD 'USER' as ACCESS, UserDirectory & '\' & UserId as USERID, NUM(Name) as NUMBER;
Select "C"."Name", "A"."UserId", "A"."UserDirectory"
From "TableA" "A"
inner join "TableB" "B" on "A"."ID" = "B"."BUser_ID"
inner join "TableC" "C" on "B"."B_ID" = "C"."ID";

SECTION Access;
NoConcatenate
LOAD upper(ACCESS), USERID, num(NUMBER)
Resident 'Users'; 

Section Application;

-----------------------------------------------------
But if I store the data from the joined tables into a file and then on the section access I load the data where I store it from(text file), it works perfectly not sure why the code above locks my user account. I even tried converting the "NUMBER" column.

Cheers,
sv

[vinieme12]

have you tried with preceding load?

LIB CONNECT TO 'ABC';

SECTION Access;

LOAD ACCESS,USERID,NUMBER ;

LOAD

USER' as ACCESS,

UserDirectory & '\' & UserId as USERID,

NUM(Name) as NUMBER;
Select "C"."Name", "A"."UserId", "A"."UserDirectory"
From "TableA" "A"
inner join "TableB" "B" on "A"."ID" = "B"."BUser_ID"
inner join "TableC" "C" on "B"."B_ID" = "C"."ID";

Section Application;

[#3]

Hi Vineeth,

Thanks for the quick response. I've tried with the preceding load, but no luck. It still locks my user account.

sv

[Levi_Turner]

So to be clear, if you dump the same outputs as a QVD file then use that QVD file for Section Access then it loads successfully?

[#5]

yes it does...

[rupamjyotidas]

Resident Load and Section Access sometimes doesn't work as intended, I don't have any explanation for that

Doing a resident load of mixed case data there may lock you out.

Just doing this would probably resolve your problem:

SectionTable:

LOAD Upper(ACCESS) as ACCESS, 

          Upper(USERID) AS USERID,

          num(NUMBER) as NUMBER

Resident Users;