16.20 - Reading Error Tables - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Example of ErrorTable 1

Errors found in ErrorTable 1 are detected in the data acquisition phase, while the consumer operator is acquiring data from the producer.

SELECT errorcode, errorfield, sourceseq, dmlseq From t2_e1;

 *** Query completed. One row found. 4 columns returned.
 *** Total elapsed time was 1 second.

     ErrorCode  ErrorField                           SourceSeq  DMLSeq
--------------  ------------------------------  --------------  ------
          2679  A_IN_C1                                     49       1

The following explains the error table entry above:

Error table Column Value Explanation
ErrorCode 2679 The Teradata Database error code associated with the error.

In this case, message 2679 indicates: The format or data contains a bad character.

This error code also appears in the job logs.
ErrorField A_IN_C1 Indicates where the error was generated.

In this case: In column A_IN_C1, as defined in the INSERT INTO statement for the Stream operator.

The names in this column have a maximum supported size of 120 characters. The names can be up to 128 characters, but if a row is inserted into ErrorTable 1, the Teradata Database truncates any name that exceeds 120 characters.
SourceSeq 49 The sequence number of the data row that caused the error.
DMLSeq 1 The sequence number of the DML statement (within its DML Group) that caused the error.

Example of ErrorTable 2

Errors found in ErrorTable 2 are detected in the data application phase, by the consumer operator while it writes the data to the Teradata Database; in this case, Update operator.

select dbcerrorcode, sourceseq, dmlseq from t3_e2;

 *** Query completed. 2 rows found. 3 columns returned.
 *** Total elapsed time was 1 second.

  DBCErrorCode       SourceSeq  DMLSeq
--------------  --------------  ------
          2793              50       2
          2793              49       2

The following explains the error table entry above:

Error table Column Value Explanation
ErrorCode 2793 The Teradata Database error code associated with the error.

In this case, message 2793 indicates: The format or data contains a bad character.

This error code also appears in the job logs.
SourceSeq 49, 50 The sequence numbers of the data rows that caused the error.
DMLSeq 2 The sequence number of the DML statement (within its DML Group) that caused the error.