Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Check whether you have missed ; (Semicolon) somewhere
Thanks, unfortunately this is not the case...
Did you try to Debug the script?
It will help you to understand at which row you are getting error
try to comment each table and run one by one at least you will know which table causing the issue?
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?
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.
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.
Hi nielsveenman,
I am also facing the same issue. Please post the solution. Thanks!