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