Defining the Restart Behavior

1.     Open the Load Plan Editor:

• Navigate to the Steps tab in the Load Plan Editor.

2.     Select the Step:

• In the Steps Hierarchy table, select the step for which you want to define the restart behavior.

3.     Access the Properties Inspector:

• The Property Inspector will display the properties of the selected step.

4.     Define Restart Type in the Exception Handling Section:

• In the Exception Handling section, locate the Restart Type parameter and set it according to the step type. The Restart Type defines how the step in error will restart when the Load Plan is restarted.

5.     Choose Restart Behavior Based on Step Type:

• Depending on the step type, the available values and their behavior are as follows:

For Serial Steps:

• Restart all children:
• When the Load Plan is restarted, and if this step is in error, the sequence of child steps restarts from the first one.
• Restart from failure:
• When the Load Plan is restarted, and if this step is in error, the sequence of child steps restarts from the one that previously failed.

For Parallel Steps:

• Restart all children (default value):
• When the Load Plan is restarted, and if this step is in error, all child steps are restarted, regardless of their status.
• Restart from failed children:
• When the Load Plan is restarted, and if this step is in error, only the child steps that previously failed are restarted.

For Run Scenario Steps:

• Restart from new session (default value):
• When the Load Plan is restarted and the Run Scenario step is in error, the scenario restarts and creates a new session.
• Restart from failed step:
• When the Load Plan is restarted and the Run Scenario step is in error, the session restarts from the step that failed. All tasks under that step are also restarted.
• Restart from failed task:
• When the Load Plan is restarted and the Run Scenario step is in error, the session restarts from the specific task that failed.

6. Understand Session Limitations:
• Note that the same limitations described in the "Restarting a Session" section (from the Oracle Data Integrator documentation) apply to sessions restarted from a failed step or failed task.

By defining the Restart Type for each step, you control how the Load Plan behaves when it is restarted after a failure, ensuring the correct steps or tasks are retried according to the chosen configuration.