15.00 - Error Recording - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

Error Recording

Teradata FastLoad stores the input data records related to constraint violations, conversion errors, unavailable AMP conditions, and unique primary index violations in the two error tables specified in the BEGIN LOADING command.

Table 23 lists error tables.

 

Table 23: Error Tables 

Table

Stores Records That Produced These Error Types

errortname1

  • Constraint violations
  • Conversion errors
  • Unavailable AMP conditions
  • These types of errors always occur during the loading phase of the Teradata FastLoad job after executing the BEGIN LOADING command, but before the END LOADING command.

    errortname2

    Unique primary index violations

    This type of error always occurs during the endloading phase of the Teradata FastLoad job after executing the END LOADING command.

    Teradata FastLoad discards all records that produce a duplicate row error, but includes the total number of duplicate rows encountered, along with the total records in each error table, in the end‑of‑job status report.