16.20 - Load Operator 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

The Teradata Database tracks and records information about various types of error conditions that cause an input data record to be rejected during a load operation. The following error conditions can occur:

Load Errors
Error Condition Cause of Rejection
Constraint violation Records do not comply with the range constraints you defined when creating the table.
Unavailable AMP condition Records are destined for a nonfallback table on an AMP that is down.
Data conversion errors Refers to records from the input file that fail a specific data type conversion.
Unique primary index violation Records contain a value for the unique primary index field that already exists, but is not a duplicate row.
Duplicate row Records are exact duplicates of existing rows.