Unable to delete retired schedule

[james.keefe]

Hi all,

Been doing some cleaning up of old schedules, but we can't seem to delete some retired schedules - we keep getting this - have also tried on our app server but no joy. any ideas? thanks in advance.

[steven.boggs]

Hi James,

For more context about this generic error, could you please also provide the full list of actions within the 'Detail' button's additional stack trace screen?

When deleting this type of data, it's performed as a "soft delete", meaning BPE does not physically delete it because these items could still be referenced in other places like AuditEvents and the ScheduleLogs tables. Understanding what the stacktrace message in the error's 'Details' screen would be useful to know what's happening when you attempt this action.

[james.keefe]

Hi Steven - large amount of data here, hope its of use. Can they be deleted via cmd? thanks

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
The statement has been terminated. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at BluePrism.AutomateAppCore.clsDBConnection.ExecuteReturnRecordsAffected(IDbCommand cmd)
at BluePrism.AutomateAppCore.clsServer.SchedulerDeleteSchedule(IDatabaseConnection a, SessionRunnerSchedule b)
at BluePrism.AutomateAppCore.clsServer.SchedulerDeleteSchedule(SessionRunnerSchedule schedule)
at SyncInvokeSchedulerDeleteSchedule(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
at BluePrism.Server.Domain.Models.ExtensionMethods.RethrowWithStackTrace(Exception this)
at BluePrism.AutomateAppCore.MyExceptionHandlingMessageInspector.AfterReceiveReply(Message& reply, Object correlationState)
at System.ServiceModel.Dispatcher.ImmutableClientRuntime.AfterReceiveReply(ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

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.SchedulerDeleteSchedule(SessionRunnerSchedule schedule)
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at BluePrism.AutomateAppCore.ServerManager.Intercept(IInvocation invocation)
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at BluePrism.AutomateAppCore.DatabaseBackedScheduleStore.DeleteSchedule(SessionRunnerSchedule sched)
at AutomateUI.ctlControlRoom.jj()
ClientConnectionId:3ad1314a-e973-4fa9-8824-d2f55a60b854
Error Number:-2,State:0,Class:11

[SayeedBinAbdullah · Accepted solution]

Hi @james.keefe 

Even I have faced this issue, I followed below steps to resolve,

-> Unretire the schedule which you want delete
-> Delete the tasks under that schedule (refer to below image)
-> Then try deleting the schedule

Hope this will work.

Best Regards,
Sayeed Bin Abdullah

[james.keefe]

Hi, thank you for the above, this worked (although i had to delete a task at a time and apply changes after each one). Thank you!