Report and Data Object Using External Data Source java.sql.SQLRecoverableException Closed Connection (Doc ID 1439874.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle BAM (Business Activity Monitoring) - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

The reports are created using data objects with external data source. After some time when a report is opened, the following error is printed in the view:

SQLRECOVERABLEEXCEPTION_NULL_NULL_NULL
Details...
Exception Message Closed Connection


When trying to see the content of the data object we receive the following error:

BAM-01262: Active Data Cache server exception in openViewset().

Details <<
BAM-01262: Active Data Cache server exception in openViewset().
Source: "ActiveDataCache" ID: "ADCServerException"
Closed Connection
Source: "java.sql.SQLRecoverableException: Closed Connection"


The exception in the log files reveal a problem with datasets.ExternalStorageEngine:

<Sep 6, 2011 5:01:01 PM WEST> <Notice> <Stdout> <BEA-000000> <Exception: java.sql.SQLRecoverableException: SQLError(17002) SQLState(08006) IO Error: Broken pipe
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:944)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
at oracle.bam.adc.common.externaldatasources.JDBC.getDataReader(JDBC.java:328)
at oracle.bam.adc.kernel.datasets.ExternalStorageEngine.getDataReader(ExternalStorageEngine.java:76)
at oracle.bam.adc.kernel.viewsets.utilities.externaldata.DataImporter.executeQuery(DataImporter.java:95)


Restarting BAM server resets the problem only to happen after some time again.

Additionally we have discovered that "remap" of the data object is making the dataobject available and the report display correctly the view

Note: This behaviour occurs on both in a non-cluster and a clustered environment.

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