This topic contain information to help you troubleshoot Automation script execution issues. It also includes tips for manipulating errors and using error messages.
For issues related specifically to scheduled scripts
Review the following general Automation script issues.
|Issue||Description and Resolution|
|Variable contains backslash (\)||When a variable value is drawn from database data which includes the backslash (\) character, you must explicitly escape each backslash.|
Toad generates an internal variable that captures execution exceptions. The variable's name is _ACTIVITY_RESULT. This variable is assigned a value after the execution of each activity in a script. The value is based on the result of the activity execution and overwrites the previous value generated by the previous activity. This variable can be used to debug Automation scripts.
The following values are automatically assigned to the _ACTIVITY_RESULT variable based on the activity execution result.
|Execution Result (Activity)||Variable Value|
|Normal execution with no errors||
If the activity executes normally and no errors are generated, the value "Succeeded" is assigned to the variable.
Tip: Because the previous value (if any) is overwritten by a successful activity, to preserve a previously-generated error message, assign the value to a new user-defined variable.
|Error during execution||
If an error is generated during activity execution, the error message is assigned to the variable. One of the following formats is used:
<exception message>; Inner exception: <inner exception message>
Using the _ACTIVITY_RESULT variable
If necessary, you can prevent an error in one activity from causing a failure at the script level. This is useful if the logic of your script permits an error as part of the normal script workflow and execution, but you do not want it to result in an overall script failure.
This action does not suppress error messages.
To suppress script failure
On the Activity Info tab, clear the Generate Error check box.
If the Stop On Error option is selected for the entire script (Settings), you must clear the Stop on Error check box for the individual activity before you can clear the Generate Error check box.