Data Application Errors - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
vyv1488824663502.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.