Hi all,
I am facing the following issue when creating a report with one schedule, sometimes it throws the following error. Have you ever experienced?
View attachment report.PNG
Full message is:
System.NullReferenceException: Object reference not set to an instance of an object.
Server stack trace:
at BluePrism.AutomateAppCore.clsScheduleList.get_Schedules()
at BluePrism.AutomateAppCore.clsServer.SchedulerCreateScheduleList(clsScheduleList list)
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.SchedulerCreateScheduleList(clsScheduleList list)
at BluePrism.AutomateAppCore.clsDatabaseBackedScheduleStore.SaveScheduleList(clsScheduleList list)
at Automate.ctlControlRoom.SaveScheduleList(clsScheduleList list)
And sometimes this other one, which I assume is because I try to save with the same name as I did before?
duplicate key in object 'dbo.BPAScheduleList'. The duplicate key value is (1, Report54).
The statement has been terminated.
Server stack trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at BluePrism.AutomateAppCore.clsDBConnection.ExecuteReturnScalar(SqlCommand cmd)
at BluePrism.AutomateAppCore.clsServer.SchedulerCreateScheduleList(clsScheduleList list)
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.SchedulerCreateScheduleList(clsScheduleList list)
at BluePrism.AutomateAppCore.clsDatabaseBackedScheduleStore.SaveScheduleList(clsScheduleList list)
at Automate.ctlControlRoom.SaveScheduleList(clsScheduleList list)
ClientConnectionId:3d1bc2f5-9f92-4507-8670-14852131dfd5
Error Number:2627,State:1,Class:14
Thanks a lot for the hints!!!
I am facing the following issue when creating a report with one schedule, sometimes it throws the following error. Have you ever experienced?
View attachment report.PNG
Full message is:
System.NullReferenceException: Object reference not set to an instance of an object.
Server stack trace:
at BluePrism.AutomateAppCore.clsScheduleList.get_Schedules()
at BluePrism.AutomateAppCore.clsServer.SchedulerCreateScheduleList(clsScheduleList list)
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.SchedulerCreateScheduleList(clsScheduleList list)
at BluePrism.AutomateAppCore.clsDatabaseBackedScheduleStore.SaveScheduleList(clsScheduleList list)
at Automate.ctlControlRoom.SaveScheduleList(clsScheduleList list)
And sometimes this other one, which I assume is because I try to save with the same name as I did before?
duplicate key in object 'dbo.BPAScheduleList'. The duplicate key value is (1, Report54).
The statement has been terminated.
Server stack trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at BluePrism.AutomateAppCore.clsDBConnection.ExecuteReturnScalar(SqlCommand cmd)
at BluePrism.AutomateAppCore.clsServer.SchedulerCreateScheduleList(clsScheduleList list)
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.SchedulerCreateScheduleList(clsScheduleList list)
at BluePrism.AutomateAppCore.clsDatabaseBackedScheduleStore.SaveScheduleList(clsScheduleList list)
at Automate.ctlControlRoom.SaveScheduleList(clsScheduleList list)
ClientConnectionId:3d1bc2f5-9f92-4507-8670-14852131dfd5
Error Number:2627,State:1,Class:14
Thanks a lot for the hints!!!