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 ID | : | 945946 | | Last Review | : | January 8, 2008 | | Revision | : | 1.0 |
SYMPTOMSYou 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
CAUSEThis 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 RESOLUTIONTo 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.
|
Back to the top
APPLIES TO| • | Microsoft System Center Operations Manager 2007 |
Back to the top | Other Support Options- Need More Help?
Contact a Support professional by Email, Online or Phone. - Customer Service
For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more. - Newsgroups
Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.
|
|
Help and Support
