15.10 - Error Limits For Load and Update Operators - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.