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