Memory Based Snapshot 64 Bit Aix Failed With App-Fnd-01564: Oracle Error 20100 In Main
Last updated on SEPTEMBER 25, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Nov-2013***
Users are running and ASCP plan. However it's failing in MSCNSPWA64 module: Memory Based Snapshot 64 bit AIX fails with:
Selecting Items 132,615 0:11
FILE NAME = /appsPROD39/applcsf/tmp/out/data4/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
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