The Reporting Aggregation task can hang at 50% for a long period of time or not finish.
The MessageStats database indexes are not in an optimal state.
Create and deploy a SQL Reindex job to reindex the MessageStats database on a regular basis.
Note: Before you reindex the database, ensure that no MessageStats Consoles attached to the database are currently writing information to the database. If you use the Database Management Utility while a MessageStats Console is writing to the database, you risk corrupting your database.
After the Reindex job completes, open the MessageStats console and re-run a gathering and the Reporting Aggregation task will complete. The length of the time to complete will depend on the size of your database.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center