topic Re: Error modes=0 and 1 in QlikView

Error modes=0 and 1

Sun, 15 Dec 2013 16:23:56 GMT

Can any body explain purpose of the ErrorMode in development and producion with example i have not obsrved any change in developement using for ErrorMode=0 or Error Mode=1;

let me know uses and can we write our own custom erros give me with examples.

Regards

Mahesh

Re: Error modes=0 and 1

swuehl — Sun, 15 Dec 2013 17:50:20 GMT

Have you searched for ErrorMode in the HELP or the forum?

http://community.qlik.com/docs/DOC-5342

If you think it doesn't work like you expect to in your script, could you post your script and what your expectation is?

Re: Error modes=0 and 1

jagan — Mon, 16 Dec 2013 02:28:23 GMT

Hi Mahesh,

If ErrorMode = 1, the script execution stops and it is prompted to user.

If ErrorMode = 0, then script execution simply ignores current statement and follows executing next statements

For Example:

Data1:

Load * from Table1;

Data2:

Load * from Table2;

Note: Assume that Table 1 not exists (Error)

If ErrorMode = 1, the script execution stops and prompts this to user (both Table1 and Table2 are not loaded)

If ErrorMode = 0, the Table1 script error is ignored and loads Table2.

Help from Qlikview File

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.

Hope this helps you.

Regards,

Jagan.

Re: Error modes=0 and 1

Mon, 16 Dec 2013 04:49:40 GMT

Hi Mahesh,

Errormode, is one of the system variable.

By default the property for Errormode is 1.

You can change the property from 1 to 0.

1 = Stop executing script if any error in the script.

0 = Execute the script and show the result (the part which is correct).

Generally developers use this variable when a particular table is not in exist.

For your observation. Load 2 tables from your desktop (excel files). Then execute these tables into Qlikview.

Then delete a table from your desktop (don't make any changes in the script) and re-execute the script.

Sure it will show a error, in-order to avoid this kind of errors, use variable Errormode=0 on the top of your script.

Hope this helps you.

Regards,

Pavan Kumar

Re: Error modes=0 and 1

Wed, 09 Jul 2014 14:59:34 GMT

Hi,

I attach you file with the errors when the ErrorMode = 0 .

You can use ErroMode = 0 in next example:

SET ErroMode = 0;

LOAD *

FROM ABC.qvd;

let vTest (we create new variable) = ScriptError;

Next create new text object with text:

=$(vTest);

And the result will be the type of error in the script.

If you set ErrorMode = 2. ,

You'll be exit from script and the data in the application it will be the last reload data.

Regards,

Venelin