Trying to delete a project from a partial/failed import from HP QC 10. When I try the delete, ST says it can't. Application log shows: APPLICATION.Business.DataAccess::ExecuteNonQuery: The DELETE statement conflicted with the REFERENCE constraint "FK_TST_PROJECT_TST_ARTIFACT_ATTACHMENT". The conflict occurred in database "SpiraTest", table "dbo.TST_ARTIFACT_ATTACHMENT", column 'PROJECT_ID'. The statement has been terminated. [System.Data.SqlClient.SqlException] Stack Trace: 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at APPLICATION.Business.DataAccess.ExecuteNonQuery(String sqlCommand, Boolean useParam) en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/276.aspxthreadId=276Matt Warren (mwarren@hnw.com)Trying to delete a project from a partial/failed import from HP QC 10. When I try the delete, ST says it can't. Application log shows: APPLICATION.Business.DataAccess::ExecuteNonQuery: The DELETE statement conflicted with the REFERENCE constraint "FK_TST_PROJECT_TST_ARTIFACT_ATTACHMENT". The conflict occurred in database "SpiraTest", table "dbo.TST_ARTIFACT_ATTACHMENT", column 'PROJECT_ID'. The statement has been terminated. [System.Data.SqlClient.SqlException] Stack Trace: 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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at APPLICATION.Business.DataAccess.ExecuteNonQuery(String sqlCommand, Boolean useParam) Wed, 02 May 2012 03:17:46 -04002012-07-27T19:08:26-04:00/Support/Forum/spiratest/issues-questions/276.aspxmessageId=535David J (adam.sandman+support@inflectra.com) To give specific support on this issue, please contact Inflectra support. It looks like an attachment that has gotten cross-linked across a project. There is a SQL command that should fix it: DELETE FROM TST_ARTIFACT_ATTACHMENT WHERE PROJECT_ID = X (where X is the ID of the project in SpiraTest) Thu, 24 May 2012 09:39:15 -04002012-05-24T09:39:15-04:00/Support/Forum/spiratest/issues-questions/276.aspx#reply535messageId=612Christoph Bruendler (christoph.bruendler@frama.com)There is still a project I can't delete... Here is what we found in Application log: we got several entries here just the first one (as pasting two much, fills up the capacity of the text field): Error 1 APPLICATION.Business.DataAccess::ExecuteNonQuery: The DELETE statement conflicted with the REFERENCE constraint "FK_TST_PROJECT_ATTACHMENT_TYPE_TST_PROJECT_ATTACHMENT". The conflict occurred in database "SpiraTeam", table "dbo.TST_PROJECT_ATTACHMENT", column 'PROJECT_ATTACHMENT_TYPE_ID'. The statement has been terminated. [System.Data.SqlClient.SqlException] Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at APPLICATION.Business.DataAccess.ExecuteNonQuery(String sqlCommand, Boolean useParam) Error 2 APPLICATION.Business.Attachment::DeleteAllProjectAttachmentInfo: Database foreign key violation occurred [APPLICATION.Business.DataAccessForeignKeyException] etc.... I have delete the only incident in that project, and the table dbo.TST_ARTIFACT_ATTACHMENT" does not contain any record for this project anymore. What shall we try next? Wed, 25 Jul 2012 14:06:45 -04002012-07-25T14:06:45-04:00/Support/Forum/spiratest/issues-questions/276.aspx#reply612messageId=617David J (adam.sandman+support@inflectra.com) It looks like you have some project attachment types that have somehow gotten linked to attachments in a different project. You need to get a list of all the PROJECT_ATTACHMENT_TYPE_IDs in the project you're deleting and make sure that all attachments (TST_PROJECT_ATTACHMENT) in other projects are not using them.Fri, 27 Jul 2012 19:08:26 -04002012-07-27T19:08:26-04:00/Support/Forum/spiratest/issues-questions/276.aspx#reply617