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.

Symptoms

On : 12.2.4 version, CollabWB

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

ERROR
-----------------------
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(PhysicalConnection.java:3423)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3398)
at weblogic.jdbc.wrapper.Connection.createStatement(Connection.java:500)
at org.apache.commons.dbcp.DelegatingConnection.createStatement(DelegatingConnection.java:257)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.createStatement(PoolingDataSource.java:216)
at com.demantra.applicationServer.services.DBServicesCommon.executeSelect(DBServicesCommon.java:1460)


..
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: クローズされた接続です。:

STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
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.

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