MRCRLF: Planning Manager Fails With Message In Log - APP-FND-00416: Function sfmmll cannot allocate memory for buffer because system is out of memory. Routine afpprq received a return code of failure (Doc ID 2927913.1)

Last updated on MARCH 10, 2023

Applies to:

Symptoms

Launch the Planning Manager and find that after some time it fails, then the automated restart process will restart the process under new Request ID, but then it fails and restarts continually. It should restart with same Request ID until 00:00:00 (Midnight) and show no failures.

NAV: Material Planner(R) / Setup / Planning Manager
 - click Start to button to Launch - then refresh to see messages printed in the form for each iteration of this processing manager
Review the messages in the form  - The messages with Request ID=[number] should repeat until 00:00:00 (Midnight) and then relaunch with a new request ID
- In this example, a new request is launched very often with a new request ID - which indicates there is a problem and that the log files should be reviewed. Also find a message in the form indicating a memory issue.


TRANSACTION_ID LAST_UPDATE_DATE LAST_UPDATED_BY MESSAGE
-------------- ------------------------ --------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  11806109 16-JUN-22 09:42:55 21736
  11806108 16-JUN-22 09:42:55 21736 Started Planning Manager (Interval=30, Request ID=604152894)
  11806107 16-JUN-22 09:42:55 21736 Started Planning Manager (Interval=30, Request ID=604152894)
  11806106 16-JUN-22 09:38:55 21736
  11806105 16-JUN-22 09:38:55 21736 Started Planning Manager (Interval=30, Request ID=604152362)
  11806104 16-JUN-22 09:38:55 21736 Started Planning Manager (Interval=30, Request ID=604152362)
  11806103 16-JUN-22 09:26:55 21861
  11806102 16-JUN-22 09:26:55 21861 Started Planning Manager (Interval=1800, Request ID=604151016)
  11806101 16-JUN-22 09:26:55 21861 Started Planning Manager (Interval=1800, Request ID=604151016)
  11806100 16-JUN-22 09:10:55 21861
  11806099 16-JUN-22 09:10:55 21861 Started Planning Manager (Interval=1800, Request ID=604149379)
  11806098 16-JUN-22 09:10:55 21861 Started Planning Manager (Interval=1800, Request ID=604149379)
  11806097 14-JUN-22 18:19:52 22378
  11806096 14-JUN-22 18:19:52 22378 reset_interface_table: Cannot allocate memory for SQL statements
  
  Cause: The current routine cannot allocate memory for the specified entity.
  
  Action: Contact your customer support representative.
  
  11806095 14-JUN-22 18:19:52 22378 Launched concurrent request 603914658 for Daily cleanup worker
  11806094 14-JUN-22 18:19:52 22378 Started Planning Manager (Interval=30, Request ID=603914358)
 
Planning Manager Log file shows messages like

MRCRLF: Planning Manager
+---------------------------------------------------------------------------+

Current system time is 26-OCT-2022 00:05:16
....
APP-FND-00416: Function sfmmll cannot allocate memory for buffer because system is out of memory. Routine afpprq received a return code of failure.

Contact your system administrator or support representative.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 26-OCT-2022 13:09:23

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.