Handling Erroneous UDRs - Batch
- Jenni Wallin
- Former user (Deleted)
- Yeok Hong Ng
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