My Oracle Support Banner

Simulation Engine Gives ORA-00942 on TABLE_INPUTS (Doc ID 1670016.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Demantra Demand Management - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

The simulation engine is showing an error while starting from the Engine Administrator or from a batch script.

11:17:41:474 [EngLogger.cpp,220] Logger General Level: message, UserLevel: message
11:17:41:474 Working with Oracle RDBMS
11:17:41:474 Database connection string: Provider=xxxxxx Data Source=xxxxxx User: xxxxxx
11:17:42:332 ----------------------------------------------------------------------------------------------------------------------------------------
11:17:42:332 Oracle Demantra Windows Forecast Engine Version 12.2.3 ( 12.2.3.0 Build 6 (2609) )
11:17:42:332 Engine Start Time 11:17:42 - 15/04/2014
11:17:42:332 Running in Simulation mode for profile ID: 1
11:17:42:332 ----------------------------------------------------------------------------------------------------------------------------------------
11:17:42:457 Loading parameters from INIT_PARAMS_0 table.
11:17:42:582 Loading parameters from INIT_PARAMS_1 table.
11:17:42:706 Calculated last date: 2014-01-27 (41666)
11:17:42:722 Calculated start date: 1995-01-01 (34700)
11:17:42:722 Calculated first forecast date: 2014-02-03 (41673)
11:17:42:722 ERROR ---------------------------------------------------------------
11:17:42:831 ERROR DB_Command::Execute threw an exception:
11:17:42:940 ERROR SELECT datet from TABLE_INPUTS WHERE datet 11:17:43:050 ERROR - ErrorDescription: ORA-00942: table or view does not exist

11:17:43:159 ERROR - ErrorNumber: 0x80040e37 - Undefined Error.
11:17:43:284 ERROR - NativeErrorNumber: 942
11:17:43:393 ERROR - ErrorDescription: Table does not exist.
11:17:43:502 ERROR - ErrorNumber: 0x80040e37 - Undefined Error.
11:17:43:611 ERROR - NativeErrorNumber: 0
11:17:43:720 ERROR Parameter 0 : 27:07:2015
11:17:43:830 ERROR Failed to calculate system dates!
11:17:57:776 CHECK_FORE_SERIES finished
11:17:57:776 Executing the shell...
11:17:58:182 Waiting for simulation requests...
11:17:58:182 Creating engines...
11:17:58:478 Engine (ID: 0) on machine localhost was successfully created and initialized
11:17:58:478 1 engines were created.
11:17:59:773 Computer localhost speed = 1.28



After this when the user tries to run a simulation on the worksheet it runs fine without seeing any error message on the screen. However the forecast results are 0 for the entire.

The Batch engine works fine and there are no issues with the Batch engine.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.