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}

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.

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.

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