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