cancel
Showing results for 
Search instead for 
Did you mean: 

BP Generate locks in Database

EmersonF
MVP

Hello Everyone, I hope that you're well.

So, I receved of my infrainstructure one warning that my Blue Prism is generate locks in my database, I never saw this case.
 

My BP Version: 6.10

The Query that is creating the lock in DB : update BPAAliveResources with (serializable) set userid = @UserID, lastupdated = getutcdate() where MachineName = @MachineName and userid = @User

25654.png



------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------
Sr Cons at Avanade Brazil
2 REPLIES 2

steven.boggs
Staff
Staff

Hi Emerson,

A few questions to help narrow down the issue -- Are you using Data Gateways in this environment? What is the v6.10.x version you're using? Have you reviewed the guidance in our Knowledge Base article about SQL deadlocks and gone through the investigation steps with your DBA team as a first step?



------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

Hello Steve, I don't use Data Gateway,
The exactly version is 6.10.2, 

I will to repass this article to my team, thanks 



------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------
Sr Cons at Avanade Brazil