Operator-Specific Error Handling - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

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, see Load Operator Errors, Stream Operator Errors, and Update Operator Errors.

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 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") 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.
    • Use AcceptMissingColumns to extend a short row to the correct number of columns instead of terminating.
    • Use TruncateColumnData to truncate a column that is too long instead of terminating.

For a list of obsolete syntax, which are supported but no longer documented, see "Deprecated Syntax" in the Teradata® Parallel Transporter Reference, B035-2436.