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).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.