Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: JayHollingsworth on January 12, 2016, 08:43:56 am

Title: Deadlock errors in EA cloud
Post by: JayHollingsworth on January 12, 2016, 08:43:56 am
Has anyone else experienced this? When I use the Reusable Asset Service in the EA cloud (on MS SQl Server) I get the following kind of message:


Cloud Services: Query in batch execute failed with message: FAIL: Microsoft OLE DB Provider for SQL Server [-2147467259]

Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.   


Sometime I get three or four, sometimes many. Almost never none.

This message leads me to believe that the copy of my database which I just created from RAS is corrupted. I don't have a good way to inspect it to see which records failed to be inserted because of the error. Everything looks OK if I use a baseline compare but I'm afraid that just isn't picking up whatever is missing.


Does anyone have any ideas?
Title: Re: Deadlock errors in EA cloud
Post by: qwerty on January 12, 2016, 09:36:10 am
Not really. Try running a consistency check.

q.