Internal error on DeleteEntitiesDirectly

Posts   
 
    
nalwi
User
Posts: 10
Joined: 01-Oct-2008
# Posted on: 14-Sep-2009 07:35:55   

We get the following error when calling DeleteEntitiesDirectly against SQL CE 3.5 desktop database.This is error can be repeated everytime. Any ideas?

Cheers!

Type : System.Exception, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of an action query: An internal error occurred. [ ID = 3649 ]. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. ---> An internal error occurred. [ ID = 3649 ] --- End of inner exception stack trace --- at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteActionQuery(IActionQuery queryToExecute) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.DeleteEntitiesDirectly(String entityName, IRelationPredicateBucket filterBucket) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.DeleteEntitiesDirectly (Type typeOfEntity, IRelationPredicateBucket filterBucket)

Runtime version: LLBLPro version 2.6.0.0 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll (2.6.08.1114) SD.LLBLGen.Pro.LinqSupportClasses.NET35.dll (2.6.08.1114) SD.LLBLGen.Pro.DQE.SqlServer.NET20.dll (2.6.08.1114)

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 14-Sep-2009 11:39:41   

This looks like a database internal error, perhaps due to bad query.

SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll (2.6.08.1114)

That's an old build, first thing to do is to upgrade to the latest runtimes.

In the application config file, did you set the DQE compatability mode for SQL CE?

To troubleshoot this please capture the generated SQL query. (Check the Troubleshooting section of the manual). And try to run it manually in sqlserver management studio as well to see if the query is wrong or that it's the CE Database.

And post the query here along with your test results.