Control Room & Scheduler

Expand all | Collapse all

Process Deadlock while accessing Control Room

  • 1.  Process Deadlock while accessing Control Room

    Posted 08-14-2019 09:28
    Hi All,

    Just wanted to ask around if anyone has a known solution for the below error. 
    This happens when trying to navigate around control room - specifically when trying to look and monitor processes that are currently running.

    Error message and screenshot below:

    System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 242) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    Server stack trace:
    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 BluePrism.AutomateAppCore.clsServer.GetFilteredSessions(IDatabaseConnection con, ICollection`1 processNames, ICollection`1 resourceName, String userName, SessionStatus sessStatus, DateTime startDate, DateTime endDate, DateTime updatedBefore, Boolean localButRemote, Boolean excludeAllLocal, Int32 maxSessionCount, SessionSortInfo sortInfo)
    at BluePrism.AutomateAppCore.clsServer.GetFilteredSessions(ICollection`1 processNames, ICollection`1 resourceName, String userName, SessionStatus sessStatus, DateTime startDate, DateTime endDate, DateTime updatedBefore, Boolean localButRemote, Boolean excludeAllLocal, Int32 maxSessionCount, SessionSortInfo sortInfo)
    at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

    Exception rethrown at [0]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    at BluePrism.AutomateAppCore.IServer.GetFilteredSessions(ICollection`1 processNames, ICollection`1 resourceName, String userName, SessionStatus sessStatus, DateTime startDate, DateTime endDate, DateTime updatedBefore, Boolean localButRemote, Boolean excludeAllLocal, Int32 maxSessionCount, SessionSortInfo sortInfo)
    at AutomateUI.ctlSessionManagement.GetFilteredSessions(Int32 maxSessionCount)
    ClientConnectionId:e4d89b07-c074-4ea5-9051-33e5fc42538f
    Error Number:1205,State:52,Class:13

    Screenshot:


    Thanks in advance!

    Brian


    ------------------------------
    Bri Gacad
    Senior IT Domain Specialist
    Telstra
    Australia/Melbourne
    ------------------------------


  • 2.  RE: Process Deadlock while accessing Control Room

    Posted 08-14-2019 10:16
    The issue is probably with size of database, you can find more info here http://portal.blueprism.com/customer-support/support-center#/path/1137390322

    ------------------------------
    Gopal Bhaire
    Analyst
    Accenture
    ------------------------------