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

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

SYMPTOMS

You experience the following symptoms on a management server computer that is running Microsoft System Center Operations Manager 2007:
  • The management server generates one or more alerts that resemble the following:
    Performance data collection process unable to write data to the Data Warehouse

    Performance data collection process unable to write data to the Data Warehouse. Failed to store data in the Data Warehouse. Exception 'SqlException': Management Group with id '9069F7BD-55B8-C8E8-1CF9-4395F45527E2' is not allowed to access Data Warehouse under login 'DOMAIN\Action_Account' One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData Instance name: dataWarehouseServer.domain.com Instance ID: {48936EE3-4E3E-BEE1-8C09-AFDAB8ECF236} Management group: Management Group Name
  • The following event is logged in the Operations Manager event log on the management server:

    Event Type: Warning
    Event Source: HealthService
    Event Category: None
    Event ID: 2115
    Date: date
    Time: time
    User: N/A
    Computer: ManagementServerName
    Description: A Bind Data Source in Management Group Management Group Name has posted items to the workflow, but has not received a response in 1712 seconds. This indicates a performance or functional problem with the workflow. Workflow Id : Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData Instance : ManagementServerName.domain.com Instance Id : {C7FDDE2A-E0AA-4B80-70DE-1D50D9965221}

CAUSE

This issue may occur if the management server does not have accounts that are specified for its data warehouse "Run As" profiles. This issue is more likely to affect a secondary management server.

RESOLUTION

To resolve this problem, follow these steps:
  1. On the computer that is running System Center Operations Manager, open the Operations Console.
  2. In the navigation pane, click Administration.
  3. Expand Security, and then click Run As Profiles.
  4. In the Run As Profiles view, double-click Data Warehouse Account.
  5. In the Run As Profile Properties - Data Warehouse Account properties dialog box, click the Run As Accounts tab, and then click New.
  6. In the Run As Account list, click Data Warehouse Action Account.
  7. In the Name list, click the management server that generated the alert.
  8. Click OK two times.
  9. Follow steps 4 through 8 to assign the appropriate Run As account to the following profiles:
    • Data Warehouse Configuration Synchronization Reader Account
    • Data Warehouse Report Deployment Account
    • Data Warehouse SQL Server Authentication Account
    For each profile, select the Run As account that matches the name of the Run As profile. For example, make the following assignments:
    • Assign the Data Warehouse Configuration Synchronization Reader Account to the Data Warehouse Configuration Synchronization Reader Account profile.
    • Assign the Data Warehouse Report Deployment Account to the Data Warehouse Report Deployment Account profile.
    • Assign the Data Warehouse SQL Server Authentication Account to the Data Warehouse SQL Server Authentication Account profile.
  10. On the management server that generated the alert, restart the OpsMgr Health Service.
  11. In the Operations Manager event log on the management server, verify that event ID 31554 events are logged.

    Note Event ID 31554 indicates that the monitor state has changed to Healthy. This change resolves the alert.

Properties

Article ID: 945946 - Last Review: January 8, 2008 - Revision: 1.0
APPLIES TO
  • Microsoft System Center Operations Manager 2007
Keywords: 
kberrmsg kbtshoot kbprb KB945946

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