Worksheet Not Opening By Clicking On Worksheet In Myworksheet In Collaborator Workbench - java.sql.SQLRecoverableException

(Doc ID 2222607.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, CollabWB

When attempting to open the worksheets,it fails to load data
the following error occurs.

2017-01-03 15:55:36,821 JST [[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR appserver.error:
java.sql.SQLRecoverableException: クローズされた接続です。
at oracle.jdbc.driver.PhysicalConnection.createStatement(
at oracle.jdbc.driver.PhysicalConnection.createStatement(
at weblogic.jdbc.wrapper.Connection.createStatement(
at org.apache.commons.dbcp.DelegatingConnection.createStatement(
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.createStatement(

2017-01-03 15:58:47,454 JST [[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR collaborator.sql: ODPM-70293: Error in getUserContainerPane: java.sql.SQLRecoverableException: クローズされた接続です。:

The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench as dm user.
2. Try to open an worksheet.
3. It fails to load data.

The issue has the following business impact:
Due to this issue, users cannot open the worksheets. User cant work in Demantra and system is just went live.


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