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