What is 7593 error and how to avoid it?

Problem :

What is 7593 error and how to avoid it?

# Below are error text samples from DBQL.

Error limit of 1 is reached; errors logged in ABCD_ERR where ETC_dbql_qid = 163829702788291360.

Error limit of 1 is reached; errors logged in ABCD_ERR where ETC_dbql_qid = 163829702788467780.


Environment/Conditions/Configuration :

TDBMS 14.10.06.05


Cause  :

Error 7593 occurs when error limit logging has been reached on an INSERTSELECT or MERGEINTO query.


Solution :

To avoid the error:

1) Increase the error limit.

> For example: "LOGGING ALL ERRORS WITH LIMIT OF <larger number>".

2) Review the query and ensure that no error rows will occur (or within the limit) from the MERGEINTO statement.