Defining Status Handling in Iterative Jobs :: SAS® Data Integration Studio 4.902: User's Guide

Problem

A SAS Data Integration Studio parallel iterative job does not indicate failure when an inner loop process fails unless status handling is defined. This problem occurs because a SAS Data Integration Studio iterative job that is set to run in parallel spawns a separate SAS session for each iteration of the loop.

By default, each session, including the calling job, contains its own job status information. However, none of this information is shared among processes. As a result, the calling program might indicate that the job completed successfully even though one or more of the spawned processes failed. The only way to force the calling job to indicate failure when a spawned process fails is to set up status handling in the Loop transformation.

Solution

Define status handling for the iterative job. The status handling forces the calling program to report an unsuccessful completion as the result of a failed loop process.

Define Status Handling in an Iterative Job

Perform the following steps to define status handling for the iterative job:

Open the outer loop job portion of an iterative job.
Open the Properties window for the Loop transformation.
Click Status Handling.
Click New to add a record to the table.
Select an appropriate abort action from the Action column to address the Error in Process condition in the Condition column. The available abort actions are as follows:

Abort All

triggers immediate job termination

Abort Remaining

terminates the remaining loop processes

Abort After Loop

terminates the loop job after loop processing completes

Selecting Abort All or Abort After Loop displays the Action Options window, where you define a value for a Return Code. (Selecting any other action does not open the Action Options dialog box because a return code is not necessary under these conditions.) The return code is the numeric value that is sent back to the host system. Any value of 5 or greater aborts the parallel iterative job when a spawned session returns it as a job error.
Click OK to save the status handling definition.