Performance Issue MSONWS64 - Memory Based Planner 64-bit Sun In HLS Slice Stage
(Doc ID 2188844.1)
Last updated on SEPTEMBER 01, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.5.1 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5.1 version, Constrained Planning in Test:
Users are on 12.2.5 and have applied VCP Consolidated update #2 patch 22493520. They are using 64 bit Sun MBP with MSONWS64.ppc 120.26.12020000.19 and no one off patches at this time. Users are running an EDD Classic Constrained plan. However the plan will not complete even after letting it run for 14+ hours. The log file shows the following key findings and where it stops:
MSONWS64 module: Memory Based Planner 64-bit Sun
one in flushing to flatfiles total items 4259
.....Flush Flat Items completed 0:00
done flushing to items flatfiles
.....Create transactions tree completed 0:00
....Load data completed 0:01
....Optimization completed 0:44
pre_reduce_ss is false
......mrprs_pre_reduce_ss completed 0:00
.....Net+Peg+PushDown AllItems completed 7:17
The log got into HLS and here are the last lines
add min effective time -2880 to operation 47048
TIMER: slice 0 phase 2 time = 1882
TIMER: slice 0 phase 2 time = 0
HLSHeuristic2: --------- START OF PHASE 3 -------------
TIMER: slice 0 phase 3 time = 37649
Memory Used: 7875.19 MB; Scheduling duration: 731.416 Mins
====================================================
Slice # 2 (3943 demands) from priority: 999999 to: 999999 ----stops here
EXPECTED BEHAVIOR
-----------------------
Expect the plan run to complete in 2 hours or less
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run EDD Classic Constrained Plan
2. Plan will not complete and is stuck in MBP concurrent request that will not finish even after 14+ hours
Changes
Upgraded from 12.1.3 to 12.2.5
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |