Memory Based Snapshot 64 Bit Aix Failed With App-Fnd-01564: Oracle Error 20100 In Main
(Doc ID 1414119.1)
Last updated on SEPTEMBER 27, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Users are running and ASCP plan. However it's failing in MSCNSPWA64 module: Memory Based Snapshot 64 bit AIX fails with:
Error
====
.Loading workday calendar. Please wait . 0:00
Selecting Items 132,615 0:11
before mrflit_flush_items
FILE NAME = /<dir>/mbpoutput/MSLD_ITEMS.datFlushed all buffers into MRP_SYSTEM_ITEMS 132,615 0:05
CONCURRENT MSC MSCMON "PLAN_ID=4" "REQUEST_ID=624429" "IN_PIPE=mon_ORA$PIPE$04FF042F0001" "OUT_PIPE=snp_ORA$PIPE$04FF042F0001" "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
Launched concurrent request 624430 for workers
items load complete
APP-FND-01564: ORACLE error 20100 in main
Cause: main failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o0260310.tmp in the directory, /tmp. <<< key information - cannot write the temp file to the directory - ran out of disc space allocation in /tmp directory <<<
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 526
ORA-06512: at "APPS.MSC_SNAP.
The SQL statement being executed at the time of the error was: begin msc_snapshot_pk . update_items_info ( :err_mesg:err_mesg_ind , : and was executed from the file /data1/R121_64bit_wkrAuto/msc/src/mscnsp.pc.
APP-MRP-22075: An internal error has occurred (main, 1, , )
Selecting Items 132,615 0:11
before mrflit_flush_items
FILE NAME = /<dir>/mbpoutput/MSLD_ITEMS.datFlushed all buffers into MRP_SYSTEM_ITEMS 132,615 0:05
CONCURRENT MSC MSCMON "PLAN_ID=4" "REQUEST_ID=624429" "IN_PIPE=mon_ORA$PIPE$04FF042F0001" "OUT_PIPE=snp_ORA$PIPE$04FF042F0001" "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
Launched concurrent request 624430 for workers
items load complete
APP-FND-01564: ORACLE error 20100 in main
Cause: main failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o0260310.tmp in the directory, /tmp. <<< key information - cannot write the temp file to the directory - ran out of disc space allocation in /tmp directory <<<
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 526
ORA-06512: at "APPS.MSC_SNAP.
The SQL statement being executed at the time of the error was: begin msc_snapshot_pk . update_items_info ( :err_mesg:err_mesg_ind , : and was executed from the file /data1/R121_64bit_wkrAuto/msc/src/mscnsp.pc.
APP-MRP-22075: An internal error has occurred (main, 1, , )
Steps to Reproduce
=============
1. Run ASCP Plan
2. Plan fails with multiple errors during snapshot concurrent request
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |