Error when accessing table

[gnesshunkin]

Please help!  

I have several SAS tables that I'm unable to access.  I'm am receiving a message, "ERROR: Expecting page 6404, got page -1 instead. ERROR: Page validation error while reading...."

How do I fix or work around?

Thank you!

[ChrisBrooks]

This error usually occurs when the data set is damaged. Your best bet is to restore it from a known good backup or recreate it.

[Reeza]

Can you post an example with the code and log?

I sometimes get that message in SAS UE but it usually doesn't affect my data usage. 

Have you tried restarting SAS and resetting your library connections to see what happens?

---

@gnesshunkin wrote:

Please help!  

I have several SAS tables that I'm unable to access.  I'm am receiving a message, "ERROR: Expecting page 6404, got page -1 instead. ERROR: Page validation error while reading...."

How do I fix or work around?

Thank you!

---

[gnesshunkin]

Below is the code and error.  I've restarted the server but the error continues.  

The table is 1,969,163 records...only 800,353 are present when I run the code.

 data blah;

 set sas.return;

 run;

ERROR: Expecting page 6404, got page -1 instead.

ERROR: Page validation error while reading SAS.RETURN.DATA.

ERROR: File SAS.RETURN.DATA is damaged. I/O processing did not complete.

NOTE: The DATA step has been abnormally terminated.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 800353 observations read from the data set SAS.RETURN.

WARNING: The data set WORK.BLAH may be incomplete. When this step was stopped there were 800353 observations and 106 variables.

NOTE: DATA statement used (Total process time):

real time 0.59 seconds

cpu time 0.57 seconds

[Reeza]

If you're running a server, you should probably contact SAS Tech Support to help you debug this.

Any chance an update or backup process interrupted somehow damaging the tables?

---

@gnesshunkin wrote:

Below is the code and error.  I've restarted the server but the error continues.  

The table is 1,969,163 records...only 800,353 are present when I run the code.

 data blah;

 set sas.return;

 run;

ERROR: Expecting page 6404, got page -1 instead.

ERROR: Page validation error while reading SAS.RETURN.DATA.

ERROR: File SAS.RETURN.DATA is damaged. I/O processing did not complete.

NOTE: The DATA step has been abnormally terminated.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 800353 observations read from the data set SAS.RETURN.

WARNING: The data set WORK.BLAH may be incomplete. When this step was stopped there were 800353 observations and 106 variables.

NOTE: DATA statement used (Total process time):

real time 0.59 seconds

cpu time 0.57 seconds

---