Error Limits For Load and Update Operators - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
vyv1488824663502.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.