Microsoft Knowledge Base Email Alertz

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

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











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

SYMPTOMS

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

CAUSE

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.

MORE INFORMATION

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.

RESOLUTION

To resolve this problem, change the DTS scheduled task to run after the Exchange Management Pack scripts run, as follows:
  1. Log on to the computer that is hosting the OnePoint SQL database by using an account that has administrative permissions.
  2. Click Start, point to Settings, and then click Control Panel.
  3. Double-click Scheduled Tasks, and then double-click SystemCenterDTSTask.
  4. 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
Keywords: 
kbtshoot kbprb KB899390
       

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