Unconstrained Msonwa64 Memory Based Planner 64 bit AIX Errors Signal 9 (Doc ID 1274606.1)

Last updated on JULY 15, 2015

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 12.2.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Executable:MSONWA64 - Memory Based Planner 64-bit AIX
Executable:MSONEW - Memory Based Planner

Symptoms

Users are on ASCP Engine/UI RUP#40 running unconstrained plan. The plan was completing just fine through this past Sunday night. Thereafter it fails with the following in MSONWA64 module: Memory Based Planner 64-bit AIX with debug enabled:

MSO_SUPPLY_WIN. : 1
MSO_DEMAND_WIN. : 1
MSC_DEMAND_SA_PER_THRESHHOLD. : 100.000000
MSC_MIN_SUP_DEM_PER_PEG. : 0.000000
add attr: -23453 -23453 -23453 -23453 =>
add attr: -23453 -23453 -23453 -23453:
/u02/app/aplccu29/ccu29appl/mso/11.5.0/bin/MSONWA64.exe
Program was terminated by signal 9


+---------------------------------------------------------------------------+
No completion options were requested.

+---------------------------------------------------------------------------+
APP-FND-01564: ORACLE error 1403 in afppct

Cause: afppct failed due to ORA-01403: no data found
ORA-06512: at "APPS.FND_CONC_STAT", line 62
ORA-06512: at "APPS.FND_CONC_STAT", line 113
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was: and was executed from the file &ERRFILE.
Concurrent request completed
Current system time is 08-DEC-2010 04:15:20


Something is killing the plan run but we don't know what.

Things we looked at:
-------------------------------
1. When the plan completed successfully on 05-DEC-2010 it showed the following memory usage in the log file:

Total Planning Time 89:46
Total memory usage: 7939098


2. We had them watch memory and it slammed up to the following before failing:

Pid Command Inuse Pin Pgsp Virtual
1048582 MSONWA64.exe 27245.30 30.0 21114.75 48413.42
Unit: MB


3. From aps diagnostics:

sga_max_size 12884901888
sga_target 10737418240


4. select name, display_value from v$parameter where name like 'sga%' or name like 'pga%';

NAME DISPLAY_VALUE
-------------------- ---------------
sga_max_size 12G
sga_target 10G
pga_aggregate_target 5G

5. sho sga

Total System Global Area 1.2827E+10 bytes
Fixed Size 2218768 bytes
Variable Size 5469373680 bytes
Database Buffers 7314866176 bytes
Redo Buffers 40910848 bytes

STEPS:
1. Unconstrained ASCP plan runs fine through 05-DEC-2010
2. Every time thereafter it fails with the Signal 9 error in the 64 bit MBP for AIX

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