Return
-
Title
SQL Script execution Error after running the Statistic Repository update script -
Description
User runs SQL script Merge_Domains_Statistic_Repostory gets error:Msg 547, Level 16, State 0, Line 319The DELETE statement conflicted with the REFERENCE constraint "FK_spotlight_perfdata_spotlight_monitored_objects". The conflict occurred in database "SpotlightStatisticsRepository", table "dbo.spotlight_perfdata", column 'monitored_object_id'.The statement has been terminated.Delete old domainMsg 547, Level 16, State 0, Line 331The DELETE statement conflicted with the REFERENCE constraint "FK_spotlight_monitored_objects_spotlight_domains". The conflict occurred in database "SpotlightStatisticsRepository", table "dbo.spotlight_monitored_objects", column 'domain_id'.The statement has been terminated.Msg 3903, Level 16, State 1, Line 336The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.Msg 3902, Level 16, State 1, Line 340The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.Merge of domains completed successfullyMsg 50000, Level 18, State 1, Line 325Deleting monitored objects failed (see previous messages for details)Msg 50000, Level 18, State 1, Line 337Deleting old domain failed (see previous messages for details) -
Cause
Before unlinking any 'child' that might use the old monitored objects, remove any timestamps that belong to the old domain and remove any perfdata that belong to monitored objects that are only in the old domain. -
Resolution
Use the new scripts and try again. -
Attachments