SCOM 2012 SP1 Reports not listing servers discovered recently


  • Hi guys,

    I have an issue with our SCOM 2012 reports. When attempting to generate a report on a server which was recently discovered (say 1 month ago) the object isn't available to be selected nor does it appear in a report generated by a group. 

    Any older servers i can generate reports for (ie performance report for the past week which populate data (but not for the last 2 days which is also strange)).

    I have checked the management servers and found this error:

    Event ID: 31153

    Data was written to the Data Warehouse staging area but processing failed on one of the subsequent operations.
    Exception 'SqlException': Sql execution failed. Error 2627, Level 14, State 1, Procedure ManagedEntityChange, Line 368, Message: Violation of UNIQUE KEY constraint 'UN_ManagedEntityProperty_ManagedEntityRowIdFromDAteTime'. Cannot insert duplicate key in object 'dbo.ManagedEntityProperty'. The duplicate key value is (5034, Jan 30 2013  4:55AM). 

    One or more workflows were affected by this.  

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.ManagedEntity 
    Instance name: 729637f7-1893-453c-9c34-36bd46813a4f 
    Instance ID: {EB1509DE-91FE-7993-050A-2192489DD0E9} 
    Management group: *******

    I have read a number of posts and checked the performance of the Database server doesn't seem to be an issue, the existence of an object in the "Data Warehouse Synchronization Server" type and I'm not getting 31552 events.

    • Edited by Martin Sustaric Wednesday, July 17, 2013 11:03 PM update error with event code
    Wednesday, July 17, 2013 6:37 AM


  • So it turn out that there was a a number of duplicate entries in the 'dbo.ManagedEntityProperty' table for a couple of different dates. All the entries for the dates that were reporting issues were removed and the error was resolved.

    Checking the reports the new servers objects are being listed now.

    Friday, July 19, 2013 4:54 AM

All replies