Deadlock errors in EA cloud

[JayHollingsworth]

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?

[qwerty]

Not really. Try running a consistency check.

q.