topic Re: Scrip line error QlikSenseEnterprise 2.1.1 in App Development

Scrip line error QlikSenseEnterprise 2.1.1

Anonymous — Thu, 15 Oct 2015 11:21:46 GMT

Hi Altogehter,

Am using Qlik Sense Server 2.1.1 and I enconterd weird error message during debuging which prevents me of reloading an app.

Error message I am getting is Script line error: : FOR i = 0 to NoOfRows('TMP_Databases') - 1

Lines from the script where error message occured.

---------------------------------------------------------------------------------------------

LIB CONNECT TO 'PohodaDB';

FOR i=0 to NoOfRows('TMP_Databases') - 1

SET vDatabase = Peek('Databaza', i, 'TMP_Databases');

SET vICO = Peek('ICO', i, 'TMP_Databases');

SET vTable = 'Meny';

LIB CONNECT TO 'PohodaDB';

$(vTable):

SQL SELECT

$(vICO) as [%ID firma],

ID as [%ID mena],

Kod as [Mena]

FROM sCMeny;

---------------------------------------------------------------------------------------------

According to my developer knowledge script looks proper

Did anybodody of you face this problem before and knows how to fix it?

Thanks in advance

LACI

Gysbert_Wassenaar — Thu, 15 Oct 2015 11:50:57 GMT

Anonymous — Thu, 15 Oct 2015 12:18:16 GMT

Legacy mode did not help.

Gysbert_Wassenaar — Thu, 15 Oct 2015 16:13:54 GMT

Does a table with the name TMP_Databases exist at the time the for loop is executed?

Anonymous — Thu, 15 Oct 2015 16:25:41 GMT

Yes, of course. I just forgot to mention it. I was thinking that this will be the first question

As I said before, script looks ok for me, there is something in behind what QlikSense cannot process.

Basicaly it is a script from QlikView where everything works well. I just corrected data connections and paths.....

Thanks!

TKendrick20 — Wed, 23 Mar 2016 22:44:51 GMT

Also having this problem. What did you learn?!?!