Saturday, August 11, 2018
Reporting Server Dashboard issue
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.
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.
