My Oracle Support Banner

Engine Fails with Exception error ORA-00942 (Doc ID 1987693.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Demantra Predictive Trade Planning - Version 7.3.1.5 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1.5 version, Engine

Engine Fails with Exception error ORA-00942

Example of the result of this issue is

Example 1:

=======


When the parameter TargetTaskSize was changed to default (which is 0), engine fails with lot of error. The issue seems to have cropped up with the recent patch 20415508

The logs suggests that when the second branch is generated, the engine creates MDP_2 table but some portion of code still refers to MDP_1 which is resulting in error.

11:17:04:135 *** Query 12260 Ended ***
11:17:06:882 11:17:06:878 ERROR ---------------------------------------------------------------
11:17:06:884 11:17:06:878 ERROR DB_OracleCommand::Execute threw an exception. Error: 942 ORA-00942: table or view does not exist

11:17:06:886 11:17:06:878 ERROR SQL :SELECT sum(p1), sum(p2), sum(p3), sum(p4), sum(p5), sum(p6), sum(p7), sum(p8), sum(p9), sum(p10), sum(p11), sum(p12), sum(glob_prop) ,0,0,0,0,0,0,0,0,0,0,0,0,0,0 FROM MDP_1 WHERE 0=0 and T_EP_P2A_EP_ID = :1 AND T_EP_LR2A_EP_ID = :2 and do_fore = 1 and (prediction_status = 1 or (prediction_status = 98 and psum_98=1) or (prediction_status = 99 and psum_99=1))

 


Example 2:

=========

 

The simulation engine is showing an error while starting from the Workflow or from a batch script:

13:03:41:562 ---SQL Start: ----------------------------------------------
13:03:41:562 SELECT max(datet) from TABLE_INPUTS WHERE datet <= :1
13:03:41:562 ---SQL End: ----------------------------------------------
13:03:41:583 ERROR ---------------------------------------------------------------
13:03:41:583 ERROR DB_OracleCommand::Execute threw an exception. Error: 942 ORA-00942: table or view does not exist

13:03:41:583 ERROR SQL :SELECT max(datet) from TABLE_INPUTS WHERE datet <= :1
13:03:41:583 ERROR ---------------------------------------------------------------
13:03:41:583 ERROR Failed to calculate system dates!



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run batch or Simulation engine

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!


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