Deadlock Issue
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-06-20 07:24 AM
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
------------------------------
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
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-06-20 12:22 PM
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
------------------------------
------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
