locked
Event ID 29106 RRS feed

  • Question


  • Hi,

      I am having various issues with trying to get one of my servers to be monitored with SCE2007 SP1. I have uninstalled and reinstalled the agent on the computer but when it tries to contact SCE 2007 I receive the following error.

    Any ideas?

    Event ID 29106

    The request to synchronize state for OpsMgr Health Service identified by "c48bbdd0-0b47-bc80-9d56-cd4c3ddbacac" failed due to the following exception "Microsoft.EnterpriseManagement.Common.DataAccessLayerException: Invalid column name PerformanceCounterObject_1ACC50C3_CE60_075D_18CF_BC3CAC665124 for query MTV_SelectProperty_d3d42c94-b72c-509c-f06d-2e0c866b4087.
       at Microsoft.EnterpriseManagement.Mom.DataAccess.QueryDefinition.GetColumnDefinitionBySourceColumnName(String sourceColumnName, Int32 resultSetIndex)
       at Microsoft.EnterpriseManagement.Mom.DataAccess.QueryDefinition.GetColumnDefinitionBySourceColumnName(String sourceColumnName)
       at Microsoft.Mom.ConfigService.DataAccess.DatabaseAccessor.QueryInstanceProperties(ReadOnlyCollection`1 instances)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.CommunicationHelper.StateSyncRequestTask.ConfigurationItems.Instances.CollectPublicProperties(ReadOnlyCollection`1 identities, IConfigurationDataAccessor dataAccessor)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.CommunicationHelper.StateSyncRequestTask.ConfigurationItems.ConfigurationItemCollection`2.CollectPublicProperties(IConfigurationDataAccessor dataAccessor)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.CommunicationHelper.StateSyncRequestTask.ConfigurationItems..ctor(StateContext stateContext, IConfigurationDataAccessor dataAccessor)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.CommunicationHelper.StateSyncRequestTask.CreateResponse(Managers managers)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.Managers.Synchronize(OnDoSynchronizedWork onDoSynchronizedWork)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.CommunicationHelper.StateSyncRequestTask.Execute(Managers managers)
       at Microsoft.Mom.ConfigService.Engine.ConfigurationEngine.CommunicationHelper.StateSyncRequestTask.Run(Guid source, String cookie, Managers managers, IConfigurationDataAccessor dataAccessor, Stream stream, IConnection connection)".

    For more information, see Help and Support Center at

    Tuesday, February 9, 2010 10:27 AM

Answers

All replies

  • Hello,

    Please refer to the following thread which has the solution/steps to follow for the same Event ID 29106 issue:
    http://social.technet.microsoft.com/Forums/en-US/systemcenter/thread/01cd4140-a880-4792-be1d-930ab5d1958a

    Hope this would be helpful.

    Thanks, Anshu
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Yog Li Wednesday, February 17, 2010 9:04 AM
    Wednesday, February 10, 2010 10:23 PM
  • Hi Dwelldon,

    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as "Answered" as the previous steps should be helpful for many similar scenarios.

    In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.

    Thanks,


    Yog Li - MSFT
    Wednesday, February 17, 2010 9:05 AM