Loader Worker Failed With Errors - MSCSLD : Error in main 103 : table_name_str AND APP-FND-01630: Cannot open file (Doc ID 2213636.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Memory based snapshot AND/OR Memory Based Planner can fail in Loader Worker With Direct Load Option
When the profile MRP: Use Direct Load - Yes

We saw the error first in the snapshot and fixed it for one table  and it's indexes
Then we saw the error again for other tables in Loader Workers spawned by the Memory Based Planner

The error can happen in more than one table.

ERROR
-----------------------
plan_id:0 plan_type:0 planning_engine_type:1
Creating dummy log file ...
Parent Program Name: MSCMON
This IS part of a Plan run.
MSCSLD : Error in main 103 : table_name_str MSC_ITEM_SOURCING 5021
Error string=
Statement with the error:
declare lv_temp_ind_nxtext number ; lv_deg_parallel number ; lv_index_

APP-FND-01630: Cannot open file /reports/incoming/devvcp/plsqllog/OFbBkx2H.t for reading
Cause: USDINS encountered an error when attempting to open file /reports/incoming/devvcp/plsqllog/OFbBkx2H.t for reading.
Action: Verify that the filename is correct and that the environment variables controlling that filename are correct.
Action: If the file is opened in read mode, check that the file exists. Check that you have privileges to read the file in the file directory. Contact your system administrator to obtain read privileges.
Action: If the file is opened in write or append mode, check that you have privileges to create and write files in the file directory. Contact your system administrator to obtain create and write privileges.

SO - we checked per other notes for:

1. The directory $APPLPTMP to insure that permissions were correct.
cd $APPLPTMP
pwd -- should be same directory reported in the log file - in this case /reports/incoming/devvcp/plsqllog
ls -ld
should report full permissions 777
drwxrwxrwx .... /reports/incoming/devvcp/plsqllog

and
2. File system had adequate space
df -k

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the ASCP plan

UPDATE 19-JUN-2017

Enhanced messaging seen in log file showed

Parent Program Name: MSONWL64
This IS part of a Plan run.
ORA-02158: invalid CREATE INDEX option
ORA-06512: at "SYSTEM.AD_DDL", MSCSLD : Error in main 103 : table_name_str MSC_SUPPLIES 6022
Error string=
Statement with the error:
declare lv_temp_ind_nxtext number ; lv_deg_parallel number ; lv_index_

APP-FND-01630: Cannot open file /fs1/inst/apps/<HOST><SID>/appltmp/OFsdwIe3.t for reading

Changes

Cause

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