Process Deadlock while accessing Control Room

BrianneGacad — Wed, 14 Aug 2019 08:28:00 GMT

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

RE: Process Deadlock while accessing Control Room

GopalBhaire — Wed, 14 Aug 2019 09:16:00 GMT

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

topic RE: Process Deadlock while accessing Control Room in Product Forum

Process Deadlock while accessing Control Room

RE: Process Deadlock while accessing Control Room