Report data is not updated after a successful gathering. (4210271)

After running a gathering in the Messagestats console and seeing the gathering has completed successfully upon browsing the reports web site there is still no data or no new data in the reports.

This may occur if the MessageStats Gatherings and MessageStats Webreports are using separate databases, or if new Message Tracking Logs are not being processed by the gatherings.

Please verify that the Messagestats console and the Messagestats Web Reports are pointed at the same SQL server and Database:

1. Open the Messagestats Console.
2. Click on Database Management
3. Make note of the SQL server named in the bottom right hand corner of the screen.

Next find the QMSReports.UDL file on the local system.

1. Browse to C:\Program Files\Quest Software\MessageStats (this is the default path)
2. Find the QMSReport.UDL file in this directory.
3. Double click on this file to open it.
4. Under '1. Select or enter a server name' - make sure this SQL server name matches the one listed in the Messagestats console.
5. If it does not match change the name of the SQL server to match the one from the console.
6. Press the Test Connection button.
7. Restart the IIS service.

Re-launch the Messagestats Web Reports. You should now be seeing updated data.

If the Webreports console and MessageStats gatherings are using the same Database, ensure your daily gatherings are configured to gather current message tracking logs:

1. Open the MessageStats Console
2. Locate your daily scheduled gatherings (Daily Default Gathering recommended) by expanding the "Tasks" node.
3. Right Click the Gathering Task and Select "Properties"
4. On the Select Task Template Page of the Task Properties click "Next"
5. On the Tracking Log Date Range Page verify that either "Yeserday", "Last 3 Days", or "Last Week" is selected. (Many reports will not update properly if using a historic custom date range.), and click "Next"
6. Click "Next"
7. Adjust the task schedule if necessary on the "Task Schedule" page and click "Next"
8. Click "Next" on the "Task Logging" page
9. On the Task Credentials Page Re-Enter the Password if using a non-default account, and click "Next"
10. Click "Next"
11. Click "Next"
12. Click "Finish"
13. Right Click the Gathering Task in the MessageStats Console and choose "Run Now with Override"

Wait for the gatheirng to complete and verify that report data is now up to date