IO Error with SQL CE

[B Wiesner]

I've come across the following error when using SQL CE and
CF SP1.

An internal error occurred. Unable to successfully execute
disk IO on the file system.
25051

I've searched but haven't been able to find anything
useful about this. Has anyone had this problem? What
causes it... how to prevent it.. etc?

If it makes any difference I'm storing the database on a
SD card. I'm able to execute a few queries on the
database, until it chokes with that error. I'm even to
replicate without it failing. I'm thinking that it could
have a problem with an individual table, but there isn't
anything wrong with it that I can see.

Thanks
Brandon Wiesner

 

[Alex Feinman [MVP]]

That would not be a SanDisk SAD card?

 

[B Wiesner]

Brad,

I didn't think to check for any known issues with the SD
card (SanDisk 128). It turns out there are some problems
with SanDisk cards and the Dell Axim, which is the primary
device I'm using.
http://www.sandisk.com/tech/faq/216.html

I don't know at what point the problem is occurring, but
the first time it showed up is when I was trying to sync
via replication. I looked at one table in particular and
it was littered with rows containing null values in each
column in that row, including the primary unique field and
the s_generation, and s_rowLineage columns.

I deleted the database, and downloaded a new one. It was
fine for a few days, then it happened again. Allthough I
haven't been able to find the null rows this time.

 

[Tomer Verona [MS]]

Sounds like an issue with the media. SQL CE would get this error when
trying to read/write to the SD card. Have you looked into replacing the SD
card (as mentioned on the sandisk site) to see if it still repros?

-Tomer
Microsoft SQL Server CE Team