DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2700028 - Last Review: July 9, 2012 - Revision: 2.0

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 (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 (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

APPLIES TO
  • Microsoft System Center 2012 Operations Manager
Keywords: 
kbtshoot KB2700028
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support