Reading Teradata TPump Error Tables
Teradata TPump error tables are a diagnostic device that help you locate and fix problems. For more information, refer to the description of these tables in “BEGIN LOAD”.
Occasionally, Teradata TPump encounters rows that cannot be correctly processed. When this happens, Teradata TPump creates a row in the error table that is produced for each target table. Error tables are structured to provide enough information to reveal the cause of a problem and allow correction.
In the case of missing, duplicate, or extra rows, these are noted in the error table only if the DML command specifies that requirement with the MARK parameter, which is the default for DML statements except for those participating in an upsert.
Three error codes relate specifically to the incidence of missing, duplicate, and extra rows:
This error occurs if MARK DUPLICATE INSERT/UPDATE ROWS is specified and a duplicate row is detected.
This error occurs if MARK EXTRA UPDATE/DELETE ROWS is specified and an activity count greater than one resulted. In this case, the error table row is inserted, but the corresponding UPDATE/DELETE also completes.
This error occurs if MARK MISSING UPDATE/DELETE ROWS is specified and an activity count of zero resulted.