Post APM 2.5 upgrade - APM: Daily Application Availability reports will not run

Hi all,

After what was thought a successful APM upgrade to v2.5 we've recently found that APM specific reports in one of the report groupings on the web console will no longer run. The web console just appears to hang and the report selected does not display.

The group of reports affected is: APM: Daily Application Availability and the 3 subsequent reports that will not run are: Application Availability - Last Month / This Month / This Year.

All other APM reports (within different groups) still run fine.

I've also attempted to run the same reports in Report Writer itself, but I can't query nor preview them. Again, other APM reports are viewable from within Report Writer. I've done a direct comparison on the build of the affected reports to the same reports on an earlier installation of APM, and no configuration differences exist.

Has anyone else experienced any issues with default reports after running their upgrade?

Any info would be appreciated.

Find more posts tagged with

upgrade

apm_2.5

report

Accepted answers

All comments

qle

I just ran an "Application Availability - Last Month" report in Report Writer without a problem. Have you tried to update the report schema?

Ezeqiel

Cheers for the reply qle, but an update of the report schema was carried out post-install , and I've since done it again and still experiencing the issue.

Oliver_White

Hi Ezeqiel,

try this and see if it works.

Open the APM report in questions and show the SQl query ( click Report -> Show SQL ). Copy this query and create a new report as an Advanced SQL Report.

Paste the copied SQL statement and run query in order to see if you get a result. Save this report under a separate name and test it from the website. Hopefully this work around has helped.

If not, submit a ticket for our support and we will get back to you as soon as possible.

Kind Regards

Oliver White

Ezeqiel

Cheers for the reply Oliver,

I've raised a low priority support ticket to have this looked into.

I attempted the steps you'd outlined and found that I could run the query from inside Report Writer, but it takes 3.5mins - 4mins to generate the report.

Saved it and tried from the web console, timeout after 6mins and no report.

I'll post back if and when I get a solution.