1 Reply Latest reply on Mar 28, 2012 6:57 AM by Carl.Simpson

    Clear down script for versionable ci types

    Haley Rookie

      Am using the DeleteCIType_Versionable.sql script to clear down config items prior to loading the spreadsheets onto the live system. 


      All was going fine until I tried it on Radios.  I got the error message  "The DELETE statement conflicted with the REFERENCE constraint "fkey$cm_change$ci". The conflict occurred in database "LDSD_OOTB", table "dbo.cm_change", column 'cm_config_item_guid'."


      When trying the import my log file is full of error messages

      "28/03/2012 13:19:20 : Cannot insert duplicate key row in object 'dbo.cf_config_item' with unique index 'index$cf_config_item$title'.
      The statement has been terminated."


      Anyone any ideas of what I need to change to get this to run for these items.