After changing the service account that runs Messagestats the following error messages may appear in the Messagestats Application Logs or System Application logs
1. Message in the event logs:
QSchedExec Error, No subscription delivered. The following errors occurred: Error 0x80004005. LoadReportFromFile File: _Users/SAMINET%5Cexcadc\Mailboxeista\MailboxesExceedingQuota-ALL.QSRS
2. Message in Messagestats Application Logs:
Out of x files none were eligible
Tracking Log File Check: Unable to find any tracking logs.
An error occurred during the processing of a given gathering. The actual details for the error are contained in a previous log entry.
Warning: No information stores pulled from the MessageStats database.
This error is caused by the account running the subscription not being the same account used to create the report.
Messagestats My Reports get saved in the My Reports section of the User who created it. This is User Profile specific, because the account running the subscription does not have permissions to see the report in another users My Reports, it gives this error.
1. Run the subscription as the user who created the report (Go through the edit subscriptions wizard and its the 2nd to last detail that is requested in the wizard)
2. Move the reports out of my reports to anywhere else. e.g. right click on the report under my reports and click Move. Drop it under the corporate reports and reconfigure the subscriptions again using the moved report.