Hi All!

I have SCOM 2007 R2 on Windows Server 2003.

1) RMS  - Server01

2) Operations DB, Data Warehouse DB, Reporting Database - on Server02

3) Management Server, Audit Collection Server - Server03

Please help resolve the problem:

On RMS Server ERROR Event ID: 10830

Event Type:       Error

Event Source:   Health Service Modules

Event Category:               None

Event ID:             10830

Date:                    6/22/2010

Time:                    11:35:28 AM

User:                    N/A

Computer:         SCITOM

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:f8ded6bf-fa16-61a5-23b7-6e5731bde9fb. 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:f8ded6bf-fa16-61a5-23b7-6e5731bde9fb. 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:f8ded6bf-fa16-61a5-23b7-6e5731bde9fb. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Alert_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.

 

Hi.

These errors pop up when a 'racing condition' occurs (too many MPs changed/added/removed in a short time frame) or a bad MP has been imported.

Can you tell me what your last steps were before this error started popping up?

Hi Marnix.

Thank you for answer and sorry for my English:)

This error invoke after update antivirus edition with Kaspersky 6.0.3.837 on Kaspersky 6.0.4.1212 MP4.

I make this operations on domain controllers Windows Server 2003 too.

After this change errors began to apper on domain controllers.

Further have removed this edition antivirus on all servers ( RMS, Database, ACSand domain controllers), errors on domain controlers have disappeared, but on RMS error continues to be registered. Probably this error It is not connected with Kaspersky......

At the moment in many VIEW monitoring console viewing is inaccessible Alert Details>>(The page cannot be displayed) and not possible look many PERFORMANCE VIEW.

 

Hi,

 

In addition, if the databases are in SQL Server 2005, please also try the following:

 

FIX: A conflict with the foreign key constraint occurs when you update the case of the column values in the primary key table or you pad column values in the primary key table in SQL Server 2005

http://support.microsoft.com/kb/959015

 

Hope this helps.

 

Thanks.

Hi

 

sorry for my late answer.

This error is likely to happen only on the RMS since it seems you have no MS in place (Management Servers). Personally I am not sure whether it is the anti-virussoftware which causes this.

It looks like a SCOM issue to me, to be more exact, an SQL DB issue. At a customerssite I finally had to restore the DB since nothing else worked for me. The Console crashed on me, the SDK died as well so PS wasn't an option either.

Let me know how you are doing.

Hi, Nicholas! 

 I checked up the version. I have Sql Server 2005 SP3 ( 9.00.4053)

 

I do not have archive DB.

Most likely to correct an error I will need to rearrange everything from scratch....

 

Hi,

Check this thread http://www.systemcentercentral.com/tabid/60/indexId/23754/tag/Forums/Default.aspx#vindex26961

Hi all!

I have started the console under other account and alert details became accessible!

Problem with the initial account. Question in that how to return a normal configuration under initial account?

 

Try to delete this file: C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Microsoft.Mom.UI.Console\momcache.mdb

Has removed a profile completely.

Works!

As it is possible to learn what rule generate an error 10830?

RuleId:8654b44b-a532-3e3a-19be-1d4a66e9f790

PowerShell:

Get-Rule -Id 8654b44b-a532-3e3a-19be-1d4a66e9f790

Hi,

deleted file "momcache.mdb", again in 5 minutes - EVENT ID 10830: Health Service Modules.

There is not a cmdlet "Get-Rule", I am making the output of "Get-Command -Module OperationsManager"

Please help me!!

While flattening action described in this article: https://mariusene.wordpress.com/2013/04/15/scom-event-id-10830-health-service-modules-error/