BP Generate locks in Database

[EmersonF]

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

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

[SteveBoggs]

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
------------------------------

[EmersonF]

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!
------------------------------