topic Deadlock Issue in Product Forum

Deadlock Issue

Yeswa_Vaibhav_1 — Thu, 25 Jun 2020 06:24:00 GMT

Hi All,

I am running my BOT suddenly after completing few records, BOT is terminating by showing the below error as reason: "Transaction (Process ID 335) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction"
Process ID changes time to time, but issue is same and process is running on one VM only. No parallel process is happening. Can any one tell me it is occurring and how to handle this.

Regards

------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------

RE: Deadlock Issue

John__Carter — Thu, 25 Jun 2020 11:22:00 GMT

I suspect the database is being overwhelmed with queries from processes, and maybe the queries are 'expensive' and making the DB work hard. Check the design of your processes to see if the frequency of hits being made could be a factor. Using things like Tag Filter in Get Next Item is a potential drag, particularly if the number of queue items and tags is high. Also check the health of the DB, table sixes etc - if you contact the support team they can advise on remedial action.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------