An internal error occurred. [ ID = 3639 ] on delete query

Hi,

When I am trying to execute a delete query i'm getting the following error An internal error occurred. [ ID = 3639 ]. This is happening for some specific rows only. Other rows are getting deleted without any issues. Some 7 rows are there which i'm not able to delete. I am able to run update query on that rows. but not delete query

Pls help

Thanks

Nebu

This error does not look like a SQL CE error. Are you using SQL CE or SQL Server ?

Also, could you show us the statement and describe your environment, then others may be able to help you.

|||I'm using SQL CE.

delete from tabl1 where ID=1

We are using SLQ ce as a databse for a windows application. We use C# . Some times there will be insert and delete statements of more than 10000. I executed this statement for more than 10000 records, in that apart from 7 records every thing else got deleted. I'm not able to delete it even from SQL server management studio expresss.

tahnks

Nebu

|||Sounds like your sdf file has become corrupted. Try to run a Compact/Repair on the db. You can also try to send the sdf file to me, and I will have a look at it with SSMS.

|||

Hi Erik,

Thanks for the reply. I will not able to send you the sdf bcos of confidentiality. Can you please tell me how to run a reapir?

Thanks

Nebu

|||

Repair can be done from SSMS(E), right click the database, select Properties and the Shrink/Repair tab.

Also, the SqlCeEngine object has a Repair method.

|||Thanks Eirk.. It worked.. Do you have any idea why did it happen? Is it

because of the no of transactions?

Thanks

Nebu