Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slightly OT: Capturing a failed status of an ftp process
Isn't it possible to check size of the source and remote file(s) after ftp. If they are the same - it is a high probability that transfer was OK.
Alex Hillman
-----Original Message----- From: Shari Dishop [SMTP:DISHOP_at_bullet.md.essd.northgrum.com] Sent: Tuesday, April 03, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Subject: RE: Slightly OT: Capturing a failed status of anftp process
Terry, I worked on what I think is a similar process. We are running SAP and need to be able to ftp files on and off of our unix SAP servers. Someone in the past wrote an SAP ABAP program that does all of the set up then calls a unix shell script to perform the ftp. If the ftp command truely failed to connect we had no problem getting back a failed error message to the SAP program. But where we ran into some problems was when the transfer command would start but get interrupted for some unknown reason and never fully complete the transfer. This was noticed by accident one day when someone was checking a report run off of one of the data transfers and there were only a few hundred records in the table to be processed instead of a few hundred thousand. I was then asked to come up with a solution that would look for an unexpected termination of the ftp connection. After lots of searching and getting one of our local unix gurus involved (I have worked directly on a unix platform), we implemented the following. It is not the best but it does seem tobe working.
We added a step to the ftp script. This step is a status command that is
executed directly after the get or put command. This returns information about
the ftp connection itself. It also returns a message if it is no longer
connected. This output was passed back to the SAP program and parsed. If I had
a message indicating that the remote host was still connected, I assumed that
the get or put executed completely. If on the other hand I received the message
indicating that the remote system was no longer connected I generated an error
message from the program so that the user could check the data.
Shari Dishop SAP ABAP - Project Systems Team Logicon - A Northrop Grumman Company Baltimore, MD RE: I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let meknow.
TIA, Terry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terry Ball INET: terry_ball_at_csgsystems.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shari Dishop INET: DISHOP_at_bullet.md.essd.northgrum.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: Alex.Hillman_at_usmint.treas.gov Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Apr 03 2001 - 15:07:26 CDT
![]() |
![]() |