Error Limits For Load and Update Operators - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Error Limits For Load and Update Operators

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.