topic Re: Unknow qlik sense error (-1) in App Development

Unknow qlik sense error (-1)

nielsveenman — Wed, 29 Nov 2017 12:52:58 GMT

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

Re: Unknow qlik sense error (-1)

shraddha_g — Wed, 29 Nov 2017 14:39:47 GMT

Check whether you have missed ; (Semicolon) somewhere

Re: Unknow qlik sense error (-1)

nielsveenman — Wed, 29 Nov 2017 15:16:12 GMT

Thanks, unfortunately this is not the case...

Re: Unknow qlik sense error (-1)

shraddha_g — Thu, 30 Nov 2017 05:08:36 GMT

Did you try to Debug the script?

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

Re: Unknow qlik sense error (-1)

Chanty4u — Thu, 30 Nov 2017 05:12:05 GMT

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

Re: Unknow qlik sense error (-1)

nielsveenman — Thu, 30 Nov 2017 08:34:27 GMT

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?

Re: Unknow qlik sense error (-1)

nielsveenman — Thu, 30 Nov 2017 11:27:50 GMT

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)];

solved the issue.

Re: Unknow qlik sense error (-1)

wing — Fri, 03 Jan 2020 09:58:38 GMT

Add the code in the beginning or in the end? when add in the end, all tables are drop and shows nothing.when adding in the beginning, still the same error.

Re: Unknow qlik sense error (-1)

suneethagandham86 — Mon, 20 Jun 2022 06:39:36 GMT

Hi nielsveenman,

I am also facing the same issue. Please post the solution. Thanks!