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  

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