Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

nielsveenman
New Contributor II

Unknow qlik sense error (-1)

All,

I just encountered a (for me) strange error while reloading a script.

Script reload takes around 11 minutes, this seems to work well. After the last step is an "exit script". This gives the following result:

.....

2017-11-29 01:12:02 0226 Drop Table Tables

2017-11-29 01:12:02 0228 Exit Script

2017-11-29 05:28:33      -1 =

2017-11-29 05:29:28      Execution Failed

2017-11-29 05:29:28      Execution finished.

So it seems something goes wrong. The result of the script is an empty app (extract from database to QVD).

Anyone who can help?

Thanks in advance,

Niels

1 Solution

Accepted Solutions
nielsveenman
New Contributor II

Re: Unknow qlik sense error (-1)

Loading separate parts of the script gave no issues and returned an empty app (as expected). Loading the whole script ended up in creating lots of sync tables which caused the crash.

Adding this:

let numTables = NoOfTables();

for i=1 to $(numTables)

let tt = TableName(0);

drop table [$(tt)];

next

solved the issue.

6 Replies
shraddha_g
Honored Contributor III

Re: Unknow qlik sense error (-1)

Check whether you have missed ; (Semicolon) somewhere

nielsveenman
New Contributor II

Re: Unknow qlik sense error (-1)

Thanks, unfortunately this is not the case...

shraddha_g
Honored Contributor III

Re: Unknow qlik sense error (-1)

Did you try to Debug the script?

It will help you to understand at which row you are getting error

sureshqv
Esteemed Contributor III

Re: Unknow qlik sense error (-1)

try to comment each table and run one by one at least you will know which table causing the issue?

nielsveenman
New Contributor II

Re: Unknow qlik sense error (-1)

Thanks, I tried both (debugging as well as running parts of the script) but both give no error.

I'm specifically triggered by the "-1 =" part  of the script. Anyone seen this before?

nielsveenman
New Contributor II

Re: Unknow qlik sense error (-1)

Loading separate parts of the script gave no issues and returned an empty app (as expected). Loading the whole script ended up in creating lots of sync tables which caused the crash.

Adding this:

let numTables = NoOfTables();

for i=1 to $(numTables)

let tt = TableName(0);

drop table [$(tt)];

next

solved the issue.