when you try to run the User activity report for 24 Hrs. time frame, the reports keeps loading and output will be delayed.
I have been working with a Lync Enterprise Edition deployment where we have been getting the error below. I have been able to work around it manually by running the SQL query mentioned in the error. Eventually the error would return when you click on the Dashboard
Report processing stopped because too many rows in summary tables are missing in the call detail recording (CDR) database. To resolve this issue, run dbo.RtcGenerateSummaryTables on the LcsCDR database.
Report processing stopped because too many rows in summary tables are missing in the Quality of Experience (QoE) database. To resolve this issue, run dbo.RtcGenerateSummaryTables on the QoEMetrics database
This is caused by the SQL Server Agent Service (Instance Name) is not running by default and is set to manual. If you look in SQL Server Management Studio you will see that the Stored Procedure for this automatic process is there it is just not running.
Execute those Store procedure manually or Change the configuration of the service so that it is set to automatic and start the service. Remember if you have a SQL Mirror configured you will need to do the same thing to the other server in the mirror. This goes for SQL clustering as well.
You will no longer get the error on the dashboard since the SQL Server Agent service will run the stored procedure as designed. There is no specific documentation stating that we need to ensure this service is started so make sure you add this to your installation documentation