Lync 2013 Reports keeps loading and output will be delayed

Issue:

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

Cause:

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.

Resolution:

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

30% to 50% Discount for MCSE Certification

Reports suggest an average 9 percent salary increase immediately after receiving certification, and 29 percent increase over the long term, versus peers who are not certified. [Source: Microsoft]

Considering this market demand for certified professionals, we have associated with Simplilearn, the world?s leading professional certification provider and arranged for discounts on their certification courses, exclusively for the members of this group. Simplilearn is known for providing corporate training for companies like Deloitte, Bosch, KPMG, Dell etc.

Use coupon code MDC50 to avail 50% discounts on below mentioned courses, valid till 26th Dec, 2014:

MCSE Certification in MS Exchange Server 2013 @ $44http://goo.gl/HgBfUa

Microsoft SQL Server Certification @ $ 149 http://goo.gl/eXY3Ix

Use coupon code MDC30 to avail 30% discounts on below mentioned courses:

Installing and Configuring MS Windows Server 2012 R2 @ $62http://goo.gl/H0U6v0

Complete Microsoft SharePoint Server 2013 Suite Training @ $69http://goo.gl/iMTWwl

Complete Microsoft .NET AIO Pack (7 courses on .NET C#) @ $209http://goo.gl/yw0WI8

For any queries, write to promos.

Happy Learning!