BTM JDBC Connections Are Being Closed With the Following Message in the Logs: java.sql.SQLRecoverableException: Closed Connection
(Doc ID 1462656.1)
Last updated on AUGUST 19, 2022
Applies to:APM - Application Performance Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
The Business Transaction Management (BTM) Console starts to hang and these messages appear in the BTM log files:
[DRIVER-THROWN-EXCEPTION] java.sql.SQLRecoverableException: Closed Connection
com.amberpoint.datastore.DataStoreException: Rollback failed: SQLState:08003, ErrorCode:17008, Message:Closed Connection stack:java.sql.SQLRecoverableException: Closed Connection
com.amberpoint.datastore.DataStoreException: Commit failed: SQLState:08003, ErrorCode:17008, Message:Closed Connection stack:java.sql.SQLRecoverableException: Closed Connection
The above errors typically appear in the log files for the AP_SPHERE_SERVICE service. These log files are usually found in a directory that looks like this:
Another way to view the log files for the BTM Sphere service it to do the following:
1) Log into the BTM UI
2) Navigate to Administration >> System Services.
3) Highlight AP_Sphere_Service
4. Click on the menu item: Admin >> Open System Service Log for AP_Sphere_Service
You can view the errodr from here. Also, the box in the upper right corner shows you where the actual log can be found.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document