Memory Based Snapshot Fails - APP-MRP-22086: mrllbc_load_bom_components: Cannot allocate memory for exb_bom_tree (Doc ID 2088767.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

In an 11.5.10.2 instance,
They have MRP Rollup #17 - patch 7350793

When running an MRP plan, the 'Memory-based Snapshot Worker' completes with the following error:

MAIN ERROR BELOW IS APP-MRP-22086: mrllbc_load_bom_components: Cannot allocate memory for exb_bom_tree

APP-MRP-22086: mrllbc_load_bom_components: Cannot allocate memory for exb_bom_tree
Cause: The current routine cannot allocate memory for the specified entity.
Action: Contact your customer support representative.
APP-MRP-22075: An internal error has occurred (mrnspxt, 14, 10005, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10005, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (main, 13, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
gthsk1=131523
gthsk2=2
gthsk3=1
gthsk4=1
***** End Of Program - Memory-based Snapshot Worker *****
APP-FND-01564: ORACLE error 1008 in post_req_processing
Cause: post_req_processing failed due to ORA-01008: not all variables bound.
The SQL statement being executed at the time of the error was: select phase_code,status_code into :p,:s from fnd_concurrent_requests where request_id=:r and was executed from the file &ERRFILE.
Concurrent program returned no reason for failure.

We see ulimit -aS on two different application servers as
$ hostname
etad509
$ ulimit -aS
time(cpu-seconds)    unlimited
file(blocks)         unlimited
coredump(blocks)     0
data(kbytes)         unlimited
stack(kbytes)        10240

$ hostname
edad609
$ ulimit -aS
time(cpu-seconds)    unlimited
file(blocks)         unlimited
coredump(blocks)     0
data(kbytes)         unlimited
stack(kbytes)        10240

BUT when changed stack to unlimited - it did not help this issue.

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