BTM JDBC Connections Are Being Closed With the Following Message in the Logs: java.sql.SQLRecoverableException: Closed Connection
Last updated on JUNE 15, 2017
Applies to:APM - Application Performance Management - Version 188.8.131.52.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms