topic Re: Execution finished by For Statement in QlikView

Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 15:16:31 GMT

Hi,

In my script I use an iteration statement for several loads, then I load other tables; something like this:

LET v.Product = NoOfRows('$(v.ProductTable)');

FOR i=0 to $(v.Product)-1
     Load *
     Resident AA;
Next;

ProductDetail:
Load *
Resident [Product Detail];

I execute the Script without Errors, but then realized that the execution of the script was not complete.

Then I saw on the log and I found that the variable v.Product was equals to -1, so never load the table ProductDetail; this table is out of the for statement.

My log:

25-Apr-16 11:46:47: 5437 FOR i=0 to -1

25-Apr-16 11:46:48: Execution finished.

This is a bug?, when the for is from 0 to -1 the scipt stop without error message.

Thank!

Agustín

[Ediit] FOR i=0 to $(v.Product)-1

Re: Execution finished by For Statement

sinanozdemir — Mon, 25 Apr 2016 15:27:11 GMT

Did you mean to put $(v.Product) - 1 instead of $(v.ProductTable) - 1?

Try with $(v.Product) since that's the variable storing the number of rows.

Thanks

Re: Execution finished by For Statement

trdandamudi — Mon, 25 Apr 2016 15:32:52 GMT

I think it should be:

FOR i=0 to $(v.Product) - 1

Re: Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 15:33:32 GMT

Sorry my example was wrong, yes the FOR statement is like you said: FOR i=0 to $(v.Product)-1

Re: Execution finished by For Statement

sinanozdemir — Mon, 25 Apr 2016 15:35:36 GMT

Then either something is wrong with v.ProductTable variable. Take a look at if this variable is empty.

Re: Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 15:36:34 GMT

Yes indeed, the problem is when this variable is equal to 0, so the FOR fail.

Re: Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 15:49:56 GMT

Yes, I found the problem, but I don't understand why qlikview cut the execution of the script when the FOR go to 0 to -1, and not shows an error message, only cut the execution.

Re: Execution finished by For Statement

luis_pimentel — Mon, 25 Apr 2016 17:04:59 GMT

Hi Agustín,

The Qlik script is having the proper behaviour. A loop from 0 to -1 should not fail, since there is no error at all. Just the condition is not met, so the script keeps executing.

I suggest you to control the value of v.Product beforre the FOR sentence, and skip it (or do what you want) in case v.Product = 0.

Regards,

Luis.

Re: Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 17:51:00 GMT

Yes, I understand that the condition is not met; but is not have the proper behavior, because, below the FOR statement I have other tables to load but qlikview stopped the execution right after the FOR.

Re: Execution finished by For Statement

Peter_Cammaert — Mon, 25 Apr 2016 18:14:06 GMT

Two remarks (each probably worth 1ct so it all sums up to "my 2cts")

The table for which you try to find the number of rows doesn't exist. NoOfRows returns NULL, not 0 because that's a value that indicates an empty but existing table. The FOR loop still has a valid syntax because the $-sign expansion for $(v.Product) will produce nothing and only the -1 part will remain.
FOR i = 0 TO -1 should never produce an error because it isn't an invalid specificaiton. If you consult the QV Desktop help on FOR NEXT, you will discover that the full syntax is: FOR var = expr1 TO expr2 [STEP expr3] meaning that negative step values are allowed and therefore expr2 can be negative as well. The default step value of course is +1, but that doesn't affect the validity of the FOR specification or its workings. The one you have on your hands will just never execute a single cycle.

Best,

Peter

Re: Execution finished by For Statement

Peter_Cammaert — Mon, 25 Apr 2016 18:23:05 GMT

Weird, I can't even reproduce your situation.

BTW remove the semicolon from the NEXT line and see if that works better.

What version of QV Desktop are you using?

Re: Execution finished by For Statement

Colin-Albert — Mon, 25 Apr 2016 18:23:25 GMT

You can use the debug window to help find the problem with your script. From the script edit screen you can enable debug mode and step through your script or add breakpoints. As you step through the code you can see the last executed step, the next step and the state of any variables. This should help you see how QlikView is interpreting your script. It may help to add some trace commands to see the values of variables as the script executes.

Re: Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 18:27:02 GMT

Hi Peter,

I'm using 11.20 SR12 64 bits Edition

Best,

Agustin

Re: Execution finished by For Statement

Peter_Cammaert — Mon, 25 Apr 2016 18:29:08 GMT

What happens if you delete the FOR loop (including the Next;-line) and rewrite afresh?

Another hint: QV Desktop may start to behave in very weird (even absurd) ways if kept open for very long and performing a large number of failed reloads in succession. Does it help if you save your document, close QV Desktop and reopen it to reload again?

Re: Execution finished by For Statement

agustinbobba — Mon, 25 Apr 2016 19:28:44 GMT

I am trying to reproduce the same scenery in a example but I can't.

But I found the problem but like you said QV start to beheva weird, the thing is that below the for i have a drop table to the table Product.

FOR i=0 to $(v.Product)-1  

  TRACE For statement;
   
    LET v.Table = DATE(Today(),'YYYYMMDD');

  NOCONCATENATE
  [$(v.Table)]:
     Load *  
     Resident AA;  
Next;  

DROP TABLE $(v.ProductTable);

If the v.productTable doesn't exist, the 'drop table' shows error message. But in my code only end the execution. In the example actually shows a error message.

4/25/2016 3:50:36 PM: 0034 LET v.Product = NoOfRows('Product')

4/25/2016 3:50:36 PM: 0036 FOR i=0 to -1

4/25/2016 3:50:36 PM: 0048 DROP TABLE Product

4/25/2016 3:50:36 PM: Execution finished.

If my code I put a trace statement before and after the drop table QV says doesn't exist the table and shows a error message.

Yes, this is weird..

Well!, thank all for your comments

Agustin.