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

Last updated on APRIL 27, 2016

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=MSDAORA;Data Source=DEMDEV User: DEMANTRA_DEV
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.

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