Hello,
We are running SCOM 2012 SP1. We have 8 Management Servers (one of them
serving as the RMSe), 3 Gateway Servers, 1 Reporting Services server, 1
Data Warehouse DB server, 1 Operations Manager DB server, 1 ACS DB
server, 1 ACS Collector.
Except for the 3 Gateway Servers, all of the other servers mentioned
above are virtual and in the same physical datacenter.
Recently (about 2-3 weeks) one of the Management Servers (not the RMSe)
has been displaying Event Id 31553 approximately every minute at the
very least. None of the other Management or Gateway servers are
displaying this event.
I tried moving all of this Management Server's agents to other
management servers to see if that cleared it up, but it did not. The
problematic management server is connected to the SCOM databases, the
Console is showing this MS as healthy.
The details of the Event are:
Log Name: Operations Manager
Source: Health Service Modules
Date: 11/21/2013 6:36:15 AM
Event ID: 31553
Task Category: Data Warehouse
Level: Error
Keywords: Classic
User: N/A
Computer: vausscomms006.americas.PPDI.LOCAL
Description:
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 (23623, Aug 7 2013 6:45PM).
One or more workflows were affected by this.
Workflow name:
Microsoft.SystemCenter.DataWarehouse.Synchronization.ManagedEntity
Instance name: 581c60d4-d293-4d69-a691-e21ae2f5d8df
Instance ID: {94F3F6AD-5845-50BD-9371-AFECD148316C}
Management group: PPDI
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event";>
<System>
<Provider Name="Health Service Modules" />
<EventID Qualifiers="49152">31553</EventID>
<Level>2</Level>
<Task>3</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-11-21T12:36:15.000000000Z" />
<EventRecordID>866471</EventRecordID>
<Channel>Operations Manager</Channel>
<Computer>vausscomms006.americas.PPDI.LOCAL</Computer>
<Security />
</System>
<EventData>
<Data>PPDI</Data>
<Data>Microsoft.SystemCenter.DataWarehouse.Synchronization.ManagedEntity
</Data>
<Data>581c60d4-d293-4d69-a691-e21ae2f5d8df</Data>
<Data>{94F3F6AD-5845-50BD-9371-AFECD148316C}</Data>
<Data>SqlException</Data>
<Data>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 (23623, Aug 7 2013 6:45PM).</Data>
</EventData>
</Event>
The highlighted portion is the same for every event occurrence.
I have not been able to find anything that works on any blogs.
My next move was to remove this Management Server from the environment,
wait 48hrs and put it back in, but I wanted to put a "feeler" out to
this group first.
Thanks,
Sven
Sven Wells
SYSTEMS ADMINISTRATION SPECIALIST
Communication and Infrastructure Services
TIP - Technology, Innovation and Performance
Wilmington NC HQ
PPD
Phone +1 910 558 6870
[email protected]
<mailto:[email protected]> www.ppdi.com
<http://www.ppdi.com/>
This email transmission and any documents, files or previous email messages
attached to it may contain information that is confidential or legally
privileged.
If you are not the intended recipient or a person responsible for delivering
this transmission to the intended recipient, you are hereby notified
that you must not read this transmission and that any disclosure, copying,
printing, distribution or use of this transmission is strictly prohibited.
If you have received this transmission in error, please immediately notify the
sender by telephone or return email and delete the original transmission and
its attachments without reading or saving in any manner.
