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 JUNE 15, 2017

Applies to:

APM - Application Performance Management - Version 12.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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:

\Oracle\Middleware\10.3.6.0\user_projects\domains\<YOUR_DOMAIN>\btmstorage\btmcentral\sphere\logdir

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.

Changes

 

Cause

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