We recently upgraded to 6.0.2 from 4.7 and now cannot ampty the recycle bin. Getting the following error when the web service /webservices/trashcan.asmx/EmptyTrashcan is called but there is no information about which node is causing the conflict:
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode". The conflict occurred in database "rbl_umbraco_6x", table "dbo.umbracoNode", column 'parentID'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
at Umbraco.Core.Persistence.Repositories.PetaPocoRepositoryBase`2.PersistDeletedItem(TEntity entity)
at Umbraco.Core.Persistence.Repositories.ContentRepository.PersistDeletedItem(IContent entity)
at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.PersistDeletedItem(IEntity entity)
at Umbraco.Core.Persistence.UnitOfWork.PetaPocoUnitOfWork.Commit()
at Umbraco.Core.Services.ContentService.EmptyRecycleBin()
at umbraco.cms.businesslogic.RecycleBin.CallTheGarbageMan(Action`1 itemDeletedCallback)
at umbraco.presentation.webservices.trashcan.EmptyTrashcan(RecycleBinType type)
Error when emptying recycle bin
We recently upgraded to 6.0.2 from 4.7 and now cannot ampty the recycle bin. Getting the following error when the web service /webservices/trashcan.asmx/EmptyTrashcan is called but there is no information about which node is causing the conflict:
is working on a reply...