16.20 - Data Application Errors - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Data application errors occur while the consumer operator is writing data to the Teradata Database, and include the following common error types.

Cause:

  • Row to be INSERTed duplicates an existing row in the target table.
  • Row to be UPDATEd or DELETEd does not exist in the target table.
  • A DML statement, intended to UPDATE or DELETE one specific row in the target table, actually applies to more than one row in the target table.

When the consumer operator is Load, Update or Stream, source rows causing data application errors are written to standard error tables.

Corrective Action:

For information on assessing row errors Accessing and Using Error Tables.