rec-quest

Wed, 11 Jun 2014 06:06:48 GMT

1,can anyone tel me about the Error handling issue?

Re: rec-quest

whiteline — Wed, 11 Jun 2014 06:20:00 GMT

Error Handling in Qlikview

Re: rec-quest

Wed, 11 Jun 2014 14:38:20 GMT

Error handling in QV

Re: rec-quest

its_anandrjs — Wed, 11 Jun 2014 16:07:00 GMT

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.

topic Re: rec-quest in QlikView

rec-quest

Re: rec-quest

Re: rec-quest

Re: rec-quest