topic Re: error message in sas DI studio while loading data using table loadder in SAS Enterprise Guide

error message in sas DI studio while loading data using table loadder

deleted_user — Tue, 10 Feb 2009 11:32:18 GMT

Hi,
I m tryin to update an oracle table with table loader in sas di studio but I m getting this error..

ERROR: Expecting page 2, got page -1 instead.
ERROR: Page validation error while writing WORK._tf0315.INDEX.
ERROR: File WORK._tf0315.INDEX is damaged. I/O processing did not complete.

Can someone help me

Re: error message in sas DI studio while loading data using table loadder

LinusH — Tue, 10 Feb 2009 14:56:12 GMT

Since this is a too small part of the LOG file, it's hard d to make any conclusions. Funny that DI Studio is writing to a index file in WORK in an Oracle load situation.
If you restart your session, does this still occur? Do you have enough disk space in relevant file systems? Maybe you should report this to SAS tech support.

/Linus

Re: error message in sas DI studio while loading data using table loadder

Cynthia_sas — Tue, 10 Feb 2009 16:05:17 GMT

Hi:
Searching support.sas.com on the string
"page validation error" resulted in more than these 5 hits:
http://support.sas.com/kb/7/816.html
http://support.sas.com/kb/00/832.html
http://support.sas.com/kb/2/591.html
http://support.sas.com/kb/2/670.html
http://support.sas.com/kb/3/171.html

None of these mention DI studio, many of them were noted in SAS 8 and many mention SAS/Connect and several of them refer to possibly corrupted files like SASUSER.PROFILE or an item store.

I suggest you work with Tech Support on this issue, or investigate the Tech Support notes on support.sas.com for more information and possible solutions.

cynthia