ErrorTable1 - Parallel Transporter

ErrorTable1

Load operations create an error table that captures errors during job runs. Jobs can use the default names of the error tables, or names can be user-specified as an attribute of the Load operator.

Error Table1 contains most of the errors connected with data and the data environment. The following types of errors are captured:

Constraint violations - Records that violate a range or value constraint defined for specific columns of a table.

Unavailable AMP - Records to be written to a non-fallback table about an offline AMP.

Data conversion errors - Records that fail to convert to a specified data type.

Note: The names in the ErrorTable1 ErrorFieldName column have a maximum supported size of 120 characters. The names can be up to 128 characters, but if a row is inserted into ErrorTable1, the Teradata Database truncates any name that exceeds 120 characters.