Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Highlighted
Partner
Partner

Qlik Sense Reload fails randomly; Unknown LOAD statement error

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.

5 Replies
Partner
Partner

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

Hi,

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

Jordy

Climber

Work smarter, not harder
Partner
Partner

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

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.

gautamak7
New Contributor

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

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

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

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.

ragosu66
New Contributor III

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

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.