Colin McNicholas
New Member
Our scheduler is not working following a server reboot and our control room operators are having to kick off jobs manually. In the event log we see this error. What can we do to quickly resolve this issue?
A database error occurred while executing the statement:
insert into BPAScheduleLog (scheduleid, instancetime, firereason, heartbeat, servername) values (@scheduleid, @instant, @reason, getutcdate(), @server); select scope_identity()
Error Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'UNQ_BPAScheduleLog_scheduleid_time'. Cannot insert duplicate key in object 'dbo.BPAScheduleLog'. The duplicate key value is (238, Aug 7 2018 2:00AM).
The statement has been terminated.
at BluePrism.AutomateAppCore.clsDBConnection.ReportError(SqlCommand cmd, Exception ex)
at BluePrism.AutomateAppCore.clsDBConnection.ExecuteReturnScalar(SqlCommand cmd)
at BluePrism.AutomateAppCore.clsServer.SchedulerCreateLog(Int32 scheduleId, DateTime instant, TriggerActivationReason reason, String schedulerName)
at BluePrism.AutomateAppCore.DatabaseBackedScheduleStore.CreateLog(ITriggerInstance inst, TriggerActivationReason reason)
at BluePrism.Scheduling.BackgroundThreadScheduler.OnTriggered(TriggeredEventArgs args)
at BluePrism.Scheduling.SchedulerThread.ActivateTriggers(DateTime instant)
at BluePrism.Scheduling.SchedulerThread.ProcessRunState()
at BluePrism.Scheduling.SchedulerThread.Run()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
A database error occurred while executing the statement:
insert into BPAScheduleLog (scheduleid, instancetime, firereason, heartbeat, servername) values (@scheduleid, @instant, @reason, getutcdate(), @server); select scope_identity()
Error Details: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'UNQ_BPAScheduleLog_scheduleid_time'. Cannot insert duplicate key in object 'dbo.BPAScheduleLog'. The duplicate key value is (238, Aug 7 2018 2:00AM).
The statement has been terminated.
at BluePrism.AutomateAppCore.clsDBConnection.ReportError(SqlCommand cmd, Exception ex)
at BluePrism.AutomateAppCore.clsDBConnection.ExecuteReturnScalar(SqlCommand cmd)
at BluePrism.AutomateAppCore.clsServer.SchedulerCreateLog(Int32 scheduleId, DateTime instant, TriggerActivationReason reason, String schedulerName)
at BluePrism.AutomateAppCore.DatabaseBackedScheduleStore.CreateLog(ITriggerInstance inst, TriggerActivationReason reason)
at BluePrism.Scheduling.BackgroundThreadScheduler.OnTriggered(TriggeredEventArgs args)
at BluePrism.Scheduling.SchedulerThread.ActivateTriggers(DateTime instant)
at BluePrism.Scheduling.SchedulerThread.ProcessRunState()
at BluePrism.Scheduling.SchedulerThread.Run()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()