none
Health Service errors 31551 & 2115

    Question

  • Hello,

    On my SCE 2010 server I am getting numerous errors about every minute. So far searching for a exact solution for this problem have failed. Maybe someone here have some ideas I can try out. Event viewer errors are:

    Log Name:      Operations Manager
    Source:        HealthService
    Date:          25.04.2011 16:06:34
    Event ID:      2115
    Task Category: None
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      sce.xxx

    Description:
    A Bind Data Source in Management Group SCE_MG has posted items to the workflow, but has not received a response in 599 seconds.  This indicates a performance or functional problem with the workflow.
     Workflow Id : Microsoft.Windows.Client.Win7.Computer.CollectClientPerfData
     Instance    : sce.xxx
     Instance Id : {ADE3AF33-4971-9CBC-37FA-AA9327DB7238}

    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="HealthService" />
        <EventID Qualifiers="32768">2115</EventID>
        <Level>3</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2011-04-25T13:06:34.000000000Z" />
        <EventRecordID>1796921063</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>sce.xxx</Computer>
        <Security />
      </System>
      <EventData>
        <Data>SCE_MG</Data>
        <Data>Microsoft.Windows.Client.Win7.Computer.CollectClientPerfData</Data>
        <Data>sce.xxx</Data>
        <Data>{ADE3AF33-4971-9CBC-37FA-AA9327DB7238}</Data>
        <Data>599</Data>
      </EventData>
    </Event>

    Log Name:      Operations Manager
    Source:        Health Service Modules
    Date:          25.04.2011 16:06:34
    Event ID:      31551
    Task Category: Data Warehouse
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      sce.xxx
    Description:
    Failed to store data in the Data Warehouse. The operation will be retried.
    Exception 'SqlException': XQuery [vManagedEntityProperty.PropertyXml.query()]: There is no function '{http://www.w3.org/2004/07/xpath-functions}:data()'

    One or more workflows were affected by this. 

    Workflow name: Microsoft.Windows.Client.Win7.Computer.CollectClientPerfData
    Instance name: sce.xxx
    Instance ID: {ADE3AF33-4971-9CBC-37FA-AA9327DB7238}
    Management group: SCE_MG
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Health Service Modules" />
        <EventID Qualifiers="49152">31551</EventID>
        <Level>2</Level>
        <Task>3</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2011-04-25T13:06:34.000000000Z" />
        <EventRecordID>1796921064</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>sce.xxx</Computer>
        <Security />
      </System>
      <EventData>
        <Data>SCE_MG</Data>
        <Data>Microsoft.Windows.Client.Win7.Computer.CollectClientPerfData</Data>
        <Data>sce.xxx</Data>
        <Data>{ADE3AF33-4971-9CBC-37FA-AA9327DB7238}</Data>
        <Data>SqlException</Data>
        <Data>XQuery [vManagedEntityProperty.PropertyXml.query()]: There is no function '{http://www.w3.org/2004/07/xpath-functions}:data()'</Data>
      </EventData>
    </Event>

    Monday, April 25, 2011 1:23 PM

Answers

All replies

  •  

    Hi,

     

    Thank you for posting here.

     

    Regarding the errors, please also refer to the following articles:

     

    Event ID 2115 is logged, and a management server generates an "unable to write data to the Data Warehouse" alert in System Center Operations Manager 2007

    http://support.microsoft.com/kb/945946

     

    Event ID 2115 A Bind Data Source in Management Group

    http://blogs.technet.com/b/kevinholman/archive/2008/04/21/event-id-2115-a-bind-data-source-in-management-group.aspx

     

    Getting 31552 -&gt;Exception 'SqlException': Timeout expired very frequently in SCOM server

    http://blogs.technet.com/b/sudheesn/archive/2009/07/28/getting-31552-exception-sqlexception-timeout-expired-very-frequently-in-scom-server.aspx

     

    In addition, please check the data grooming settings referring to the following post:

     

    Understanding and modifying Data Warehouse retention and grooming

    http://blogs.technet.com/b/kevinholman/archive/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming.aspx

     

    Hope this helps.

     

    Thanks.

     

    Nicholas Li

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, April 26, 2011 7:19 AM
    Moderator
  •  

    I just want to say hi and see how this is going. If you have any questions or concerns, please do not hesitate to let me know. It is my pleasure to help.

     

    Thanks, and have a great day!

     

    Nicholas Li

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, April 28, 2011 10:22 AM
    Moderator
  • After some more digging in event logs I found that I also had a problem with SQL collation. After fixing this these errors have not popped up yet, it's been about 48h so I hope that the underline problem for these errors were the collation problem.

    Thursday, April 28, 2011 10:43 AM
  • Hi,

     

    Thank you for your update.

     

    I know the error has been disappeared after fixing the SQL collation problem. I am just writing to see if the problem has been resolved. If you would like further assistance, please do not hesitate to let me know.

     

    Thanks again! Have a nice day!

     

    Nicholas Li

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Friday, April 29, 2011 6:27 AM
    Moderator
  •  

    I am just writing to say hi, and to ensure the problem has been completely resolved. If there is anything I can do to help on this issue, please feel free to let me know. I am happy to be of assistance.  

     

    Thanks!

     

    Nicholas Li

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, May 02, 2011 9:33 AM
    Moderator