none
Need help to resolve System Center Essentials Alerts

    Question

  • Looks like my database is having problems

    Need help to resolve these.  Thank you

     

    Alert: Data Warehouse object health state data dedicated maintenance process failed to perform maintenance operation

    Source: abc.abc.net

    Path: abc.abc.net

    Last modified by: System

    Last modified time: 8/30/2011 3:27:37 AM Alert description: Data Warehouse object health state data dedicated maintenance process failed to perform maintenance operation. Failed to store data in the Data Warehouse.

    Exception 'SqlException': Sql execution failed. Error 777971002, Level 16, State 1, Procedure StandardDatasetAggregate, Line 424, Message: Sql execution failed. Error 777971002, Level 16, State 1, Procedure StateAggregate, Line 341, Message: Sql execution failed. Error 8115, Level 16, State 1, Procedure -, Line 1, Message: Arithmetic overflow error converting IDENTITY to data type int.

    One or more workflows were affected by this.

    Workflow name: Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance

    Instance name: State data set

    Instance ID: {35F4EF53-3D99-88D5-A45B-2985280CDEEA}

    Management group: abc_MG

     

    Alert: Data Warehouse object health state data writer process failed to perform maintenance operation

    Source: abc.abc.net

    Path: abc.abc.net

    Last modified by: System

    Last modified time: 8/30/2011 6:17:29 AM Alert description: Data Warehouse object health state data writer process failed to perform maintenance operation. Data was written to the Data Warehouse staging area but processing failed on one of the subsequent operations.

    Exception 'SqlException': Sql execution failed. Error 777971002, Level 16, State 1, Procedure StandardDatasetAggregate, Line 424, Message: Sql execution failed. Error 777971002, Level 16, State 1, Procedure StateAggregate, Line 341, Message: Sql execution failed. Error 8115, Level 16, State 1, Procedure -, Line 1, Message: Arithmetic overflow error converting IDENTITY to data type int.

    One or more workflows were affected by this.

    Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectEntityHealthStateChange

    Instance name: abc.abc.net

    Instance ID: {9B2F984E-A66A-C072-D3F8-5FB70FD9BFB1}

    Management group: abc_MG

    Notification subscription ID generating this message: {74540714-CD0A-56F6-E291-86A5BC56C33C}

    Notification subscription ID generating this message: {74540714-CD0A-56F6-E291-86A5BC56C33C}

    Thursday, September 01, 2011 2:44 PM

Answers

All replies

  • Hello Po,

    Did you use any local date/time format except English? Here is an article which disscussed a similar issue:

    WSUS core error 10022 - e#=8115, Arithmetic overflow error converting expression to data type datetime
    http://social.technet.microsoft.com/Forums/en-US/systemcenter/thread/d5c25c4e-c1eb-4fc6-8b25-e93449dc3916

    Also,  Daniele Grandini has written an article to disscuss a same error here:

    A tale of Identity and bad agent behavior
    http://nocentdocent.wordpress.com/2011/06/18/a-tale-of-identity-and-bad-agent-behavior/

    Please check if the articles can help you.

    Thanks,


    Yog Li -- 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.
    Monday, September 05, 2011 11:54 AM
    Moderator
  • Hi Po,

    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as "Answered" as the previous steps should be helpful for many similar scenarios.

    In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.

    Thanks,


    Yog Li -- 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.
    Friday, September 09, 2011 9:50 AM
    Moderator
  • Sorry for the late update

    "Also,  Daniele Grandini has written an article to disscuss a same error here:

    A tale of Identity and bad agent behavior
    http://nocentdocent.wordpress.com/2011/06/18/a-tale-of-identity-and-bad-agent-behavior/"

    We solved our problem with Daniele Grandini suggestions

    Thank you

    • Proposed as answer by bobgreen84MVP Saturday, April 21, 2012 12:43 PM
    Friday, September 16, 2011 4:09 PM