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

JamesMarsh — Thu, 15 Aug 2019 08:16:00 GMT

It sounds like your Blue Prism database will have large amounts of data within it and it is likely some maintenance could fix this. There is good overview of why this error may occur in the Customer Support Support Center as follows: http://portal.blueprism.com/customer-support/support-center#/path/1137390322

This article also references the Maintaining a Blue Prism Database guide:
v6: https://portal.blueprism.com/documents/v6-data-sheet-maintaining-blue-prism-database-server
v5: https://portal.blueprism.com/documents/blue-prism-data-sheet-maintaining-blue-prism-database-server-0

------------------------------
James Marsh
Technical Consultant
Blue Prism
Europe/London
------------------------------

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

Process Deadlock while accessing Control Room

RE: Process Deadlock while accessing Control Room