Memory Based Snapshot Worker Erros With Status -117 Error And Shows BOM Loops In The Log File (Doc ID 1424684.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Information in this document applies to any platform.
Mscnswwa64 Memory Based Snapshot WorkerExecutable:MSCNSP - Memory-Based Snapshot


Symptoms

Users are on 12.1.3 and over the weekend applied 12.1.3.4 patching to PROD. However the first plan run fails with the following in MSCNSWWA64 module: Memory Based Snapshot Worker 64 bit AIX

.Loading workday calendar. Please wait . 0:01
Selecting BOD 196,589 1:05
Done msclis_load_item_sourcing Curr Memory :1342211 K Peak memory :1342211 K
Done msclis_load_sup_sourcing Curr Memory :1342352 K Peak memory :1342352 K
..Calculating Low Level Codes 138,099 0:04
..Calculating Low Level Codes 52,495 0:02
..Calculating Low Level Codes 25,918 0:01
..Calculating Low Level Codes 12,890 0:01
..Calculating Low Level Codes 7,513 0:01
..Calculating Low Level Codes 10,440 0:01
..Calculating Low Level Codes 14,559 0:01
..Calculating Low Level Codes 13,444 0:00
..Calculating Low Level Codes 8,078 0:01
..Calculating Low Level Codes 2,788 0:01
..Calculating Low Level Codes 10,486 0:00
..Calculating Low Level Codes 11,183 0:01
..Calculating Low Level Codes 5,550 0:01
..Calculating Low Level Codes 1,941 0:00
..Calculating Low Level Codes 1,350 0:00
..Calculating Low Level Codes 759 0:01
..Calculating Low Level Codes 1,152 0:00
..Calculating Low Level Codes 119 0:01
..Calculating Low Level Codes 91 0:00
..Calculating Low Level Codes 1 0:01
..Calculating Low Level Codes 0 0:00
..Calculating Deleting Nodes 2,075,22 0:00

===================================================
Loop has been detected and last link will be broken

PRD:F03:E8781A-ATO (361792 128 1021)
^
|
PRD:F03:E8781A-OC-GPIB (362312 128 1021)
^
|
PRD:F03:E8781A-E12 (945770 128 1021)
^
|
PRD:F03:E8781A-ATO-97744 (942135 128 1021)
^
|
PRD:F03:E8781A-ATO (361792 128 1021)
LOOP in BOM
/opt/oracle/apps/PPRD/apps/apps_st/appl/msc/12.0.0/bin/MSCNPA64.sh[3]: 724780 Memory fault(coredump)
/opt/oracle/apps/PPRD/apps/apps_st/appl/msc/12.0.0/bin/MSCNPA64.sh
Program exited with status -117


In discussing with the customer, TEST has this same patch and it shows the bom loop but it doesn't fail in Test. Also important is the fact the log file failed in about 18 minutes.


STEPS:
1. Apply 12.1.3.4 to Test - plan runs fine even with the bom loop and is successful
2. Apply 12.1.3.4 patch to PROD and the ASCP plan fails

Changes

Upgraded from 12.1.2 to 12.1.3.4 patching for VCP/ASCP

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