Demantra Tomcat Error And Collaborator Workbench Not Responding (Doc ID 2105569.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Technical

Customer gets the following Tomcat errors when Demantra Collaborator Workbench is not responding.
This happens quite a lot of time.
 
ERROR
-----------------------

....ERROR appserver.error:java.lang.NullPointerException
..
...
....ERROR tunnel.general: ODPM-70106: Task[52] encountered error in the facade code
....ERROR tunnel.general: org.apache.catalina.connector.ClientAbortException: java.net.SocketException: Software caused connection abort: socket write error
..
...
Caused by: java.net.SocketException: Software caused connection abort: socket write error
..
...
....ERROR appserver.error: ###### ------ DB Connection Pool Status: [2016-02-03 08:47:24.578JDBC pool status: active(3), idle(1).
....ERROR appserver.error: ###### ------ DB Connection Pool Status: Active connections borrowed by:
....ERROR appserver.error: java.sql.SQLException: Io exception: Software caused connection abort: recv failed
..
...
....Caused by: java.net.SocketException: Software caused connection abort: recv failed
....ERROR appserver.error: java.sql.SQLException: OALL8 is in an inconsistent state


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start the Demantra Tomcat server.
2. Attempt to log in to the Collaborator Workbench.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the Collaborator Workbench

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