DATA Step, Macro, Functions and more

SAS FTP - error showing connection reset by peer

Reply
Occasional Contributor
Posts: 7

SAS FTP - error showing connection reset by peer

Hi All,

We are backtracking with a problem that we have had in past. When executing an FTP read of a file from a mainframe, FTP initiates from a Windows 7 PC and we are using SAS 9.4 TSM2 the FTP stops mid-stream. It will execute for varying amounts of time and then we get 'dropped'. It's like the handshake between SAS and the mainframe gets lost.

 

Sometimes the SAS FTP just 'stalls' and other times we actually get an error message that the connected was reset by peer.

 

Below is full error message (unforatunately the person running this neglected to save the log file) 

 

ERROR: The connection was reset by a peer..
FATAL: Unrecoverable I/O error detected in the execution of the DATA step program.
Aborted during the AUTO-LOADING STORED PROGRAM phase.
ERROR: The DATA step view has been abnormally terminated.

SAS Employee
Posts: 493

Re: SAS FTP - error showing connection reset by peer

Posted in reply to MaryPet123

@MaryPet123,

 

Please add debug option to your filename ftp and rerun your program. Debug option writes to the SAS log informational messages that are sent to and received from the FTP server.

 

FILENAME Statement, FTP Access Method

Super User
Posts: 9,611

Re: SAS FTP - error showing connection reset by peer

Posted in reply to MaryPet123

We had similar problems when reading mainframe files from UNIX with filename ftp. I added a logfile check to the sasbatch script:

grep -E "aborted|<<< 45|<<< 55|<<< 53|<<< 42"

that checks for certain mainframe-typical ftp messages that can appear in the SAS log. If that grep finds something, the job is repeated (with a counter so we won't get an endless loop).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 211 views
  • 0 likes
  • 3 in conversation