You can use certain transformation ports to define how to handle errors that occur during a workflow run.
Each
Data Integration Hub
transformation uses the following ports to handle errors:
DXErrorCode. When a transformation fails, the transformation sets the DXErrorCode to a value greater than zero.
DXErrorMessage. When a transformation fails, the transformation sends an error message that describes the failure to the DXErrorMessage port.
When a transformation generates an error, the transformation writes the error to the PowerCenter session log. The error log includes the exception class, description, cause, and stack trace. The logging level is based on the PowerCenter configuration. Up to 1K of the document associated with the error will be included in the log.
If the option to set the event status to error when a transformation fails is set to true, the transformation also sets the status of the event to error.
You can set the error handling ports as input ports to prevent the transformation from running if an input error occurs.