Copy ASCP Plan To RP Plan Got Error MaxLoopCount exceeded in SimpleBufferPlanner (Doc ID 2082632.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

On : 12.1.3.9.1 version, Webservices (VCP 12.1.3.9.1 Patch 17350769)

ACTUAL BEHAVIOR
---------------
Oracle RP R12.1.3.9.1: Copy ASCP To RP Got Error

ASCP & RP prod system is online last week. The version for them is Version R12.1.3.9.1

Error2: When we were copying ASCP plan to RP plan in Oracle ASCP system via menu 'Open Simulation' in the toolbar, the form 'Open Simulation -Status' never closed automatically
although the progress bar showed 100% and the request completed successfully in the background. When we were logging in the RP web UI at that time, we could see the new copied RP plan
always showed a cycling icon. We found field 'STATUS' for the RP plan in the DB is '5'. The screenshot files are 'Copy RP Progress Bar Form Doesn't Close After 100 Percent In ASCP.jpg' and
'Copy RP Request End But UI Never End.jpg'. This issue happens for ASCP plan 'GUWENTEST' (PLAN ID is 51027), and the error RP plan is 'GUWENRP4' (PLAN ID is 51034).
The ASCP 51027's plan option is 'ASCP PLANID 51027 Plan Options.rar'.

BTW, not all the copying got error in Oracle ASCP. When we were copying some ASCP plans to RP plan in Oracle ASCP via 'Open Simulation', sometimes it completed successfully,
such as copy ASCP plan 'GUWENTEST1' (PLAN ID is 51031) to RP plan 'GUWENRP6' (PLAN ID is 51036). This plan had only one planning organization. The ASCP 51031's plan option is 'ASCP PLANID 51031 Plan Options.rar'.

ANALYSIS
-------------------------
It has been determined after lot of Debugging till now as :
We have 9 planning organizations. If we copy RP plan which has only the specified planning organization, it runs about half an hour to finish the copying; If we copy RP plan which has other 8 planning organizations, it runs less than 20 minutes; If we copy RP plan which has the whole 9 planning organizations, the copying process never ends. So, we think whether the bad data in this specified organization causes this issue.

Currently, the RP plan 56025's status in msc.msc_plans is '5'. FYR.

The plan with the 9 Planning Organizations is stuck as stated above, and the engine log has the below error :


ERROR
-----------------------

Compute Buffer Levels :: Time in MS : 5592 :: Memory usage in MB: 977
 Warning: No OnHand, but there is a reserved Qty

  Warning: Reserved Qty is greater than OnHand

 Planning Clear To Build Orders :: Time in MS : 435 :: Memory usage in MB: 61
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 9914_327_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 532053_447_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 532053_447_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 483094_168_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 483094_168_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 483094_168_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 483094_168_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 483094_168_1
  2 MaxLoopCount exceeded in SimpleBufferPlanner::plan FOR ITEMREQUEST NO : 0 FOR BUFFER : 458030_610_1
 Planning Firm Orders :: Time in MS : 5789 :: Memory usage in MB: -559
 Planning Safety Stock for items :: Time in MS : 51 :: Memory usage in MB: 0

STEPS TO REPRODUCE
-------------------------------------
1. Navigate to Responsibility > Advanced Supply Chain Planner. & Supply Chain Simulation Planner.
2. Run a ASCP plan with MPS as Demand schedule
3. Copy ASCP plan to RP plan
4. All the concurrent requests Memory based snapshot and Rapid Planner complete fine.
5. The UI still shows the RP plan as running with the running icon not getting completed.



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