My Experience Handling Event ID: 10830 issue

My Experience Handling Event ID: 10830 issue

Event Type:           Error

Event Source:       Health Service Modules

Event Category:   None

Event ID:                10830

Date:                      11/11/2011

Time:                      10:33:27 AM

User:                      N/A

Computer:             IND-APP142

Description:

An alert couldn't be inserted to the database. This could have happened because  of one of the following reasons:

                - Alert is stale. The alert is generated by an MP recently deleted.

                - Database connectivity problems or database running out of space.

                - Alert received is not valid.

 The following details should help to further diagnose:

 Details: RuleId:8654b44b-a532-3e3a-19be-1d4a66e9f790. HealthServiceId:e840b3ad-86d3-d373-1970-4c8b39f171c2. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.

The statement has been terminated.RuleId:8654b44b-a532-3e3a-19be-1d4a66e9f790. HealthServiceId:e840b3ad-86d3-d373-1970-4c8b39f171c2. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.

The statement has been terminated..

To display which Agent is sending the Stale Data use the below commandlet

get-monitoringobject -id < HealthServiceId>

Ex: get-monitoringobject -id e840b3ad-86d3-d373-1970-4c8b39f171c2

This will display the agent name which is causing the issue. Follow the below steps to resolve the issue.

1.     Login to the effected server

2.     Stop the System Center Management Service

3.     Navigate to the %Program Files%\System Center operations Manager 2007\Health Service State folder - delete all the folders and files in that folder

4.     Start the System Center Management service.

My Experience Handling Event ID: 31552 issue

My Experience Handling Event ID: 31552 issue

We have observed below two flavors of Event ID’s. I have worked with PSS support team around 3 months to fix this issue.  Belo w are the Event Details

Event Type:           Error

Event Source:       Health Service Modules

Event Category:   Data Warehouse

Event ID:                31552

Date:                      6/28/2011

Time:                      9:16:46 AM

User:                      N/A

Computer:             IND-APP142

Description:

Failed to store data in the Data Warehouse.

Exception 'SqlException': Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

One or more workflows were affected by this. 

Workflow name: Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance

Instance name: State data set

Instance ID: {0AD76E64-3116-AE30-BCF0-740C26A1863C}

Management group: MG_IND

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Event Type:           Error

Event Source:       Health Service Modules

Event Category:   Data Warehouse

Event ID:                31552

Date:                      6/24/2011

Time:                      5:37:48 AM

User:                      N/A

Computer:             IND-APP142

Description:

Failed to store data in the Data Warehouse.

Exception 'SqlException': Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

One or more workflows were affected by this. 

Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.Configuration

Instance name: tac-app142.prod.ds.russell.com

Instance ID: {024F88C7-F71B-9221-D650-8D988DB4901B}

Management group: MG_IND

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The first event (Instance name: State data set) we have fixed with the below steps.

Query to display the Dirty Ind’s

Declare @DataSet as uniqueidentifier

Set @DataSet = (Select datasetid from standarddataset where schemaname = 'State')

Select Count(*) from StandardDataSetAggregationHistory

where DataSetId = @DataSet

And DirtyInd = 1

----------------------------------------------------------------------------------------------------------------------------------

Query to clear the Dirty Ind’s

declare @i int

set @i=0

DECLARE @DataSet uniqueidentifier

SET @DataSet = (SELECT DatasetId FROM StandardDataset WHERE SchemaName = 'State')

while(@i<=500)

begin

EXEC standarddatasetmaintenance @DataSet

set @i=@i+1

Waitfor delay '00:00:05'

end

---------------------------------------------------------------------------------------------------------------------------

Second 31552 event was due to we are using SQL 2005 standard version and Online Indexing was failing every hour. This which captured using SQL profiler tool.