topic RE: BP Generate locks in Database in Product Forum

BP Generate locks in Database

EmersonF — Tue, 19 Sep 2023 13:09:00 GMT

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

RE: BP Generate locks in Database

steven.boggs — Tue, 19 Sep 2023 13:57:00 GMT

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

RE: BP Generate locks in Database

EmersonF — Tue, 19 Sep 2023 14:23:00 GMT

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