Can't execute statement [delete from HIST_PENDING_REMOVES where CUSTOMER_ID=1], due to exception: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.

  • KM03485494
  • 30-Jul-2019
  • 30-Jul-2019

Summary

Execution timeout expired.

Error

Caused by: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
Can't execute statement [delete from HIST_PENDING_REMOVES where CUSTOMER_ID=1], due to exception: java.sql.SQLTimeoutException: [mercury][Oracle JDBC Driver]Execution timeout expired.

Cause

Execution timeout expired when running a delete command on the DB table.

Fix

Clean the "HIST_PENDING_REMOVES" table.