17.00 - Limiting Errors in the Stream Driver - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Parallel Transporter
Release Number
November 30, 2020
English (United States)
Last Update

Use the ErrorLimit attribute to limit the number of errors captured in the error table during the Stream job.

Stream Driver ERRORLIMIT Values 
IF you expect your Stream job to encounter... THEN specify an ERRORLIMIT value that is...
No errors or very few errors low
Many errors that are considered allowable high
The ErrorLimit specification applies to each instance of the Stream application, not to all instances combined. If, for example, you set the limit to 10,000, then a single instance would have to detect that 10,000 rows were inserted into the first error table in order to terminate the job, and those 10,000 rows would have to be controlled by the sessions managed by that instance.

Processing terminates when the number of errors encountered reaches the error limit. If, for example, you expect no errors in the input data, set the error limit value to one. In this case, the job terminates when any record causes an error.