What could cause the mailbox gathering tasks to be hung on Reporting Aggregation?
More then one Scheduler Server Service is populating data to the database
You cannot have more then one Scheduler Server Service installed and populating the database with gathered data. This will cause deadlocks between the Scheduler Server Services and SQL Server. Please uninstall all Scheduler Server Services except for one.