IO (Legacy Collection Request) Is Not Working With A High Volume Of Data ORA-00054 ORA-06510 (Doc ID 1472763.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Data Collections

When attempting to run the Legacy Collection request finishes with an error about timeout when a high volume of data is used. This issue appears in the 3 instances (DBMBOC, TBMBOC & PBMBOC). With a small volume of data, the Legacy Collections works OK in the same 3 instances.


ERROR
-----------------------
30-APR 23:06:32 : MSC_CL_PRE_PROCESS.LOAD_ITEM(1)ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
30-APR 23:06:46 : .4 minutes elapsed.
30-APR 23:06:53 : Procedure LOAD_UOM_CLASS_CONV started.
30-APR 23:06:53 : 0 minutes elapsed.
30-APR 23:06:53 : Procedure LOAD_CAL_ASSIGNMENTS started.
30-APR 23:06:53 : 0 minutes elapsed.
30-APR 23:06:53 : Procedure LOAD_CATEGORIES_SOURCING started.
01-MAY 22:01:58 : 1375.1 minutes elapsed.
01-MAY 22:01:58 : ORA-06510: PL/SQL: unhandled user-defined exception

01-MAY 22:01:58 : Timeout error.

+---------------------------------------------------------------------------+

**Starts**30-APR-2012 21:15:48
**Ends**01-MAY-2012 21:15:53
MSC_PP_FAIL
+---------------------------------------------------------------------------+



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Execute the request in Inventory Planner > Collections > Legacy Systems > Collect Flat File Data.

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