Error occurred while loading tag information, Transaction (Process ID 95) was deadlocked on lock resources

Ignition
,
1

Hi ,
I got below errors in my logs, keeps updating. There are Id and Process ID , from this two IDs, how I can find out which tag is locked and by whom.

Can anyone give some guidance , thanks.

image
image1444×746 61.8 KB

com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)

2

You should investigate this from the database side. Most likely, there are two different stored procedures making table or other locks, and they are not following the same order of locks. This presents opportunities for "AB-BA" deadlocks.

You will need to look at SQL Server's own logs to identify the sources.