Thursday, April 6, 2017

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.

No comments:

Post a Comment