15.10 - Load Operator Errors - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.