BookmarkSubscribeRSS Feed
MaryPet123
Calcite | Level 5

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.

2 REPLIES 2
alexal
SAS Employee

@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

Kurt_Bremser
Super User

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).

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2035 views
  • 0 likes
  • 3 in conversation