15.10 - Reading Error Tables - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Reading Error Tables

The following are examples of ErrorTable 1 and ErrorTable 2.

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.

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

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

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