Rapid Plan Shows Running in UI And Hangs/Performance is Poor But Engine Log shows Hundreds of Error MaxLoopCount exceeded (Doc ID 2100362.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Rapid Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Planning Engine in CRP

Users are on 12.2.4 and have applied VCP Cum Patch 12.2.4.1 - 19549533. They have several one offs for Rapid Planning and here are their current file versions:

engine.zip 120.134.12020000.116
RPAdmin.zip 120.5
RPUIDomainTemplate.zip 120.0.12020000.2
ui.zip 120.206.12020000.107

They are running into a problem where the plan appears to be in running status in the RP UI and hanging. However when they check the engine log they see up to 600+ of the following:

4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_50632_67517_1722110_136668
  4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_50632_67517_1722110_136668
  4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_50632_67517_1722110_136668
  4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_36995_67546_1722082_133744
  4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_36995_67546_1722082_133744
  4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_36995_67546_1722082_133744
  4 Error MaxLoopCount exceeded in RoutingOperationPlanner::planLotSized FOR ITEMREQUEST NO : 0 FOR ROT_OP : ROUTING_OP_36995_67546_1722082_133744
  Merging operation Starts :: Time in MS : 231993 :: Memory usage in MB: 249
  LBL Planning :: Time in MS : 248765 :: Memory usage in MB: -2731
  RPEPlan :: Time in MS : 248791 :: Memory usage in MB: -2751
  sql=UPDATE MSC_PLANS SET STATUS=6 WHERE PLAN_ID=1028
  Wed Dec 09 08:54:25 CST 2015 EXPORT SOLUTION
  CLEARING THE RESERVED DEMANDS MAP
  Total Time spend in End Item Subs : 0
  Total Time spend in creating End Item Demands 1061
  Total Time spend in make processes/buy/transfer : 150182
  Total time spend for Firm wips : 116
  Total time spend for FPO : 4
  Total Time spend for CO Wip : 9
  For Creating SupplyBase/Demands :: Time in MS : 151410 :: Memory usage in MB: 4911
  ** Number of Constraints : 0
  Create peggings of buffer level 1 completed.
  Create peggings of buffer level 2 completed.

This was happening intermittently and bouncing engine domain and managed server usually would allow the plan to complete. However now the plan hangs everytime. We suspect some sort of data problem. Other RP plans are completing fine

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run RP Plan
2. Intermittently hangs with logs of max loop failures
3. Bouncing WLS usually helps
4. Now it's hanging everytime even when bouncing WLS


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