Reporting Server Dashboard issue

Lync/S4B Reporting Server gives you following error

Error

1. 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.

1. 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.

>

 

Solution

Make sure SQL server agent is running on Monitoring servers.
Set the service start-up  to automatic to make sure service will be up and running all the time.

Open SQL Server Management Studio --> Go to QOEMetrics --> Programmability --> Stored Procedure --> go to  dbo.RtcGenerateSummaryTables --> Right click --> Execute stored procedure.

Do same for LcsCDR.

And check.