any idea on this error? Alert: Data Warehouse failed to deploy database component Source: scom.xxx.xxx Path: scom.xxx.xxx Last modified by: System Last modified time: 7/19/2011 10:15:02 AM Alert description: Data Warehouse failed to deploy database component. Failed to deploy Data Warehouse component. The operation will be retried. Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: DataSet, Id: '6e297b43-1fc7-7492-e977-8ed821082e10', Management Pack Version-dependent Id: '63f81d6c-8829-82a3-39ed-cda3cf0de5db'; Target: DataSet, Id: '521fa758-f842-442e-bfac-238c03ce1e30'. Batch ordinal: 8; Exception: Sql execution failed. Error 2627, Level 14, State 1, Procedure -, Line 87, Message: Violation of UNIQUE KEY constraint 'UN_StandardDatasetAggregationStorage_DatasetTableTag'. Cannot insert duplicate key in object 'dbo.StandardDatasetAggregationStorage'. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: scom.xxx.xxx Instance ID: {9FE8C44D-0338-AF89-081D-EFFE2E06826D} Management group: xxxx

Hi, I just noticed that you have already posted a thread for the similar issue and there is some replies. To avoid possible confusion and make our discussion clear, please continue the discussion in the original thread: installed new management packs for AD now seeing these alerts http://social.technet.microsoft.com/Forums/en-US/operationsmanagermgmtpacks/thread/10592158-d7eb-46d4-98e0-ff3d1308b189 Thank you for your understanding and cooperation. Nicholas Li - MSFT Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.