Article ID: 945946 - Last Review: January 8, 2008 - Revision: 1.0

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

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}

Back to the top

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.

Back to the top

RESOLUTION

To resolve this problem, follow these steps:

On the computer that is running System Center Operations Manager, open the Operations Console.
In the navigation pane, click Administration.
Expand Security, and then click Run As Profiles.
In the Run As Profiles view, double-click Data Warehouse Account.
In the Run As Profile Properties - Data Warehouse Account properties dialog box, click the Run As Accounts tab, and then click New.
In the Run As Account list, click Data Warehouse Action Account.
In the Name list, click the management server that generated the alert.
Click OK two times.
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.
On the management server that generated the alert, restart the OpsMgr Health Service.
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.