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

Article ID: 2700028 - View products that this article applies to.
Expand all | Collapse all

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

CAUSE

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

RESOLUTION

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

  1. Open SQL Server Management Studio
  2. Connect to the SQL server hosting the Operations Manager Databases
  3. Expand Databases
  4. Right Click on OperationsManager and click properties
  5. Click Options
  6. Change the Compatibility level: drop down to SQL Server 2008 (100)
  7. Click OK
  8. Right Click on OperationsManagerDW and click properties
  9. Click Options
  10. Change the Compatibility level: drop down to SQL Server 2008 (100)
  11. Click OK


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
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 for other considerations.

Properties

Article ID: 2700028 - Last Review: July 9, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft System Center 2012 Operations Manager
Keywords: 
kbtshoot KB2700028

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com