"Data Cannot be Updated in Data Warehouse" error after the new Root Management Server Promotion

Author: Ka Lung Lai MVP

Community Solutions Content Disclaimer

View products that this article applies to.

Expand all | Collapse all

SUMMARY

After the Recovery of the Operations Manager 2007 RMS. You will get the error indicate that the data cannot be updated in data warehouse.

Back to the top

When you completed the promotion for a new Root Management Server on the existing Management Server. You will see the Critical Error Icon on the New Promoted Root Management Server and there are the errors indicated that the data cannot be updated in data warehouse in the Health Explorer of the New Promoted Root Management Server.

Back to the top

CAUSE

This issue is caused by the new Root Management Server does not have accounts specified for its Data Warehouse run as profiles.

Back to the top

RESOLUTION

To resolve this problem, please follow these steps:

1. Open Administration in the System Center Operations Manager 2007 Operations Console.
2. Under Security, click Run As Profiles.
3. In the Run As Profiles view, double-click the run as profile named Data Warehouse Account, and then click the Run As Accounts tab.
4. Click New.
5. In the Run As Account box, select Data Warehouse Action Account.
6. In the list of computers, select the management server that is generating the alert.
7. Click OK twice.
8. Repeat steps 3-7 for the following three accounts run as profiles:
Data Warehouse Configuration Synchronization Reader Account
Data Warehouse Report Deployment Account
Data Warehouse SQL Server Authentication Account
In each case, select the run as account that matches the name of the run as profile. For example, the run as profile named "Data Warehouse Configuration Synchronization Reader Account" uses the run as account named "Data Warehouse Configuration Synchronization Reader Account."
9. Restart the OpsMgr Health Service on the management server that is generating the alert.
10. In the Operations Manager event log on the management server, verify that events with ID 31554 are logged. These event will change the state of the monitors to healthy, which will resolve the alerts.

Back to the top

APPLIES TO

Microsoft Operations Manager 2000 Enterprise Edition
Microsoft Operations Manager 2000 Service Pack 1

Back to the top

kbpubmvp kbpubtypecca kbhowto KB555959

Back to the top

COMMUNITY SOLUTIONS CONTENT DISCLAIMER

MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.

Back to the top