Hello! Recently I've seen the following message on numerous systems when going to the Reports & Dashboards page, mostly on 9.6
This seems to be happening pretty often especially after a restart. The reporter page does eventually work after waiting past 10 minutes. My question is what would cause the reporter to take so long to initialize? About 300 alarms were created in the last 24 hours and the alarms table itself only has about 300,000 records so I don't think the number of alarms is the issue. What else can we check to find a possible root cause? Thank you very much in advance!
My main guess would be services. Especially on MySQL systems, SLASPConnection (the process hosting this report module) requires quite some time to initialize its info for all of the services.
Correct. Mainly the startup performance is impacted. If I remember correctly, a set of SQL queries is required per service to initialize certain info.
Thank you for the info, Wouter! So the amount of services would affect the reporter performance?