After Resolving Loops, We Still See Hanging In RP Plan Copied From ASCP

(Doc ID 2251073.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

12.1.3.9.2
engine.zip - 120.46.12010000.271

PROBLEM
-------------
We are seeing stuck threads with plans that are copied from ASCP to RP

We are seeing stuck thread issue while running the Plans. We have tried to terminate the plans, bounce the servers and re-launched the plans.
But every time we are facing the same issue.
Attached the stuck-thread screen-shot from RP Engine Weblogic Console (see below)
Attached the concurrent program log for the plan along with the managed server log.

The max stuck thread time is already set to 3600s.

STATUS PLAN_ID COMPILE_DESIGNATOR REQUEST_ID
---------- ---------- ------------------ ----------
  5 10023 plan_A 1450956

SO -- asked if standalone RP plans had problems with Stuck Threads and they reported:

RP standalone plan is getting completed.
--- Item data can be loaded successfully and it can be searched but supplies data load is giving error
--- 'Error from web service: Plan 7021 is not loaded'.

BUSINESS IMPACT
----------------------
Cannot progress in testing RP on 12.1.3.9.2

Example of stuck Thread and log file

 FIG 1  

 

FIG 2

 

PARTIAL LOG FILE

.......
Thu Feb 09 02:07:43 PST 2017 itemFilePath=/logs_crp/appl/conc/out/data10023/mbpoutput/MSLD_ITEMS.dat
Thu Feb 09 02:07:43 PST 2017 APPLCSF=/logs_crp/appl/conc/out/
Thu Feb 09 02:07:43 PST 2017 importDir=/logs_crp/appl/conc/out//data10023/mbpoutput outputDir=output/data10023 schemaDir=/logs_crp/appl/conc/out//data10023/mbpoutput
Thu Feb 09 02:07:43 PST 2017 INIT ENGINE
Thu Feb 09 02:07:43 PST 2017 IMPORT MBP

PROFILE VALUES:
DBSequence Cache Size : 1000
Inflate WIP : true
Firm PR tranferred to OE : false
Use Safety Lead Time : false
RP Group Planned Orders : 0
Released WIP Jobs : Consider in Clear to Build : false
Consider Natural Time Fence : false
Consider Firm Planned Order Time Fence : false
Consider Firm Internal Requisition Time Fence : false
Consider Partion Env : true
MSC_RP_SAFETY_STOCK_METHOD : 0
MSC_SS_SMOOTH_NON_MRP : false
MSC_SS_SMOOTHING_METHOD : 2
MSC_SS_INTERVAL_DAYS : 1
MMSC_SS_MAX_VARIATION : -23453
MSC_SS_MIN_VARIATION : 0
MSC_SS_BUCKET_START_OFFSET_DAYS : 0

MSLD_FLAT_PROFILE_VAL :: Time in MS : 79 :: Memory usage in MB: 0
MSLD_FLAT_PLAN_MISC :: Time in MS : 4 :: Memory usage in MB: 0
MSLD_FLAT_PLAN :: Time in MS : 8 :: Memory usage in MB: 0
MSLD_FLAT_PLAN_ORG :: Time in MS : 4 :: Memory usage in MB: 0
MSLD_FLAT_CALENDAR :: Time in MS : 967 :: Memory usage in MB: 137
MSLD_CALENDAR_ASSIGNMENTS :: Time in MS : 7 :: Memory usage in MB: 0
MSLD_ITEMS :: Time in MS : 6057 :: Memory usage in MB: 1426
invalid line 61322 in MSLD_FLAT_ITEMS: # of fields is 5 but supposed to be 11
invalid line 61323 in MSLD_FLAT_ITEMS: # of fields is 7 but supposed to be 11
MSLD_FLAT_ITEMS :: Time in MS : 506 :: Memory usage in MB: 114
MSLD_ASCPRP_ITEM_CAT :: Time in MS : 323 :: Memory usage in MB: 63
MSLD_ITEM_SUPPLIERS :: Time in MS : 12 :: Memory usage in MB: 1
MSLD_SUPPLIER_CAPACITIES :: Time in MS : 0 :: Memory usage in MB: 0
MSLD_ITEM_SUBSTITUTION :: Time in MS : 0 :: Memory usage in MB: 0
MSLD_RESOURCES :: Time in MS : 10 :: Memory usage in MB: 0
MSLD_SOURCING :: Time in MS : 429 :: Memory usage in MB: 113
MSLD_PROCESS_EFF :: Time in MS : 311 :: Memory usage in MB: 85
MSLD_CAP_RES :: Time in MS : 5458 :: Memory usage in MB: -450
MSLD_COMPONENTS :: Time in MS : 1102 :: Memory usage in MB: 428
MSLD_SUBSTITUTE_ITEMS :: Time in MS : 1 :: Memory usage in MB: 0
MSLD_OPER_NETWORK :: Time in MS : 1 :: Memory usage in MB: 0
MSLD_RES_AVL :: Time in MS : 5823 :: Memory usage in MB: 488
MSLD_SUPPLIES :: Time in MS : 1107 :: Memory usage in MB: 669
MSLD_RES_REQS :: Time in MS : 15514 :: Memory usage in MB: -363
MSLD_DEMANDS :: Time in MS : 3890 :: Memory usage in MB: -402
MSLD_TRANS_RESOURCES :: Time in MS : 10 :: Memory usage in MB: 0
MSLD_VENDOR_ORG_INTRANSIT :: Time in MS : 1 :: Memory usage in MB: 0
MSLD_ORG_CUSTOMER_INTRANSIT :: Time in MS : 0 :: Memory usage in MB: 0
MSLD_SAFETY_STOCK :: Time in MS : 12 :: Memory usage in MB: 3
MSLD_SNAP_SS :: Time in MS : 8 :: Memory usage in MB: 0
Loading Files :: Time in MS : 42114 :: Memory usage in MB: 2326
initResourcePlans :: Time in MS : 386 :: Memory usage in MB: 45
setProducingOperations :: Time in MS : 284569 :: Memory usage in MB: 2256
initBufferPlans :: Time in MS : 461 :: Memory usage in MB: 131
reCalculateItemPTF :: Time in MS : 3 :: Memory usage in MB: 0
createWipOperations :: Time in MS : 613 :: Memory usage in MB: 80
createFPOOperations :: Time in MS : 1081 :: Memory usage in MB: 36
RPEImport :: Time in MS : 329348 :: Memory usage in MB: 4878
sql=UPDATE MSC_PLANS SET STATUS=5 WHERE PLAN_ID=10023
sql=UPDATE MSC_PLANS SET SUMMARY_FLAG=0 WHERE PLAN_ID=10023
Thu Feb 09 02:13:12 PST 2017 RUN PLAN
Thu Feb 09 02:13:13 PST 2017 dir=/u01/RP/Middleware/wlserver_10.3/user_projects/domains/RPEngine
Thread0 { Start Collecting Shared Components
Total No of Items Inspected : 444
Total No of End Items with sharing : 7
Total Time Spent in Collecting Shared Components in MS : 87
} Exit Collecting Shared Components Thread0

 

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