topic Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error in App Development

Qlik Sense Reload fails randomly; Unknown LOAD statement error

dselgo_eidex — Sat, 16 Nov 2024 05:48:47 GMT

Hello, as the title suggests, I am currently getting an "Unknown LOAD statement error" message when I am trying to reload my app. The strange part is that this doesn't happen on every reload. Most of the time, it reloads fine, but every once in a while it will give this error message. If you try to reload after getting the error, it will reload just fine. Even so, we have a reload task scheduled to execute nightly, so we don't want it failing during that.

It always fails at the same place, typically 10 seconds in when we are getting our Section Access set up.

Section Access; LOAD 'ADMIN' AS ACCESS, userid AS USERID, field1 AS FIELD_1, field2 AS FIELD_2, field3 AS FIELD_3 SQL SELECT * FROM Users; Concatenate Load * Inline [ ACCESS, USERID ADMIN, INTERNAL\SA_SCHEDULER ]; Section Application;

It fails during the "Concatenate Load * Inline" statement. I have this included so that it will allow the reload task to run.

Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error

JordyWegman — Fri, 17 May 2019 09:30:38 GMT

Hi,

Can you paste the last part of the log file where the fail is shown?

Jordy

Climber

Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error

dselgo_eidex — Mon, 20 May 2019 18:04:53 GMT

2019-05-16 18:20:32 0082 Concatenate
2019-05-16 18:20:32 0083 Load * Inline [
2019-05-16 18:20:32 0084 ACCESS, USERID
2019-05-16 18:20:32 0085 ADMIN, INTERNAL\SA_SCHEDULER
2019-05-16 18:20:32 0086 ]
2019-05-16 18:20:32 2 fields found: ACCESS, USERID,
2019-05-16 18:20:32 Error: Unknown LOAD statement error
2019-05-16 18:20:32 Unknown LOAD statement error
2019-05-16 18:20:32 Execution Failed
2019-05-16 18:20:32 Execution finished.

Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error

gautamak7 — Tue, 21 May 2019 22:57:59 GMT

Are you giving ADMIN access to all the users? I am not able to understand your concatenate statement. Is it missing comma after USERID. I have something like this in my app which works fine.

Security_Table:
Load 'USER' as ACCESS,
field1,
field2 AS REDUCTION
FROM [lib://Qlik_QVD_Files/Security_QVD.qvd]
(qvd);

CONCATENATE

LOAD 'INTERNAL\SA_SCHEDULER' as USERID,

'ADMIN' as ACCESS,

'*' as field1,

'*' as REDUCTION

Autogenerate 1;

SECTION ACCESS;
NoConcatenate
Load
ACCESS,
field1,
REDUCTION
RESIDENT Security_Table;

SECTION APPLICATION;

Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error

dselgo_eidex — Wed, 22 May 2019 13:32:00 GMT

Yes, I am giving ADMIN access to all the users. Our scripts are very similar, except when I am concatenating on the INTERNAL\SA_SCHEDULER user, I am doing so with an inline load rather than a normal load statement like you are. I am also not including the other reduction fields because it shouldn't matter when concatenating two tables together.

And like I said, the way I have it works a majority of the time, but it fails seemingly at random.

Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error

ragosu66 — Thu, 01 Aug 2019 02:18:17 GMT

We are using Qlik Sense Server (June 2017, 11.11), and we are presenting same issue randomly.

Section Access;

Users:
Load Distinct
'USER' as ACCESS
,'CD\' & Upper("USER LOGIN IDENTIFIER") as USERID
,Upper("CUSTOMER NAME") as C_NAME
From $(vSrcPath)...Users.QVD (qvd);

Concatenate (Users)
LOAD
ACCESS
,NTNAME as USERID
,Upper(C_NAME) as C_NAME
FROM $(vSrcPath).../Admins.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Section Application;

Same code is running without problems in other QS server.