15.10 - Operator-Specific Error Handling - Parallel Transporter

Teradata Parallel Transporter User Guide

Parallel Transporter
User Guide

Teradata PT handles errors differently depending on the operator that detects the error and whether or not the operator has been directed, through one of its attributes, to ignore the error just detected.

The Load, Update and Stream operators, which typically process large numbers of data rows, have built-in tolerances for data application errors, which are specifiable through operator attributes. For detailed information the sections on these operators later in this chapter.

Other operators generally terminate for any error that occurs during their execution. The exceptions are:

  • DDL operator: Use the ErrorList attribute to specify one or more Teradata Database error codes that the operator will ignore, instead of causing the job to terminate, as would normally be the case.
  • DataConnector operator:
  • Use the RecordErrorFileName attribute (previously known as “RowErrFileName,” which will no longer be used in documentation as of the next release) to write erroneous source rows to a named file instead of terminating.
  • Use AcceptExcessColumns to ignore extra columns in its source rows instead of terminating.
  • For a list of obsolete syntax, which are supported but no longer documented, see Appendix B in the Teradata Parallel Transporter Reference.