The error limit determines the approximate number of rows that can be stored in the Acquisition Phase Error Table before the operator job is terminated.
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.