While reading data from QVDs I am getting the "general script error".
below is the log related to the same script.
LEFT JOIN (MAINTABLE)
LOAD ABC as ABC,
EFG as EFG
2 fields found: ABC, EFG,
1,325,426 lines fetched
General Script Error
I Have couple of guesses on this General Error:
load application under debug mode 10 records each
load tables one by one (probably also in debug) and see where the error incurs
Some times Join also cause
does it always happen on the same table? if you change the order of loading?
do you have the rights to read in the database?
So please check all these conditions else if possible share entire Script so that our folks will help you ASAP.
Thanks for replying Ramana
No, this is the first time i am facing this issue.
There were few changes i made in the script:
1) added a table to pull few columns from it
2) added 2 additional columns from an existing QVD
Somewhere in your script is the following line :
Set ErrorMode = 2
Change it to
Set ErrorMode = 1
and have a look at the errormessage appearing when reloading script!
From Qlikviw Help:
ErrorMode This variable determines what action is to be taken by QlikView when an error is encountered during script execution. By default (ErrorMode=1) the script execution will halt and the user will be prompted for action (non-batch mode). By setting ErrorMode =0 QlikView will suppress all error messages on failure to load. If script execution is halted due to failure, it will not continue. By setting ErrorMode =2 QlikView will trigger an "Execution of script failed..." error message immediately on failure, without prompting the user for action beforehand. Example: set ErrorMode=0;