12.2.6.1 Install And Run Simulation Engine To Test Engine And Failing With ORA-00942: table or view does not exist engine_communication

(Doc ID 2282467.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.6.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.1 version,

Installed Demantra 12.2.6.1 after which upon unning the Start_Simulation2K.sh to test engine. The same fails with the error:

 

ERROR
-----------------------

10:08:21:378 Executing the shell...
10:08:21:392 ERROR ---------------------------------------------------------------
10:08:21:392 ERROR DB_OracleCommand::Execute threw an exception. Error: 942 ORA-00942: table or view does not exist

10:08:21:392 ERROR SQL :DELETE ENGINE_COMMUNICATION WHERE EXECUTION_ID = 1
10:08:21:392 ERROR ---------------------------------------------------------------
10:08:21:392 WARNING DeleteFromTable() failed to delete rows from table: ENGINE_COMMUNICATION
10:08:21:395 ERROR ---------------------------------------------------------------
10:08:21:395 ERROR DB_OracleCommand::Execute threw an exception. Error: 942 ORA-00942: table or view does not exist

10:08:21:395 ERROR SQL :INSERT INTO ENGINE_COMMUNICATION (EXECUTION_ID, PNAME, PTYPE, VALUE_FLOAT, VALUE_DATE, VALUE_STRING, VALUE_CLOB) VALUES (:1, :2, :3, :4, :5, :6, :7)
10:08:21:395 ERROR ---------------------------------------------------------------
10:08:21:395 ERROR ---------------------------------------------------------------
10:08:21:395 ERROR Database Error [EngineManager.cpp,1786]
10:08:21:395 - Source:
10:08:21:395 - Description: Failed to Execute Oracle Command
10:08:21:395 - Error Number:
10:08:21:395 ---------------------------------------------------------------
10:08:21:396 Total Engine Time 0 Hours, 0 Minutes, 13 Seconds



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install 12.2.6.2
2. Run simulation

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the simulation scenarios as the engine fails

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