locked
installed new management packs for AD now seeing these alerts RRS feed

  • Question

  • any idea what these alerts are?

     

     

    Alert: AD Op Master response is above the configured threshold

     

    Alert: Data Warehouse failed to deploy database component

    Source: scom.xxxxxxx

    Path: scom.xxxxx

    Last modified by: System

    Last modified time: 7/18/2011 8:32:42 PM 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.xxxxxxxxxx

     

    Instance ID: {9FE8C44D-0338-AF89-081D-EFFE2E06826D}

     

    Management group: xxxxxxxxx

     

     

     


    Tuesday, July 19, 2011 3:34 AM

Answers

  • It looks like the data set defined in the MP is having issues getting inserted because it is already there.
    Microsoft Corporation
    • Marked as answer by Nicholas Li Friday, July 22, 2011 8:25 AM
    Tuesday, July 19, 2011 5:39 PM
  •  

    Hi,

     

    Please check the Event Log and see if there are any related errors. If the issue just occurs after the AD Management Pack imported, just for a test, please try removing and reimporting the AD Management Pack and its overrides management pack.

     

    Hope this helps.

     

    Thanks.
    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.
    • Marked as answer by Nicholas Li Friday, July 22, 2011 8:25 AM
    Wednesday, July 20, 2011 8:23 AM

All replies

  • It looks like the data set defined in the MP is having issues getting inserted because it is already there.
    Microsoft Corporation
    • Marked as answer by Nicholas Li Friday, July 22, 2011 8:25 AM
    Tuesday, July 19, 2011 5:39 PM
  •  

    Hi,

     

    Please check the Event Log and see if there are any related errors. If the issue just occurs after the AD Management Pack imported, just for a test, please try removing and reimporting the AD Management Pack and its overrides management pack.

     

    Hope this helps.

     

    Thanks.
    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.
    • Marked as answer by Nicholas Li Friday, July 22, 2011 8:25 AM
    Wednesday, July 20, 2011 8:23 AM
  • yes the error in the event logs are 

     

    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: s 

    Instance ID: {9FE8C44D-0338-AF89-081D-EFFE2E06826D} 

    Management group: 

    Wednesday, July 27, 2011 10:19 PM