Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nielsveenman
Partner - Contributor II
Partner - 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
Partner - Contributor II
Partner - Contributor II
Author

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.

View solution in original post

8 Replies
shraddha_g
Partner - Master III
Partner - Master III

Check whether you have missed ; (Semicolon) somewhere

nielsveenman
Partner - Contributor II
Partner - Contributor II
Author

Thanks, unfortunately this is not the case...

shraddha_g
Partner - Master III
Partner - Master III

Did you try to Debug the script?

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

Chanty4u
MVP
MVP

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

nielsveenman
Partner - Contributor II
Partner - Contributor II
Author

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
Partner - Contributor II
Partner - Contributor II
Author

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.

wing
Contributor
Contributor

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.

suneethagandham86
Contributor
Contributor

Hi nielsveenman,

 

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