October 3, 2008 at 9:52 am
Issue with our FTP job(SQL2000 server):
We are executing http://FTP.bat file from the sql job as OS command in SQL2000, almost every other day we are seeing in the FTP output file as "connection closed by remote host", due to which the files are not getting FTP'ed from mas90 box(unix box) to SQL server. We are trying to see what might cause this to happen.
The below are the contents of the FTP output file:
C:\dir1\dir2 ftp -s:C:\commands.txt IPaddress
Connected to IPaddess
Connection closed by remote host
Per the above output file: we see connected to IP and then conn closed!!!
Our networking team is saying that communication between mas90 box and sql server exists, they do'nt see any other problem.
I am trying to find out if there are any other functions SQL is going at the time it attempts to connect for FTP. I checked the event log in the sql server, but can't find anything regarding that connection lost.
I do'nt know where to look at to find what's causing closing the connection.
In case if we have to check the mas90 unix box, what should we check for??
Please advice, as I really do'nt know what to do at this time.
Thanks!!
October 3, 2008 at 3:49 pm
Try scheduling job at some other time. Do one thing capture ping IP address results at the time when the ftp job executes so as to check whether there is any network packet drop which is causing issue.
MJ
October 5, 2008 at 6:08 am
MANU (10/3/2008)
Try scheduling job at some other time. Do one thing capture ping IP address results at the time when the ftp job executes so as to check whether there is any network packet drop which is causing issue.MJ
Do I need to specify ping IP address in the http://FTP.bat file? If so, how can I mention that in the http://FTP.bat file? Thanks for your reply.
October 5, 2008 at 6:16 am
MANU (10/3/2008)
Try scheduling job at some other time. Do one thing capture ping IP address results at the time when the ftp job executes so as to check whether there is any network packet drop which is causing issue.MJ
Per the FTP output file, it's connected and then only after that it loses connection. So even then do we need to specify Ping to verify if any network packet drop.
Can we add some kind of debug/trace commands in the http://FTP.bat file so that it will give us more details in the FTP output file instead of just Connection lost?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply