RP Plan Hangs/Performance With Plan Status: Solving Plan
(Doc ID 2130564.1)
Last updated on JUNE 29, 2017
Oracle Rapid Planning - Version 12.2.4 and later Information in this document applies to any platform.
On : 12.2.4 version, Planning Engine in Test
Users are on 12.2.4 and have applied 220.127.116.11 VCP patching. They also applied one off patch 22853045 17-MAR-2016 with file version engine.zip 120.134.12020000.128
Users are running an unconstrained plan and a week ago it was completing fine. Now the plan hangs and is stuck in Solving Plan status and will not complete. Engine log shows
sql=UPDATE MSC_PLANS SET STATUS=5 WHERE PLAN_ID=19034 Wed Mar 30 17:48:32 GMT+00:00 2016 sql=ALTER TABLE MSC.MSC_RP_ITEM_UPDATES TRUNCATE PARTITION RP_ITEM_UPDATES_19034 sql=UPDATE MSC_PLANS SET SUMMARY_FLAG=0 WHERE PLAN_ID=19034 Wed Mar 30 17:48:32 GMT+00:00 2016 RUN PLAN
********** START OF planner_.planRequests() ******* 3 Warning: No OnHand, but there is a reserved Qty 3 Warning: Reserved Qty is greater than OnHand 3 Warning: No OnHand, but there is a reserved Qty Merging operation Starts :: Time in MS : 1 :: Memory usage in MB: 0 LBL Planning :: Time in MS : 14429 :: Memory usage in MB: -258 RPEPlan :: Time in MS : 14563 :: Memory usage in MB: -258 sql=UPDATE MSC_PLANS SET STATUS=6 WHERE PLAN_ID=19034 Wed Mar 30 17:48:46 GMT+00:00 2016 EXPORT SOLUTION CLEARING THE RESERVED DEMANDS MAP Total Time spend in End Item Subs : 0 Total Time spend in creating End Item Demands 414 Total Time spend in make processes/buy/transfer : 22952 Total time spend for Firm wips : 1275 Total time spend for FPO : 8 Total Time spend for CO Wip : 4 For Creating SupplyBase/Demands :: Time in MS : 24707 :: Memory usage in MB: 527 ** Number of Constraints : 0
They have 7 gig assigned as Heap Memory size for the Engine Managed Server and still shows 40% free while hanging
EXPECTED BEHAVIOR ----------------------- Expect plan to complete
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Run unconstrained RP plan 2. Plan used to complete and now hangs and will not complete
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!