Retention Clean failed

[Alex Brehm]

Would someone be able to help me figure out why?

Error:

RP (ID=2): Error during purge: System.Data.SqlClient.SqlException (0x80131904): 547160Releases_PurgeReleaseData164The DELETE statement conflicted with the REFERENCE constraint "FK__ChangeControlEnvironments__ChangeControls". The conflict occurred in database "BuildMaster", table "dbo.ChangeControlEnvironments", column 'ChangeControl_Id'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Inedo.Data.SqlServerDataFactory.ExecuteNonQuery(String storedProcName, IList`1 parameters)
at Inedo.BuildMaster.Windows.ServiceApplication.Retention.ReleaseRetentionPolicy.Purge()
at Inedo.BuildMaster.Windows.ServiceApplication.RetentionPolicyExecuter.Execute()
ClientConnectionId:9114d3f8-3637-4823-b8b8-d5c1a5532650

Product: BuildMaster
Version: 4.8.6

[Tod]

This is a bug in the Release_PurgeReleaseData stored procedure that was fixed in a later version.

You can patch it by editing it and removing these lines:

/* 2c) Configuration */
    DELETE [ChangeControls]
     WHERE [Application_Id] = @Application_Id AND [Release_Number] = @Release_Number

NOTE: make sure it's the 2c) line and the 2 following you delete... the 2d) one is correct. (The delete from the ChangeControls table is in there twice for some reason, which is the cause of this bug.)