When trying to load the hive data into Teradata table getting ERROR: TPT10510: Instance 1: Error Limit has been reached or exceeded.

When trying to ingest the hive data into Teradata table. As part of execution during the loading of  Teradata target table we are facing the ERROR: TPT10510: Instance 1: Error Limit has been reached or exceeded.

Beginner Asked on February 16, 2021 in Diyotta Studio.
Add Comment
1 Answer(s)

This Error occurs when the error limit crosses the one specified in the job level properties. The Error record can be happening due to constraint violation based on the error code TPT10510 specified.

RE: When trying to load the hive data into Teradata table getting ERROR: TPT10510: Instance 1: Error Limit has been reached or exceeded.

In order to overcome this issue increase the error limit and then try to run the dataflow. once the jobflow is succeded. Try to query the error tables1 and error tables2 then you will know the reason why these records are considered as error records.

RE: When trying to load the hive data into Teradata table getting ERROR: TPT10510: Instance 1: Error Limit has been reached or exceeded.

Expert Answered on February 17, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.