topic Cannot load by if condition - The error occurred here: LOOP in App Development

Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Tue, 22 Aug 2023 12:57:05 GMT

Hello everyone,

I'm trying to load some qvds based on specific hours and until now I don't have success. I'm already thinking it's a bug. I'm assuming this because when I copied this same script and put in a new App, it works. So I don't understand why this happens but it's annoying just think that I may need to create a new app to fix this.

We're using Qlik Sense Feb 2022 patch 6.

"The control statement is not correctly matched with its corresponding start statement

The error occurred here:

LOOP"

Same script in another app:

Script:

IF HOUR(NOW()) > 4 AND HOUR(NOW()) < 12 THEN

Fato:
LOAD * FROM [$(vSmartTransformations)/Ebao/Fato/Fato.qvd] (qvd);

END IF

IF HOUR(NOW()) >= 12 AND HOUR(NOW()) < 19 THEN

Fato:
LOAD * FROM [$(vSmartTransformations)/SunDB/GM_SunDB_FINAL_Cocorretagem.qvd](qvd);

ELSE

T:LOAD * INLINE [
A,
1
];

END IF

EXIT SCRIPT;

Thanks,

Giovanni

Re: Cannot load by if condition - The error occurred here: LOOP

marcus_sommer — Tue, 22 Aug 2023 07:00:56 GMT

Both scripts are very similar but not identically. Before assuming any bug or a file-corruption I suggest to check the script again very carefully, for example:

tracing all variables as well as all conditions and their evaluation
each normal statement ended with ;
each control statement without ;
copying the script into an editor like Notepad++ to check each single char - I have already several cases in which there were invalid and invisible chars includes mostly caused by any copying-task

If nothing is obvious I would comment some parts and then the next and the next until you found the exact line/statement and quite often the mistake showed itself very clearly.

Re: Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Tue, 22 Aug 2023 12:57:59 GMT

Hi Marcus,

Thanks for the reply. I posted the wrong print, look below the exactly same script in different app and the same result. This previous one was from another attempt.

I've already edit the original post with the correct prints.

Regards

Re: Cannot load by if condition - The error occurred here: LOOP

marcus_sommer — Tue, 22 Aug 2023 13:09:54 GMT

Did you check the above mentioned points especially the last three?

Re: Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Tue, 22 Aug 2023 13:19:50 GMT

Yes, I did. I've commented and run step by step, change to another qvd, remove the variables by include statement and tried by removing the automatically sets too.

With only the first part:

Re: Cannot load by if condition - The error occurred here: LOOP

marcus_sommer — Tue, 22 Aug 2023 13:47:08 GMT

make sure that the load-statement ends with a ; (it's not visible in your screenshot)
check all chars by copying the content to an editor
comment all other scripts in all other tabs or maybe move this script-part to the end of all script (there were scenarios in which script was evaluated after an exit script; and could cause an error)

Re: Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Tue, 22 Aug 2023 14:02:59 GMT

I've already did all these tips Marcus. Below and attached is the script, nothing else more.

IF HOUR(NOW()) > 4 AND HOUR(NOW()) < 12 THEN

Fato:
LOAD * FROM [lib://Smart BI Transformations/SunDB/GM_SunDB_FINAL_Cocorretagem.qvd](qvd);

END IF

EXIT SCRIPT;

Re: Cannot load by if condition - The error occurred here: LOOP

marcus_sommer — Tue, 22 Aug 2023 14:43:42 GMT

This script is ok. I would now do the following testing:

copy this script part - and only this - into a new application
copy the application to have a backup and then removing all other script until this if-loop - not commenting removing everything

What happens?

Re: Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Tue, 22 Aug 2023 15:12:52 GMT

As I mentioned before, if I copy the same script and run it in a new app, it works. If I duplicate that app it won't work. I just modified the hour to 13 because of my time zone. See the prints below:

New app:

Duplicated app

Re: Cannot load by if condition - The error occurred here: LOOP

marcus_sommer — Wed, 23 Aug 2023 06:06:43 GMT

The app duplication was only meant to have a backup because all other script within the app should be deleted to exclude that it could cause any impact.

Beside that you may add another loads like:

t: load recno() as R autogenerate 1;

below your qvd-load within the if-loop and then a second time after the if-loop. Also you may try to remove the exit script; statement.

Another attempt would be to set the ERRORMODE to ignore any error, like:

set ErrorMode=0;

What happens now?

Re: Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Mon, 28 Aug 2023 13:08:27 GMT

Unfortunately as any tip you gave didn't work until now, last week I opened a case with Qlik to see further in that. Thanks for the help so far. When I've a return I let you all know.

Re: Cannot load by if condition - The error occurred here: LOOP

giomartini1 — Mon, 04 Sep 2023 13:03:21 GMT

Hello everyone,

Just a short update, Qlik is working in this topic as a Bug issue.