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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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