Errors in operation manager events, event id 33333 and 10850
I am receiving lots errors in logs with event id 33333 and 10850, they seem to repeat every hour Event ID 10850 A performance signature couldn't be inserted to the database. This could have happened because of one of the following reasons: - Performance signature is stale. The performance signature is generated by an MP recently deleted. - Database connectivity problems or database running out of space. - Performance signature received is not valid. The following details should help to further diagnose: Details: RuleId:c3841c2e-fdd6-083a-f6de-8bce2b0621b7. HealthServiceId:c48bbdd0-0b47-bc80-9d56-cd4c3ddbacac. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSignature_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.RuleId:2846023c-3dc7-5c4a-7d2a-a26df36b93e8. HealthServiceId:c48bbdd0-0b47-bc80-9d56-cd4c3ddbacac. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSignature_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.RuleId:b0de43e2-d37d-4a8b-a10a-0252ba0a104c. HealthServiceId:c48bbdd0-0b47-bc80-9d56-cd4c3ddbacac. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSignature_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.RuleId:15cc2149-8d42-7063-413c-b73a521a89b6. HealthServiceId:c48bbdd0-0b47-bc80-9d56-cd4c3ddbacac. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSignature_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.. Event ID 33333 Data Access Layer rejected retry on SqlError: Request: p_PerformanceSignatureUpsert -- (ObjectName=Process), (CounterName=Handle Count), (InstanceName=spoolsv), (BaseManagedEntityId=b303562e-7f31-26d8-e822-203074d816d7), (LearningRuleId=15cc2149-8d42-7063-413c-b73a521a89b6), (BusinessCycleUnit=Week), (BusinessCycleUnitMultiplier=1), (BusinessCycleStartTime=20/12/2009 00:00:00), (Sensitivity=2.81), (IsFrozen=False), (IsReset=False), (SignatureStartIndex=498), (Averages=139.405405405405;), (Deviations=8.250993255391;), (IsInitialized=1;), (TimeGenerated=23/12/2009 11:50:02), (RETURN_VALUE=1) Class: 0 Number: 3621 Message: The statement has been terminated.
December 23rd, 2009 2:55pm

Hello Dwelldon,These alerts seems a problem in authenication with SQL server. 1. Can you connect to your domain controller from your server?2. Do your account MOMAction has the permisssion to access DB?Besides, did you find any problem in the domain controller? This issue could also be caused by the AD problem. Hope it helps,Yog Li - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2009 1:15pm

Hi Dwelldon, 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 - MSFT
December 30th, 2009 3:53pm

My event logs on the SCE server are full of the following errors, I have tried to increase the space that the database has but it still fails. Any ideas?Error 10860 Performance data couldn't be inserted to the database. This could have happened because of one of the following reasons: - Performance data received is not valid. - Database connectivity problems or database running out of space. The following details should help to further diagnose: Details: RuleId:d0dc5bea-fa2b-1acf-f963-d1d97ed87b04. HealthServiceId:8fdd4ba5-a096-ef97-9aeb-f046eaad34a4. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSource_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.RuleId:bf7377ec-95e5-01f2-9cfb-df50b99e025a. HealthServiceId:8fdd4ba5-a096-ef97-9aeb-f046eaad34a4. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSource_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.RuleId:5c6b2e75-a096-af0b-d9b1-eb8522dc1bf5. HealthServiceId:8fdd4ba5-a096-ef97-9aeb-f046eaad34a4. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PerformanceSource_BaseManagedEntity". The conflict occurred in database "OperationsManager", table "dbo.BaseManagedEntity", column 'BaseManagedEntityId'.The statement has been terminated.. Error 33333 Data Access Layer rejected retry on SqlError: Request: p_PerformanceSignatureUpsert -- (ObjectName=Process), (CounterName=Handle Count), (InstanceName=spoolsv), (BaseManagedEntityId=f350a7c0-dd80-6218-50d1-9794a1ea5907), (LearningRuleId=15cc2149-8d42-7063-413c-b73a521a89b6), (BusinessCycleUnit=Week), (BusinessCycleUnitMultiplier=1), (BusinessCycleStartTime=17/01/2010 00:00:00), (Sensitivity=2.81), (IsFrozen=False), (IsReset=False), (SignatureStartIndex=380), (Averages=155.13620246979;), (Deviations=1.77588111277484;), (IsInitialized=1;), (TimeGenerated=19/01/2010 16:10:03), (RETURN_VALUE=1) Class: 0 Number: 3621 Message: The statement has been terminated.
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2010 7:12pm

Hello Dwelldon,I found that you already had a post, which is similar with this one:Errors in operation manager events, event id 33333 and 10850http://social.technet.microsoft.com/Forums/en-US/systemcenter/thread/7b8a1536-8f60-4882-86cb-994213bad932/Have you tried the suggestion in that thread? And what is the result?Thanks,Yog Li - MSFT
January 20th, 2010 1:20pm

Hi Yes I did and it can communicate with DC and there does seem to be security issuesDarrem
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2010 12:49pm

Sorry typo, there isn't any security issues.
January 26th, 2010 2:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics