ODI12c Handling Load Plan Exceptions and Restartability FAQS

1. What are the two features for handling errors in Load Plans?

Load Plans provide:

·        Exceptions → Define custom error handling flows

·        Restartability → Control how failed steps are restarted

2. What is an Exception Step?

·        A hierarchy of steps defined in the Exceptions tab of the Load Plan Editor

·        Automatically executed when an associated Load Plan step fails

·        Can optionally raise the exception to the parent step, triggering its exception flow

3. How is an Exception Step different from regular steps?

·        No root step for hierarchy — each exception step is a separate root

·        Serial, Parallel, Run Scenario, and Case steps in exceptions do not have exception properties

·        Exception steps themselves cannot raise another exception

4. How do you create an Exception Step?

·        Go to Exceptions tab → Add Step > Add Step Wizard

·        Select Exception as the step type

·        Enter a Step Name

·        Click Finish

·        Add child steps to define the exception flow

5. How do you associate an Exception Step to a Load Plan step?

·        Open Steps tab → select step → Property Inspector → Exception Handling

·        Set:

o   Timeout (s) → Maximum execution time before the step is aborted

o   Exception Step → The Exception Step to execute on failure

o   Exception Behavior → Either:

§  Run Exception and Raise → Executes Exception Step and raises to parent

§  Run Exception and Ignore → Executes Exception Step and ignores failure

6. What additional parameters exist for Parallel steps?

·        Max Error Child Count → Maximum failed child steps allowed before the parallel step fails

·        Behavior depends on Restart Type:

o   Restart from failed children → Waits for all child steps to complete before raising error

o   Restart all children → Kills running child steps and restarts none before raising error

7. What is Restartability in Load Plans?

Restartability defines how failed steps are resumed when a Load Plan is restarted, controlled by the Restart Type parameter.

8. What are Restart Type options for different step types?

Serial Steps:

·        Restart all children → Sequence restarts from the first step

·        Restart from failure → Sequence starts from the failed step

Parallel Steps:

·        Restart all children → All child steps are restarted (default)

·        Restart from failed children → Only failed child steps are restarted

Run Scenario Steps:

·        Restart from new session → Start scenario with a new session (default)

·        Restart from failed step → Restart scenario from failed step

·        Restart from failed task → Restart scenario from failed task

9. Why is exception handling important in Load Plans?

·        Provides controlled recovery from failures

·        Ensures business rules and error flows are executed

·        Prevents unexpected failures from cascading

10. Why is restartability important?

·        Minimizes re-execution of successfully completed steps

·        Supports parallel step recovery

·        Ensures Load Plan consistency after failures