Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim - RES.WorkspaceManager.DataAccess.UserDataAccess.TryUpdateUser

Version 1

    Problem

    The following error can be found in the Windows Application Event Log of the RES Workspace Manager Relay Server:

    Source: RES Workspace Manager Relay Server
    Event ID: 0
    Task Category:  None
    Level: Error
    User: N/A
    Computer: FQDN_of_Relay_Server
    Description:
    The description for Event ID 0 from source RES Workspace Manager Relay Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    Error: Transaction (Process ID 168) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    Version: 9.9.1.3 (2014 SR1) CS:194827

    StackTrace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
       at System.Data.SqlClient.SqlDataReader.Read()
       at RES.WorkspaceManager.DataAccess.UserDataAccess.TryUpdateUser(IDbClient dbClient, HistoryEntity entity, ReplicaGuidProvider replicaGuidProvider)

     

    Solution

    This issue is resolved in RES Workspace Manager Relay Server 2014 SR3.

    In case the Service Release is not (yet) available or in case the Service Release cannot be installed, a revision containing this update is available on request at RES Support.

    IMPORTANT: A revision contains multiple fixes. Only apply this revision when you are experiencing a specific problem. Unless you are severely impacted by this specific problem, RES Software recommends that you wait for the next service release containing these fixes.