topic Re: Error when accessing table in SAS Studio

Error when accessing table

gnesshunkin — Tue, 04 Sep 2018 21:33:24 GMT

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!

Re: Error when accessing table

ChrisBrooks — Tue, 04 Sep 2018 21:39:46 GMT

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.

Re: Error when accessing table

Reeza — Tue, 04 Sep 2018 21:40:08 GMT

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!

Re: Error when accessing table

gnesshunkin — Tue, 04 Sep 2018 21:49:47 GMT

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

Re: Error when accessing table

Reeza — Tue, 04 Sep 2018 21:57:13 GMT

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