Hi,
We are seeing lot of these events, and I can't seem to figure out why. Can
anyone help me identify why these errors occur?
We are on SCOM 2012 R2 Update Rollup 8.
A module of type
"Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.GroupCalculationModule"
reported an exception
Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.DatabaseQueryModuleException:
Guid should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> System.FormatException: Guid
should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String
failureMessageID, Object failureMessageFormatArgument, String
failureArgumentName, Exception innerException)
at System.Guid.TryParseGuidWithNoStyle(String guidString, GuidResult&
result)
at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult&
result)
at System.Guid..ctor(String g)
at
Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipSubscription.ValidateAndInitialize(MembershipSubscription
subscription)
--- End of inner exception stack trace ---
at
Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipSubscription.ValidateAndInitialize(MembershipSubscription
subscription)
at
Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipCalculationManager.UpdateAddedSubscriptions()
which was running as part of rule
"Desktop_Management_Svcs_Microsoft_Microsoft_Corp_PPE.GroupDiscovery"
running for instance
"Desktop_Management_Svcs_Microsoft_Microsoft_Corp_PPE.SubGroupClass" with
id:"{6EF3CAE6-CD25-BE01-FC54-FE939FEDECCB}" in management group "DAS_SCOM".
A module of type
"Microsoft.EnterpriseManagement.Mom.Modules.McfAlertWriteAction" reported
an exception System.Data.SqlClient.SqlException (0x80131904): The UPDATE
statement conflicted with the FOREIGN KEY constraint
"FK_Alert_ConnectorId". The conflict occurred in database
"OperationsManager", table "dbo.Connector", column 'ConnectorId'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection, Action`1 wrapCloseInAction)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async,
Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean
asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
at
Microsoft.EnterpriseManagement.DataAccessLayer.SqlRetryHandler.ExecuteReader(ExecuteArguments
executeArguments, QueryResults& queryResults)
at
Microsoft.EnterpriseManagement.DataAccessLayer.SqlRetryHandler.Execute[T](ExecuteArguments
executeArguments, RetryPolicy retryPolicy, GenericExecute`1 genericExecute)
at
Microsoft.EnterpriseManagement.DataAccessLayer.SqlRetryHandler.ExecuteReader(SqlCommand
sqlCommand, IList`1 prologEpilogList, IList`1 projection, QueryDefinition
queryDefinition, RetryPolicy retryPolicy)
at
Microsoft.EnterpriseManagement.DataAccessLayer.QueryRequest.Execute(SqlNotificationRequest
sqlNotificationRequest)
at
Microsoft.EnterpriseManagement.Mom.Modules.McfAlertWriteAction.ProcessDataItem(DataItemAlertSubscription[]
dataItems, Boolean isLogicalSet, DataItemAcknowledgementCallback
acknowledgedCallback, Object acknowledgedState,
DataItemProcessingCompleteCallback completionCallback, Object
completionState)
ClientConnectionId:99c29e6a-d1c8-43b3-b985-5e87c3f0ae23 which was running
as part of rule
"ProductConnectorSubscriptione2132f66_8fd8_4cd0_87d6_f5c84650efaf" running
for instance "AMMGMT.test.com" with
id:"{99896916-D5D9-923F-E5CC-F945D211B1EF}" in management group " DAS_SCOM
".
Philip
