topic How to fix the error: I/O processing did not complete in SAS Programming

How to fix the error: I/O processing did not complete

qc1 — Wed, 05 Apr 2023 21:56:41 GMT

I run a program to create tables. But I got errors like this:
“Error: Expecting page 43290, got page -1 instead.
Error: Page validation error while reading libname.tablename.DATA.
Error: File libname.tablename.DATA is damaged. I/O processing did not complete.
Note: compressed is 43289 pages; “

I used below code to repair the table:
Proc datasets lib=libname;
Repair tablename / encryptkey=secret;
Run;
Quit;

No errors for Proc dataset step and it seems like worked. But that table still cannot be query.

What code I should use to fix it? Please provide an example.

Please help! You will be gratefully appreciated!

Re: How to fix the error: I/O processing did not complete

SASKiwi — Wed, 05 Apr 2023 22:37:03 GMT

This is usually an indication you have either run out of disk space or that there are hardware problems with your storage. What type of SAS installation are you running on. A PC, a remote SAS server, or on a cloud-based platform?

Re: How to fix the error: I/O processing did not complete

qc1 — Wed, 05 Apr 2023 22:40:31 GMT

I run it on a remote SAS server, using SASEG7.15

Re: How to fix the error: I/O processing did not complete

SASKiwi — Wed, 05 Apr 2023 23:05:27 GMT

In that case I suggest you talk to your SAS administrator or IT help desk about fixing this. If appropriate a restore from the last good backup might be the way to go.

Re: How to fix the error: I/O processing did not complete

Kurt_Bremser — Thu, 06 Apr 2023 05:31:56 GMT

This usually happens when SAS ran out of disk space while creating the dataset. Rerun the process which created the dataset in the first place.