Desktop productivity for business analysts and programmers

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

Reply
N/A
Posts: 0

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

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
Esteemed Advisor
Posts: 5,198

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

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
Data never sleeps
SAS Super FREQ
Posts: 8,720

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

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
Ask a Question
Discussion stats
  • 2 replies
  • 124 views
  • 0 likes
  • 3 in conversation