Select the product you need help with

Event ID 29112 generated after upgrading to System Center 2012 Operations Manager

Article ID: 2700028 - View products that this article applies to.

SYMPTOMS

After Upgrading from System Center Operations Manager 2007 R2 CU5 to System Center 2012 Operations Manager, the following error may be logged in the Operations Manager Event Log

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()

Back to the top | Give Feedback

CAUSE

This can occur if SQL Server is running the Operations Manager databases in SQL 2005 compatibility mode.

Back to the top | Give Feedback

RESOLUTION

To resolve this issue, change the SQL database Compatibility Level to SQL 2008 (100) by doing the following:

Open SQL Server Management Studio
Connect to the SQL server hosting the Operations Manager Databases
Expand Databases
Right Click on OperationsManager and click properties
Click Options
Change the Compatibility level: drop down to SQL Server 2008 (100)
Click OK
Right Click on OperationsManagerDW and click properties
Click Options
Change the Compatibility level: drop down to SQL Server 2008 (100)
Click OK

Back to the top | Give Feedback

MORE INFORMATION

For more information on changing Database Compatibility Levels see the following:

http://msdn.microsoft.com/en-us/library/bb510680(v=sql.105).aspx

(http://msdn.microsoft.com/en-us/library/bb510680(v=sql.105).aspx)

Back to the top | Give Feedback

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback