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.
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.
You can see below that the service is set to manual
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.