ECC Constrained ASCP Plan Hangs When Enforce Purchasing Lead-Time Constraints Is Enabled (Doc ID 806443.1)

Last updated on SEPTEMBER 23, 2015

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
EXECUTABLE:MSONEW - Memory Based Planner
EXECUTABLE:MSONWA64 - Memory Based Planner 64-bit AIX
EXECUTABLE:MSONWH64 - Memory Based Planner 64-bit HP
EXECUTABLE:MSONWS64 - Memory Based Planner 64-bit Sun
Checked for relevance on 19-Apr-2011

Symptoms

Users are on a lower ASCP Engine/UI RUP#25 patch 6150744. They've been running ECC constrained plans for some time now.  However they have started to hang (ie performance problem) in MSONWA64 module: Memory Based Planner 64-bit AIX and the following is the last statement in the debug log file:

pthread_create status for clone 2 = 0
Main thread waiting for a clone to solve lp 3
Entering clone 0
Entering clone 2
Cloning time for clone 1 = 1 seconds
Clone 1 started solving lp 3
CPX_PARAM_ITLIM = 100000000
Cloning time for clone 0 = 1 seconds
Clone 0 started solving lp 3
CPX_PARAM_ITLIM = 100000000
Cloning time for clone 2 = 1 seconds
Clone 2 started solving lp 3
DSM CPX_PARAM_BARITLIM = 1000000
Barrier optimization status (3,2) = 3
Clone 2 finished solving the problem: status = 0
Time taken (3,2): t = 8 seconds.
lpstat (3,2): = 3
status (3,2): = 0
Clone 0 finished solving the problem: status = 0
Time taken (3,0): t = 8 seconds.
lpstat (3,0): = 3
status (3,0): = 0
Clone 1 finished solving the problem: status = 0
Time taken (3,1): t = 10 seconds.
lpstat (3,1): = 3
status (3,1): = 0


The tkprof trace shows no problem areas even after running for several hours at all and the last statement in the raw trace file is the following:


However, if they disable the plan option called Enforce Purchasing Lead-time Constraints, the Memory based planner completes in about 2.5 hours successfully. Also an unconstrained plan runs successfully. Gathering Schema Stats for MSC at 100% does not help


STEPS:
1. Run ECC constrained plan with Enforce Purchasing Lead-time Constraints enabled
2. Plan hangs forever in the Memory Based Planner 64-bit AIX
3. Disable Enforce Purchasing Lead-time Constraints in the plan options and the plan completes successfully with MBP 64 bit AIX running for 3 hours

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