Engine Fails With TargetTaskSize Set To Default

(Doc ID 1987693.1)

Last updated on JUNE 28, 2017

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 TargetTaskSize set to default

We have encountered a new issue with TargetTaskSize. When we set the parameter to default (which is 0), engine fails with lot of error. This was working fine earlier. 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. Attached are the logs and version details history.

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))



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run 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