Handling Erroneous UDRs - Batch

Owned by Jenni Wallin
Last updated: May 04, 2023 by Former user (Deleted)
1 min read

The SQL forwarding agent encapsulates en erroneous UDR along with the error message that describes the error, in a new UDR. This in turn, enables you to process the faulty UDR, adjust the processing according to the error type, and prevent the workflow from aborting due to selected errors types.

Example - Handling erroneous UDRs in a batch workflow

Consider the following workflow:

An SQL forwarding workflow

The SQL forwarding agent identifies the asciiSEQ_TI UDR as erroneous, creates an errorUDR that wraps together the original UDR with the error message that was generated:

      

The erroneous UDR before and after SQL forwarding

If you have selected the option Upon Exception, route entire executed batch instead of single UDR, an errorUDRList UDR is routed instead:

The errorUDRList UDR