In the Qlikview Reference Mannual V 11 see the page number 278 and there you get details about the. By this ways you can create the Errpr handling issues.
Error Variables and Error Modes
---------------------------------------------
Error Variables
The following variables can be used for error handling in the script:
ErrorMode page 278
ScriptError page 278
ScriptErrorDetails page 279
ScriptErrorCount page 279
ScriptErrorList page 279
The values of all five variables will remain after script execution. The value of the last four variables, for
error handling inside the script, is of course dependent on the use of ErrorMode=0.
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 simply ignore the failure and continue script
execution at the next script statement. 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;
ScriptError
Returns the error code of the last executed script statement. This variable will be reset to 0 after each successfully
executed script statement. If an error occurs it will be set to an internal QlikView error code. Error
codes are dual values with a numeric and a text component. The following error codes exist:
1 No error
2 General Error
3 Syntax Error
4 General ODBC Error
5 General OLE DB Error
6 General XML Error
7 General HTML Error
8 File Not Found
9 Database Not Found
10 Table Not Found
11 Field Not Found
12 File Has Wrong Format
Example:
set ErrorMode=0;
load * from abc.qvw;
if ScriptError=8 then
exit script;
//no file;
end if
ScriptErrorDetails
Returns a more detailed error description for some of the error codes above. Most importantly this variable
will contain the error message returned by ODBC and OLE DB drivers for error codes 3 and 4.
ScriptErrorCount
Returns the total number of statements that have caused errors during the current script execution. This variable
is always reset to 0 at the start of script execution.
ScriptErrorList
This variable will contain a concatenated list of all script errors that have occurred during the last script
execution. Each error is separated by a line feed.
