When running Mailbox Reports the below error is produced after 15 minutes:
"Unexpected error while attempting to read from the database.
SELECT [Organization], SUM([Mailbox Size (KB)]) AS [Mailbox Size (KB) (Total)], AVG([Mailbox Size (KB)]) AS [Mailbox Size (KB) (Avg)], SUM([Messages Stored]) AS [Messages Stored (Total)], AVG([Messages Stored]) AS [Messages Stored (Avg)], COUNT(*) AS [_Count] FROM (SELECT * FROM V_MailboxSizePerUserRecent) [_IntResult] WHERE ([Organization] = N'xxxx') GROUP BY [Organization] ORDER BY [Organization] ASC
The attached update resolves this issue. Download the update and extract it into a temp directory. Then, if you are working from the SQL Server itself, from a command prompt type: MessageStatsMigration. If you are working from another server (not the SQL Server), from a command prompt type: MessageStatsMigration SQLSERVERNAME.
(for local SQL Server): MessageStatsMigration
(for remote SQL Server): MessageStatsMigration SQLSERVERNAME
This command will also produce an output file called MessageStatsMigration.out that will contain the results of the execution and if any errors occurred.
This issue will be resolved in a future release of MessageStats.