In the past week, we migrated the backend database to another server (old server being retired).
Prior to the migration, I set the collection interval to infinite (don't collect). The DB was migrated by the DBA team. When I re-entered the new connection information, the reports started working again.
Problem is solved but still would love tips/tricks on how to better debug this issue.
Thanks,
-Tim