Demantra Accessing Certain Worksheets Gets OutOfMemory Error In Java Console (Doc ID 452030.1)

Last updated on DECEMBER 15, 2014

Applies to:

Oracle Demantra Demand Management - Version 6.2 to 7.2.0.2 [Release 6 to 7.2]
Information in this document applies to any platform.
***Checked for relevance on 29-May-2012***

Symptoms

User note performance of opening worksheets is degrading over time. When attempting to open some
worksheets, the following error message is displayed:

Unable to Connect to the Server!

In the java console the following is displayed many times when the above message is encountered:

java.lang.OutOfMemoryError

484396 INFO [Get_Mata_Data_Thread] query.data - Note: Query Heidi_Month_End _Report loaded, contains 7004 combinations

Error - com.demantra.partner.client.model.crosstab.CrosstabTwoDimModel.calcTotal() - ExtendedTwoDimModel is null.

Error - com.demantra.partner.client.model.crosstab.CrosstabTwoDimModel.calcTotal() - ExtendedTwoDimModel is null.

Clearing jcache and running statistics on tables/indexes does not resolve the issue

STEPS
The issue can be reproduced at will with the following steps:
1. Open a particular worksheet
2. Error message is displayed

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