2014年9月3日 星期三

SCOM 2012 - 31553 Errors for Violation of UNIQUE KEY constraint 'UN_ManagedEntityProperty_ManagedEntityRowIdFromDAteTime'

Cause
=======
Duplicates in the DW 

Solution
===========
Ran the below query to remove the Violation of UNIQUE KEY constraint

delete mes
from ManagedEntityStage mes
inner join ManagedEntity me on mes.ManagedEntityGuid = me.ManagedEntityGuid
inner join ManagedEntityProperty mep on me.ManagedEntityRowId = mep.ManagedEntityRowId
where mep.FromDateTime = mes.ChangeDateTime 

沒有留言:

張貼留言