16.20 - Error Limits For Load and Update Operators - 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

The error limit determines the approximate number of rows that can be stored in the Acquisition Phase Error Table before the operator job is terminated.

The following example shows this variation for an operator with two instances and an ErrorLimit attribute value of 1000:

  • If either operator instance reaches 1000, it will terminate the job with a fatal error. In this case, the error limit is calculated per instance.
  • If instance #1 processes 500 error rows and instance #2 processes 500 error rows the job will do the following:
    • If the job has already passed the final checkpoint (the transaction is fully committed), the job will complete. In this case, the error limit is calculated per instance.
    • If the job reaches a checkpoint after logging the total of 1000 (500 + 500) errors, the job will terminate. In this case, the error limit is calculated based on the total errors among all instances.