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