Error Handling

In a perfect world, every computer system would run without freezing. Every file would be found. A 0 (zero) would never be mistaken for a capital O.

But the truth is we live in the real world, and that's why many Advanced Commands include a section dedicated to Error Handling. When errors happen (as they inevitably do), they are easier to track and correct.

You can specify how the wizard should report errors in any Advanced Command in which you see the Error handling option:

1. Enter the name of the variable in which an error message should be placed.

   • This option is generally only available for Advanced Commands that:

     • Do not have a variable in which a regular value is returned (a "return variable"); or

     • Have more than one return variable

   • For commands with one return variable, an error message will be placed in the return variable

2. Customize default error messages for the various types of errors that might occur during execution of the command.

   • This option is available for all Advanced Commands that offer Error Handling

In some advanced commands you have the option to configure Timeout Monitoring.

See Timeout Monitoring.

Error handling of "Excel Worksheet Actions" Advanced Command

In case you set a variable in the “error description” field of the Excel Worksheet Actions Advanced Command, there are 2 types of events that are caught into this variable:

• If the worksheet already exists, upon running the command the variable is populated with “worksheet already exist”.

• If an exception is encountered (considering that all exceptions have exception messages), the exception message is populated in the variable.

Error handling fields of Global Function

Error handling suggestion to Java Advanced Commands

In case the wizard was recorded in Java 32 bit and the user is trying to execute it in Java 64 bit, you can add a “general error” variable to the Java commands explaining the error to the user.