Error when running Mailbox Reports: "Unexpected error while attempting to read from the database. (12575)

When running Mailbox Reports the below error is produced after 15 minutes:

"Unexpected error while attempting to read from the database.

Timeout expired

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

(0x80040217)"

WORKAROUND

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.

Usage:

(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.

STATUS

This issue will be resolved in a future release of MessageStats.