Error Limits for Stream Operator - 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 Stream operator error limit determines the approximate number of rows that can be stored in the Error Table before the Stream operator job is terminated. This number is approximate because the Stream operator sends multiple rows of data at a time to the database. By the time Teradata PT processes the message indicating that the error limit has been exceeded, it may have loaded more rows into the error table than the actual number specified in the Error Limit.

The ErrorLimit specification is not cumulative, but applies to each instance of the Stream operator. Therefore a job with two instances of Stream operator and an ErrorLimit attribute value of 1000 will terminate only when one of the instances reaches 1000. Otherwise the job will continue.