We are unable to delete a publication from CMS (SDL Tridion 2013 SP1) and constantly getting the error message: "Unable to delete Publication (This publish transaction is in progress.)."
There are no published items in this publication, no items pending in the Publishing queue, and no items in the Workflow as well. The publication is not inherited by any Child publication
Validated the tables PUBLISH_TRANSACTIONS and PUBLISH_STATES, and they don't have any rows with "State =1" for this publication.
Tridion Event log displays the following message:
Unable to delete Publication (This publish transaction is in progress.).
Component: Tridion.ContentManager.CoreService Errorcode: 856 User: NT AUTHORITY\NETWORK SERVICE StackTrace Information Details: at Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.ExecuteNonQuery(StoredProcedureInvocation storedProcedureInvocation) at Tridion.ContentManager.Data.AdoNet.IdentifiableObjectDataMapper.Tridion.ContentManager.Data.IIdentifiableObjectDataMapper.Delete(TcmUri id) at Tridion.ContentManager.IdentifiableObject.Delete(DeleteEventArgs deleteEventArgs, Boolean abortTransactionOnError) at Tridion.ContentManager.IdentifiableObject.Delete() at Tridion.ContentManager.CoreService.CoreServiceBase.Delete(String id) at SyncInvokeDelete(Object , Object , Object ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object inputs, Object& outputs) at Tridion.ContentManager.CoreService.CoreServiceInvoker.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)
Please suggest what needs to be done to delete the publication.