File Access issue

satheesh_color · Post by **satheesh_color** » Tue Aug 11, 2009 2:20 am

Hi,

Today we have a strange problem while accessing a file. We have Ftp'ed a file from 3rd party system and place it into inbox folder.The we have a job to move the corresponding file into staging folder and backup the file into archive folder for future reference.

Once the Ftp job gets completed,the job tries to access the file in inbox folder to move it into staging, but failed due to the following error:

Will wait until 21:04:13 for file '/dstage/appl/inbox/Misc/rew.Flat_Fee_LocationExclusionList.csv' to be present

Timed out after 00:00:05 while checking file '/dstage/appl/inbox/Misc/rew.Flat_Fee_LocationExclusionList.csv'

When we try to check/access the file manually we too get the access error:

/dstage/appl/inbox/Misc/more rew.Flat_Fee_LocationExclusionList.csv
rew.Flat_Fee_LocationExclusionList.csv: No such file or directory

/dstage/appl/inbox/Misc>cat rew.Flat_Fee_LocationExclusionList.csv
cat: Cannot open rew.Flat_Fee_LocationExclusionList.csv: No such file or directory

Please let me know your thoughts on this.

Thanks,
Satheesh

ArndW · Post by **ArndW** » Tue Aug 11, 2009 3:30 am

Everything you posted indicates that the file does not exist. How do you know that it does exist in that location?

satheesh_color · Post by **satheesh_color** » Tue Aug 11, 2009 4:09 am

Hi ArndW,

/dstage/appl/inbox/Misc>ll
total 4
-rw-rw-r-- 1 srajan02 dstage 56 Aug 10 20:58 rew.Flat_Fee_CDC_Codes.csv
-rw-rw-r-- 1 srajan02 dstage 12 Aug 10 21:04 rew.Flat_Fee_LocationExclusionList.csv

/dstage/appl/inbox/Misc>ls -ltr
total 4
-rw-rw-r-- 1 srajan02 dstage 56 Aug 10 20:58 rew.Flat_Fee_CDC_Codes.csv
-rw-rw-r-- 1 srajan02 dstage 12 Aug 10 21:04 rew.Flat_Fee_LocationExclusionList.csv

Thanks,
Sathesh

ShaneMuir · Post by **ShaneMuir** » Tue Aug 11, 2009 4:14 am

I assume the user that you are accessing the system with has the correct user permissions for that file and directory?

satheesh_color · Post by **satheesh_color** » Tue Aug 11, 2009 4:30 am

Yes, I belongs to dstage user. No permission issue. we could see the file is present physically.

/dstage/appl/inbox/Misc>ll
total 4
-rw-rw-r-- 1 srajan02 dstage 56 Aug 10 20:58 rew.Flat_Fee_CDC_Codes.csv
-rw-rw-r-- 1 srajan02 dstage 12 Aug 10 21:04 rew.Flat_Fee_LocationExclusionList.csv

But we we try to access

/dstage/appl/inbox/Misc/more rew.Flat_Fee_LocationExclusionList.csv
rew.Flat_Fee_LocationExclusionList.csv: No such file or directory

/dstage/appl/inbox/Misc>cat rew.Flat_Fee_LocationExclusionList.csv
cat: Cannot open rew.Flat_Fee_LocationExclusionList.csv: No such file or directory.

Thanks,
Satheesh

chulett · Post by **chulett** » Tue Aug 11, 2009 5:24 am

There could be some stray characters at the end you cannot see. What happens if you try:

/dstage/appl/inbox/Misc> cat rew.Flat_Fee_LocationExclusionList.csv*

satheesh_color · Post by **satheesh_color** » Tue Aug 11, 2009 7:42 am

Hi Chulett,

Exactly, Thanks for the heads-up.

dstage/appl/inbox/Misc>more rew.Flat_Fee_LocationExclusionList.csv*
17426
21814

Can you suggest me on how to access these files.

Thanks,
satheesh

chulett · Post by **chulett** » Tue Aug 11, 2009 7:49 am

You need to figure out what added the spaces(?) to the end of the filename and fix it. Before that, you'll need to use a wildcard.

satheesh_color · Post by **satheesh_color** » Tue Aug 11, 2009 7:51 am

Great Thanks. Chulett.

Satheesh.

chulett · Post by **chulett** » Tue Aug 11, 2009 8:04 am

So, first place to check would be your "3rd party system" and see if they are the guilty party. If not, then suspect your ftp script / process.

satheesh_color · Post by **satheesh_color** » Thu Aug 13, 2009 1:18 am

Hi Chulett,

I have identified the issue with the FTP job.we have an DS FTP job.The filename parameter in the job sequences had a space at the end of the file name. probably a cut and paste error. I removed the space and it works fine.

Once again thanks for your suggestions.

Regards,
Satheesh