topic Re: ERROR:Expecting pg.., got pg-1 instead. 2:Pg valid'n error while reading ..3:file is damage...I/ in SAS Programming

ERROR:Expecting pg.., got pg-1 instead. 2:Pg valid'n error while reading ..3:file is damage...I/O pr

mohassan99 — Fri, 13 Jul 2018 00:48:03 GMT

The error I am getting:

Error:

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

ERROR: Page validation error while reading BKPREV.RX_DETAIL.DATA.

ERROR: File BKPREV.RX_DETAIL.DATA is damaged. I/O processing did not complete.

I don't think the file is damaged.

Proc contents worked on the datasets.
Procedures were able to pull some variables, but not others.
I don't think I got this error when I created the file then compared it to the previous month.

Now I am tying to compare this month's output to the previous months and its telling me the previous months file is corrupted?

I found this at support.sas.com: http://support.sas.com/kb/32/419.html
This seems to apply to Z/OS, right? (Had bad ratings anyway and provided broken links.)

My file is on a Windows OS Server.

Could I be receiving this error because the file is 40GB?

Not sure I understand the code and it's probably IP, technically. So I cant do that.

Please feel free to let me know what information I can provide you to help you help me.

The data is confidential, HIPAA, protected and the code is IP so I'm not sure I can provide "code and example data". I'm not sure if it would help. If so I might be able to de-identify a couple lines or provide the proc contents results, etc.

I'm using SAS EG 7.15

Re: ERROR:Expecting pg.., got pg-1 instead. 2:Pg valid'n error while reading ..3:file is damage...I/

Shmuel — Fri, 13 Jul 2018 00:54:59 GMT

As much as I remember the error

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

means that you are trying to read after getting end of file.

Can you post your code ?

Re: ERROR:Expecting pg.., got pg-1 instead. 2:Pg valid'n error while reading ..3:file is damage...I/

Reeza — Fri, 13 Jul 2018 01:20:09 GMT

If you can't share any further information, your best bet is to contact SAS tech support.

Re: ERROR:Expecting pg.., got pg-1 instead. 2:Pg valid'n error while reading ..3:file is damage...I/

Kurt_Bremser — Fri, 13 Jul 2018 06:02:39 GMT

The dataset is damaged.

proc contents works because it only reads the header.

Rerun the process that creates the dataset, and study the log from that. If the problem appears a second time, and the log does not give you a clue (like a "file is full and damaged" while you create the dataset), contact SAS technical support. They operate under strict confidentiality rules.

A thorough look at the Windows system log could reveal a storage problem (eg an incompletely written mirror in a RAID1)