Monday, May 20, 2013

Lync 2013 Monitoring Dashboard Error

When you click on Dashboard in your lync reports you get the following errors: 

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.

To solve this issue:

logon to the SQL Server Management Studio
Browse to Databases > QoEMetrics > Programmability > Stored Procedures
Rightclick dbo.RtcGenerateSummaryTables and choose Execute Stored Procedure...

Do this steps for both the QoEMetrics and LcsCDR databases.