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 (899390)

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:

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.