Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 899390 - Last Review: October 27, 2006 - Revision: 1.2
You receive a "There is no data available for this report" error message when you try to view reports by using the Microsoft Operations Manager 2005 Reporting Console
You install the Microsoft Operations Manager (MOM) 2005 Exchange Management Pack on a computer that is running Microsoft Exchange Server. Next, you click to select the
Import the Exchange Management Pack and Reports option in the MOM Administrator Console. When you try to view reports by using the MOM Reporting Console, you may receive the following error message:
There is no data available for this report
This behavior occurs because the data that the MOM scripts collect is added to the OnePoint SQL database. The Data Transformation Service (DTS) transfers the long-term data from the OnePoint SQL database to the Data Warehouse database. The reports obtain information from the Data Warehouse database.
By default, DTS is scheduled to run every day at 1:00 AM.
However, the Exchange 2003 - Collect Database Size Per Server script is scheduled to run every day at 1:55 AM. Also, the Exchange 2003 - Collect Server Information script is scheduled to run every day at 2:30 AM. Because DTS runs before these scripts run, the data that these scripts collect is not transferred to the Data Warehouse database until DTS runs the next day at 1:00 AM.
In this case, the data that the MOM scripts collect is not added to the Data Warehouse database until one day after the scripts run.
This behavior typically occurs when you try to view the following two reports in the MOM Reporting Console:
- The Exchange Database Sizes report
The Exchange Database Sizes report depends on the Report Collection - Database Size Per Server data collection rule. This rule resides in the Microsoft Exchange Server\Exchange 2003\Report Collection Rules\Database Size Analysis folder in the MOM Administrator Console. This rule runs the Exchange 2003 - Collect Database Size Per Server script. This rule runs every day at 1:55 AM. This rule generates event ID 9011 in the MOM Operators Console when the script successfully runs.
- The Exchange Server Configuration report
The Exchange Server Configuration report depends on the Report Collection - Exchange Server 2003 Configuration Information data collection rule. This rule resides in the Microsoft Exchange Server\Exchange 2003\Report Collection Rules\Exchange Server Configuration folder in the MOM Administrator Console. This rule runs the Exchange 2003 - Collect Server Information script. This rule runs every day at 2:30 AM. This rule generates event ID 9002 in the MOM Operators Console when the script successfully runs.
Note To view these reports, visit the Microsoft Operations Manager Reporting Web page, click the
Microsoft Exchange Server folder, and then click the
Exchange 2000 and 2003 Health Monitoring and Operations folder.
To resolve this problem, change the DTS scheduled task to run after the Exchange Management Pack scripts run, as follows:
- Log on to the computer that is hosting the OnePoint SQL database by using an account that has administrative permissions.
- Click Start, point to Settings, and then click Control Panel.
- Double-click Scheduled Tasks, and then double-click SystemCenterDTSTask.
- In the SystemCenterDTSTask dialog box, click the Schedule tab, enter a start time that occurs after 2:30 AM in the Start Time box, and then click OK.
For example, enter 3:00 AM in the Start time box.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate