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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

     

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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