Stored Procedures and Lync

After upgrading my demo environment from Lync RC to Lync RTM, I found that my monitoring server role displayed the following error when trying to go to the dashboard …

IVC-0406

Thanks to Wesley B, I was able to fix the error by running the suggested Stored Procedures Smile

Opened SQL Management Studios, drilled down to LcsCDR, Programmability, Stored Procedures, and there searched for the one mentionned in the error message: dbo.RtcGenerateSummaryTables…

IVC-0408

IVC-0409

Right-clicked the stored procedure, and selected Execute Stored Procedure…

IVC-0410

Clicked OK…

 

IVC-0411

And that’s it Smile

IVC-0412

Did the same for the QoEMetrics database, and after that, when going to the dashboard, it worked Smile

 

IVC-0414

IVC-0413

Ilse