topic Error trying to update a VSAM file in SAS Programming

Error trying to update a VSAM file

Guiluiz — Thu, 06 Apr 2023 12:49:06 GMT

Hello folks,

I am trying to update a VSAM file, however I am getting the error below:

ERROR: Record not found, or the RBA is not found in the buffer pool.
ERROR: VSAM (GET) logical I/O error occurred on fileref DIREICL, rc = 8 (decimal), feedback code = 16 (decimal).
ERROR: Undetermined I/O failure.
FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase.

Can anyone help me? I think this error is related to the VSAM file key (KSDS), but I am not sure. Is there any way for me to check the position of the columns in the VSAM file?

Thanks everyone!

Re: Error trying to update a VSAM file

SASKiwi — Thu, 06 Apr 2023 21:28:07 GMT

I'd suggest opening a Tech Support track for this. AFAIK, there are very few mainframe SAS users active in the Community and its so many years since I last had anything to do with VSAM files.

You should post your complete SAS log of the step producing these errors though. Without your source code we have no idea how to help.

Re: Error trying to update a VSAM file

Guiluiz — Fri, 07 Apr 2023 20:13:34 GMT

Thanks for trying to help, I am attaching part of the log.

Re: Error trying to update a VSAM file

Tom — Fri, 07 Apr 2023 23:28:18 GMT

No need to attach a file to share text. Just click the Insert Code button and paste the text.

 
  
 59          DATA _NULL_;
 60         
 61           SET UNION;
 62         
 63           VEVSCLA = NOR;
 64         
 65           INFILE VSAMDS VSAM  FDBK=CODER  KEY=VEVSCLA;
 66         
 67           IF CODER > 4
 68           THEN DO;
 69                _ERROR_ = 0;
 70                ABORT RETURN 1420;
 71                STOP;
 72           END;
 73         
 74           INPUT;      
 75         
 76           FILE VSAMDS;
 77           PUT  @001    _INFILE_
 78                @&PCC   TCOD 1.;
 79         
 80          RUN;
  
14                                                          The SAS System                             15:47 Wednesday, April 5, 2023
  
 NOTE: The file/infile DIREICL is:
       Dsname=DXA.SALIDA.REPRO.KSDS,
       Volume=XF5078,Disp=SHR,Unit=3390,Type=INDEXED,
       Spanned=NO,Recordsize=(.,225),Amp=('AMORG'),
       Records=28427,Keys=(11 0)
  
 ERROR:  Record not found, or the RBA is not found in the buffer pool.
 ERROR: VSAM (GET) logical I/O error occurred on fileref DIREICL, rc = 8 (decimal), feedback code = 16 (decimal).
 ERROR: Undetermined I/O failure.
 FATAL: Unrecoverable I/O error detected in the execution of the DATA step program.  Aborted during the EXECUTION phase.
 NOTE: 0 records were read from the infile DIREICL.
 NOTE: 0 records were written to the file DIREICL.
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: There were 1 observations read from the data set WORK.UNION.
 NOTE: The DATA statement used 0.02 CPU seconds and 17084K.
  
 NOTE: The address space has used a maximum of 624K below the line and 19416K above the line.
  
  
 ERROR: Errors printed on page 4.
  
 NOTE: The SAS session used 0.27 CPU seconds and 18748K.
  
 NOTE: The address space has used a maximum of 624K below the line and 19416K above the line.
  
 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414

Re: Error trying to update a VSAM file

SASKiwi — Mon, 10 Apr 2023 23:13:18 GMT

Can you successfully read this VSAM file? SImplify your program just to read the file and see if that works.