ErrorTable - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

ErrorTable

Attribute that specifies the name of the error table. This table contains information concerning data conversion errors, constraint violations, and other error conditions.

This attribute must be a new table name, unless the AppendErrorTable attribute is set to YES. Do not use a name that duplicates the name of an existing table unless you are restarting a Stream operator job. If the name is not supplied, it is created by the Stream operator. User-supplied names for error tables must not exceed the maximum size for table names on the Teradata Database.

Keeping the Error Table

By default, the Stream operator drops the error table after data loading, unless the error table is non-empty. The error table can be kept after data loading by setting the DropErrorTable attribute to NO, as follows:

VARCHAR DropErrorTable = 'NO'

Keeping the error table allows the error table to be re-used for future jobs and saves the time required to drop the table.

Re-using the Error Table

By default, the Stream Operator will create the error table. If the error table already exists, Stream Operator will terminate the job with an error message. The exception is on a job restart. On a job restart, Stream Operator will continue.

  • When the value of the AppendErrorTable attributes is YES, the Stream operator reuses the error table and displays the number of rows already existing in the error table.
  • If the error table does not exist, the Stream operator creates the error table before data loading and continue.
  • If the structure of the existing error table is not compatible with the error table the Stream operator expects, it terminates the job with an error message before data loading.
  • Note: A new column, RowInsertTime, was added to the Stream Operator error table for version 13.10. Therefore, you can no longer reuse error tables from prior versions, as valid Stream Operator error tables now have ten columns rather than nine.

    Error Limit

    Attribute that specifies the approximate number of records that can be stored in the error table before the Stream operator job is terminated.

    This number is approximate because the Stream operator sends multiple rows of data at a time to Teradata Database. By the time Teradata PT processes the message indicating that the error limit has been exceeded, it may have loaded more records into the error table than the actual number specified in the error limit.

    The ErrorLimit specification must be greater than 0. Specifying an invalid value will cause the Stream operator job to terminate. By default, the ErrorLimit value is unlimited.

    Note: The ErrorLimit specification applies to each instance of the Stream operator.