java.sql.SQLException: javax.resource.ResourceException: IJ000453 error in IDM log

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

We migrated our prod IDM to 14.3 and switched our IDM database to use a new schema. Today we received

java.sql.SQLException: javax.resource.ResourceException: IJ000453  

in the IDM logs. The error was gone once I recycled IDM. Please advise.

Resolution

The log indicates that the SQL exceptions occurred as a result of the database forcibly closing connections. Just prior to the IJ000453 errors we see...

....java.sql.SQLRecoverableException: IO Error: An existing connection was forcibly closed by the remote host, Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:794) [ojdbc8.jar:]......

The Oracle driver reported that the remote host closed the connection.

Consult with your Oracle Database team to see if there were any problems on the database at or around the time of the errors, and to investigate possible issues with the driver.