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.
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.
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).
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.