I am facing an issue in update item status operator which get failed with below error message:
Exception occurred in updateRequestItemStatus: Exception=com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 239) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Message=Transaction (Process ID 239) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Any one has come across this issue??
This has happened to me on several occasions and more often than not its triggered by having the ticket open in service desk and then interacting with it in Process Automation. I've also done this to myself during testing. Typically I'll be testing a workflow and not watch what operators have been closed or exited completely. If those operators did anything with a Object in service desk it will hold the connection to the database/object record open (even if it's hung or blocked). Then when you run another process or test against the same process, it'll run into the locked record and you get this error. Check to make sure processes that have interacted with the record are fully shut down and try it again. They can be found under your operations tab.
Hopefully this is of some help to you.