Nebu Jacob


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




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

ErikEJ


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.







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

Nebu Jacob

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






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

ErikEJ

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.






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

Nebu Jacob

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





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

ErikEJ

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.






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

Nebu Jacob

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

because of the no of transactions

Thanks

Nebu