Unable to delete retired schedule

james.keefe — Wed, 26 Feb 2025 09:32:57 GMT

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.

Re: Unable to delete retired schedule

steven.boggs — Wed, 26 Feb 2025 14:36:08 GMT

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.

Re: Unable to delete retired schedule

james.keefe — Thu, 27 Feb 2025 08:54:14 GMT

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

Re: Unable to delete retired schedule

SayeedBinAbdullah — Thu, 27 Feb 2025 13:28:00 GMT

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

Re: Unable to delete retired schedule

james.keefe — Thu, 27 Feb 2025 14:56:35 GMT

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!

topic Re: Unable to delete retired schedule in Product Forum

Unable to delete retired schedule

Re: Unable to delete retired schedule

Re: Unable to delete retired schedule

Re: Unable to delete retired schedule

Re: Unable to delete retired schedule