Load Operator Errors - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Load Operator Errors

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:

 

Table 8: 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.