返回
-
标题
Spotlight raising collection failure alarm: "Collection 'IndexLatchWaits' failed: Violation of UNIQUE KEY constraint " -
说明
After upgrade to Spotlight 11.0.2, Spotlight has raised following alarm:
"Connection: xxx Time: Monday, February 09, 2015 2:36:07 PM Severity: Information Monitored Server - SQL Server Collection Execution Failure: Collection 'IndexLatchWaits' failed : Error 2627, Level 14, State 1, Procedure -, Line 1, Message: Violation of UNIQUE KEY constraint 'UQ__#Dell_in__xxxx'. Cannot insert duplicate key in object 'dbo.#Dell_indexopstats2'. The duplicate key value is (livedb|dbo|MisArchiveApplKeys|mtpk_cs551260|1). [50000]"