Skip navigation
316 Views 1 Reply Latest reply: Mar 28, 2012 6:57 AM by RSS
Haley Rookie 13 posts since
Jul 28, 2009

Has received 1 of 9 achievements.
Currently Being Moderated

Mar 28, 2012 6:51 AM

Clear down script for versionable ci types

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.



More Like This

  • Retrieving data ...

Bookmarked By (1)


  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS®  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software