Error Limits For Load and Update Operators - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.