File not found; "Unable to open file"
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description:
You get messages like these in running p_manage_01 or another batch job which uses work files:
I/O error : file ... File not found
SQL*Loader-500: Unable to open file
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
where the file it's looking for is a work file.
Resolution:
The cause is in the step which failed to create the work file which it is trying to open. Look in the preceding sections of the log for sort errors or other errors which could have caused the file for this particular cycle to not be created.
- Article last edited: 12-Mar-2016