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