Page 1 of 1

SFTP issues

Posted: Fri Mar 01, 2013 2:17 am
by Aquitaine
We are using the FTP Enterprise transform to write files directly from Datastage to a remote server, however we occasionally get a failure of the job with the following sort of error:

ftp msg: File "/tmp/pftpData0.31592." not found.

If the job is re-run, it works fine and may continue working for a number of days before falling over again with the same issue (different temp file name)

Has anyone come across this issue?
Cheers
Mark

Posted: Fri Mar 01, 2013 7:38 am
by chulett
As a guess, I'd think your /tmp space is filling up. Is it being monitored?

Posted: Fri Mar 01, 2013 6:15 pm
by PaulVL
are you running in a GRID environment where you are being dispatched to various servers at runtime?

Posted: Mon Mar 11, 2013 8:33 am
by Aquitaine
I am in the process of gathering usage stats for the /tmp disc space so will let you know if this is the issue.

PaulVL - We are not running a GRID environment.

Thanks
Mark

Posted: Mon Mar 11, 2013 6:39 pm
by PaulVL
What is your TMPDIR environment variable set to?

Posted: Wed Mar 13, 2013 8:35 am
by Aquitaine
Well from the monitoring I have available to me, it looks like we are only using 11% of the avilable space in /tmp

PaulVL - The TMPDIR environment variable is not set so uses the default /tmp

Does anyone have any ideas why we are getting this failure?
ftp msg: File "/tmp/pftpData0.31592." not found :?

Cheers

Mark

Posted: Wed Mar 13, 2013 10:22 am
by FranklinE
Judging from your initial post, I am guessing you have a runtime problem, not an environment problem. I suggest you expand your examination to other processes that are running at the time of the failure, and compare that to the processes that are running (or not running) when the process completes successfully.

Edit: I forgot to add that a "not found" can sometimes be a resource contention error, hence my guess.