Receiving Error In The Demantra Simulation Engine dpweb.spreadsheet: Series null_val is not in the model (Doc ID 866294.1)

Last updated on MARCH 20, 2013

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.
Checked for relevance on 3-Oct-2011


Symptoms

On 7.2 in Production:
When attempting to run simulation on any worksheet/combination, the following error occurs.

ERROR WriteForecast threw an exception caught for node

The collaborator log shows the following error: 

ERROR dpweb.spreadsheet: Series null_val is not in the model this is probably a dependency problem
2009-06-24 08:05:47,056 [Query_Execution_123] ERROR dpweb.spreadsheet: Series null_val is not in
the model this is probably a dependency problem 2009-06-24 08:07:18,012 [DataRunner27] ERROR
appserver.error: com.demantra.applicationServer.appServerExceptions.DateNotExistException: The
given record date is not valid for the query [Mon Nov 29 00:00:00 CST 2010].17447_509 at
com.demantra.applicationServer.util.DateTimeServices.getEndDate(DateTimeServices.java:540) at
com.demantra.applicationServer.metaDataObjects.query.Query.findEndDate(Query.java:1203) at
com.demantra.applicationServer.services.QueryDataSource.getLastEndDate(QueryDataSource.java:481)
at

However if the user changes the time stamp to only go out to say Dec 2009, the simualtion completes successfully

STEPS
The issue can be reproduced at will with the following steps:
1. Login to CW
2. Open Worksheet
3. Run simulation

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