Hi all,
I have a very simple parallel job thats pulling 18 records from SQL Server and putting them in a table on another server/database (IQ 12.7). This is something i've done 100's of times up to this point without any problems but for this job i'm getting an "ASA Error -1006133: File does not exist. File: /home/dsadm/db5_RemitPaid.dat " error.
I'm confused by this as the datastage generated .sql file that runs this to get the error is sitting in the same directory as the .dat file it can't find. I've verified the filename of the table is correct and no funky characters are being used. I've also moved the location of where these 2 files (.sql & .dat) are being stored but still get the same message.
Any thoughts?
thanks,
Jim
"file does not exist" error yet it does exist..
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 21
- Joined: Thu Jul 10, 2008 8:12 am
- Location: amherst, NY
Possibilities:
The file being looked for has a permissions problem for the user id of the job looking for it. Check your permissions mask for the folder.
At the runtime point the job is looking for the file, it has not yet been created. I've noticed that DS's parallel processing doesn't always keep steps in the right order.
The file being looked for has a permissions problem for the user id of the job looking for it. Check your permissions mask for the folder.
At the runtime point the job is looking for the file, it has not yet been created. I've noticed that DS's parallel processing doesn't always keep steps in the right order.
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Premium Member
- Posts: 21
- Joined: Thu Jul 10, 2008 8:12 am
- Location: amherst, NY
-
- Premium Member
- Posts: 21
- Joined: Thu Jul 10, 2008 8:12 am
- Location: amherst, NY
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Premium Member
- Posts: 21
- Joined: Thu Jul 10, 2008 8:12 am
- Location: amherst, NY