I recently had a small issue with the Monitoring Server reports – specifically, the Dashboard view returned the following error:
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.
Oh, how nice. There are numerous references on the internet to this issue, and they all involve going into SQL manager and executing stored procedures on either the LCSCDR or the QoEMetrics databases as shown.
All well and good. For the sake of completeness, here is the actual procedure outlined so you can see it. Note that the issue outlined here had both databases mentioned, I only had the one – but, I forged ahead and ran the stored procedure against both databases just for good measure.
Fail. Redid CU2 and SQL SP1 across the environment. Fail.
OK, back to UofG for some more edimication. After about 2 hours, I found this little tidbit at the bottom of a forum article: run the dbo.RtcRecreateSummaryTable procedure.
Having nothing to lose, I did this, and wala! Success. FWIW, I executed the dbo.RtcRecreateSummaryTable to both LCSCDR and QoEMetrics – but let us not complain too much, my dashboard is working again.