Commit Error

Hi there,
We have this error when assigned a WO from one workbasket to another.
(Save failed-Commit Error: Problem writing an instance to the database: code:1205 SQLState: 40001......was deadlocked on lock resources with another process.....). It is because have 2 person work on the same WO and process it? is that possible?
This issue doesn't happen before.

Please advice. Thank you.


**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

September 19, 2014 - 10:35am

We are seeing the same issue on production env. What could be the issue with this? Please provide suggestions to resolve this issue. 

October 7, 2014 - 5:33am

How the functionality is being coded needs to be looked in to.

Is it something like below:


You have two assignments in the flow, where the first assignment and second assignment are having ToWorkbasket method being selected in route tab configured to its respective WB. At runtime, it is not moving from the first one to second one?

Is this a case instance with a parent case?

Did tracer was useful?

How many process flows the case is running at a given time? I mean any spin-offs?