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:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
References |