DevForce Community Forum : Concurrency error...but no concurrency http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Concurrency error...but no concurrency Sun, 28 Jun 2026 01:38:34 -700 Thu, 16 Dec 2010 06:11:49 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2378 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Concurrency error...but no concurrency : Thank you for the help. http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9420#9420 Author: midnit
Subject: 2378
Posted: 16-Dec-2010 at 6:11am

Thank you for the help.]]> Thu, 16 Dec 2010 06:11:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9420#9420 Concurrency error...but no concurrency : DevForce is a passive bystander... http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9413#9413 Author: kimj
Subject: 2378
Posted: 15-Dec-2010 at 12:22pm

DevForce is a passive bystander with this exception, it's EF, the DB and your provider at play here.  I did a quick google but couldn't find anything helpful.  It might be worth posting a question to the EF forum (http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/threads).

]]> Wed, 15 Dec 2010 12:22:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9413#9413 Concurrency error...but no concurrency : Well I stumbled upon it as you... http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9410#9410 Author: midnit
Subject: 2378
Posted: 15-Dec-2010 at 9:39am

Well I stumbled upon it as you posted. It was related to a trigger, an after insert trigger causes a legitimate error but that error is not coming back - its throwing the concurrency error.
 
Is there any way to get the actual error? Typically I do get the trigger error so I did not expect that the trigger was bombing.
]]> Wed, 15 Dec 2010 09:39:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9410#9410 Concurrency error...but no concurrency : If you're using a stored... http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9409#9409 Author: kimj
Subject: 2378
Posted: 15-Dec-2010 at 9:23am

If you're using a stored procedure for the insert or have an insert trigger that would be the first place to look.  Otherwise, I would use a profiler to see what these insert statements (even when they succeed) really look like.  If you don't have a profiler, it looks like EF Profiler will work with DevForce and they have a free trial download.
 
For example, here's an insert to the Customer table in Adventure Works:
 
exec sp_executesql N'insert [dbo].[Customer]([SalesPersonID], [TerritoryID], [CustomerType], [ModifiedDate], [rowguid])
values (null, null, @0, @1, @2)
select [CustomerID], [AccountNumber]
from [dbo].[Customer]
where @@ROWCOUNT > 0 and [CustomerID] = scope_identity()',N'@0 nchar(1),@1 datetime2(7),@2 uniqueidentifier',@0=N'S',@1='2010-12-15 00:00:00',@2='B970B5E3-DB0D-4B92-B3BA-074286704675'
 
Probably not what you'd expect, and because of the select for the store generated value you can see how an error could potentially occur.
]]> Wed, 15 Dec 2010 09:23:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9409#9409 Concurrency error...but no concurrency : I have a very simple entity with... http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9408#9408 Author: midnit
Subject: 2378
Posted: 15-Dec-2010 at 8:39am

I have a very simple entity with 4 properties, 1 key, no concurrency settings on any of the properties, the key is storegenerated.
 
While on the server I create a new entity (the one above), sets its values, save. 98% of the time (random high percentage used) it works - but sometimes it errors with "Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries." and the EntityWithErrors is the entity I just created. The entitymanager has NO other data in it - just my 1 entity and again, I have no concurrency set for this entity. This entity also has no relationships to any other entities.
 
This seems random...but once this occurs any time I try to create a record for the same data...I keep getting the error. I can restart my computer and creating that one record will still error so at least THAT much is consistent.
 
I am still working on this but could use some help.
]]> Wed, 15 Dec 2010 08:39:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2378&PID=9408#9408