Microsoft a publié un article dans la base de connaissances pour un problème sur System Center 2012 Operations Manager. En effet une série d’événements portant l’identifiant 29112 est générée après la mise à jour de System Center Operations Manager 2007 R2 à System Center 2012 Operations Manager :
Log Name: Operations Manager
Source: OpsMgr Management Configuration
Date:
Event ID: 29112
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer:
Description:
OpsMgr Management Configuration Service failed to execute bootstrap work item 'ConfigurationStoreInitializeWorkItem' due to the following exception
Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessException: Data access operation failed
at Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessOperation.ExecuteSynchronously(Int32 timeoutSeconds, WaitHandle stopWaitHandle)
at Microsoft.EnterpriseManagement.ManagementConfiguration.SqlConfigurationStore.ConfigurationStore.ExecuteOperationSynchronously(IDataAccessConnectedOperation operation, String operationName)
at Microsoft.EnterpriseManagement.ManagementConfiguration.SqlConfigurationStore.ConfigurationStore.Initialize()
at Microsoft.EnterpriseManagement.ManagementConfiguration.Engine.ConfigurationStoreInitializeWorkItem.ExecuteWorkItem()
at Microsoft.EnterpriseManagement.ManagementConfiguration.Interop.ConfigServiceEngineWorkItem.Execute()
-----------------------------------
Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessException: Data access operation failed to run SQL script. The following are the first 200 characters of the first failed batch
------
ALTER PROCEDURE CS.AgentCredentialDeltaSyncProcessStaging
@LogEnabledInd bit = 0
AS
BEGIN
SET NOCOUNT ON
DECLARE
@ErrorInd bit
,@ErrorMessage nvarchar(max)
-----------------------------------
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'MERGE'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near 'TRY'.
Incorrect syntax near 'CATCH'.
Incorrect syntax near 'END'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)
at Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.NonQuerySqlCommandOperation.SqlCommandCompleted(IAsyncResult asyncResult)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="OpsMgr Management Configuration" />
<EventID Qualifiers="49152">29112</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="xxxxxxx" />
<EventRecordID>5322</EventRecordID>
<Channel>Operations Manager</Channel>
<Computer>xxxxxxx</Computer>
<Security />
</System>
<EventData>
<Data>OpsMgr Management Configuration Service</Data>
<Data>ConfigurationStoreInitializeWorkItem</Data>
<Data>Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessException: Data access operation failed
at Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessOperation.ExecuteSynchronously(Int32 timeoutSeconds, WaitHandle stopWaitHandle)
at Microsoft.EnterpriseManagement.ManagementConfiguration.SqlConfigurationStore.ConfigurationStore.ExecuteOperationSynchronously(IDataAccessConnectedOperation operation, String operationName)
at Microsoft.EnterpriseManagement.ManagementConfiguration.SqlConfigurationStore.ConfigurationStore.Initialize()
at Microsoft.EnterpriseManagement.ManagementConfiguration.Engine.ConfigurationStoreInitializeWorkItem.ExecuteWorkItem()
at Microsoft.EnterpriseManagement.ManagementConfiguration.Interop.ConfigServiceEngineWorkItem.Execute()
Ce problème est dû au mode de compatibilité appliqué au serveur SQL hébergeant les bases de données SCOM. Pour résoudre le problème, vous devez changer le mode de compatibilité à SQL 2008 (100) sur la base de données OperationsManager et OperationsManagerDW :
· Ouvrez SQL Server Management Studio
· Connectez-vous à l’instance
· Ouvrez le nœud Databases
· Cliquez droit sur la base de données OperationsManager ou OperationsManagerDW et sélectionnez Properties
· Cliquez sur Options
· Changez l’option Compatibility level à SQL 2008 (100)
Plus d’information sur la KB2700028 : Event ID 29112 generated after upgrading to System Center 2012 Operations Manager
