Why is a "DELETE statement conflicted with COLUMN REFERENCE constraint" error generated when attempting to delete an execution server?

0 Likes

Problem:

Why is a "DELETE statement conflicted with COLUMN REFERENCE constraint" error generated when attempting to delete an execution server?

Resolution:

QUESTION
----------------------------------

Why is a "DELETE statement conflicted with COLUMN REFERENCE constraint" error generated when attempting to delete an execution server?

ANSWER
----------------------------------

The full error:

[machinename]DELETE statement conflicted with COLUMN REFERENCE constraint 
"FK_SS_Schedu__ExecS__603D47BB". The conflict occurred in database "SilkCentral", 
table "SS_Schedules_ExecServers", column "ExecServerID_pk_fk".



The reason for this error is that this database was created under SilkCentral Test Manager 7 or earlier. All database tables beginning with SS_ will have originated from the old version and are now redundant. SilkCentral Test Manager does not access this data in any way; these tables are only read when explicitly importing old SilkScheduler information into SilkCentral Test Manager.

To resolve this error;

  1. Open a SQLServer Query Analyzer on the database used for SilkCentral Test Manager.
  2. Open the attached script "SSDeleteDB.MSSQL.ddl" or copy the content into Query Analyzer
  3. Execute the script to erase all SS_ tables containing old SilkCentral Test Manager 7 data.


After having performed these steps, you should be able to delete the denoted execution server.


NOTE: RENAME ATTACHED FILE TO SSDeleteDB.MSSQL.ddl

 SSDeleteDB.MSSQL.txt



Related documents:


Old KB# 24637
Comment List
Related
Recommended