topic Re: Custom Reports takes ages in General Topics

Custom Reports takes ages

kalyanram.piratla — Tue, 07 May 2013 15:34:07 GMT

Greetings All,

I am presently running PanOS 5.0.4 on a PA-500 HA. When I try generating a custom report for "URL Log" for a period of 7 days for Top 50 grouped by Top 50 groups with the URL consisting of porn and category not equal to web-advertisements, it takes ages to generate the report i.e. approx. an hour and then when I try to export in either PDF or CSV format, the browser just hangs.

I have tried all the browsers available. I had this issue initially with PanOS 5.0.0. Under the impression that the OS was relatively new, I kept upgrading till 5.0.4 but with no luck.

I then restarted the Log Receiver, then the management server for no fun.

Any one else has such problems? Any ideas or thoughts?

Many Thanks

Kind Regards,

Kalyan

Re: Custom Reports takes ages

Jamiefitzgerald — Tue, 07 May 2013 18:21:56 GMT

I would say schedule the report instead of doing it "Run now". For there you can either have it emailed or it will just sit on the hard-drive and you can access it the next day for download. There is more overhead in creating the PDF than the csv or xml, so if you are having problems, try to export in the other formats. Hope this helps. Thank you,

~Jamie

Re: Custom Reports takes ages

mario11584 — Tue, 07 May 2013 22:48:01 GMT

Would you by chance know why the email scheduler won't send these reports? I have a ticket open with support but they can't seem to figure it out. It's actually been open since early this year. Just trying to reach out and get some ideas.

Re: Custom Reports takes ages

kalyanram.piratla — Wed, 08 May 2013 07:03:12 GMT

Not really helpful Jamie.

If there is more overhead in creating the PDF then, can you please explain why is it a sweet and simple process for the same report on a different PA-500 running version 4.1.11? These reports that are being generated on the fly are on purpose as they are requested every now and then. I can't go back to the Management and say, we will hand it over to you tomorrow, specially when PAN allows us to generate reports on the fly.

And it is not just about PDF, it is the same with CSV and XML!

Cheers

Kalyan

Re: Custom Reports takes ages

NGS_SOC — Wed, 08 May 2013 08:56:52 GMT

Version 5.0.x has some performace issues on 500 and 2000 series. If the dataplane has high cpu utilization I suggest the ram upgrade available for 500 devices, .

Also with my 500 devices (4.1.12) sometimes I need to restart them in order to re-gain management plane usability.

Re: Custom Reports takes ages

Jamiefitzgerald — Mon, 13 May 2013 04:22:38 GMT

Kalyan,

I am sorry you did not find the information useful. I am trying to offer suggestions to help get around the issue. Another workaround might be, to offer a report of the top 5 URLs by 50 groups for a shorter time period immediately and then offer the top 500 the next day.

The reason why it might work on a different PA-500 could be that there is a lot less traffic on it. There could be many other factors that could lead to one firewall producing the report and another not producing the report. Or as NGS mentioned, it could be the system is under heavy load and could use a memory upgrade.

Overall, I am sorry that you are having this issue, and we are working on how we can improve run now reports.

Thank you,

~Jamie

Re: Custom Reports takes ages

NGS_SOC — Mon, 13 May 2013 08:04:25 GMT

Apart from PA-500 specific problem, another operation could be tried in order to quickly obtain reports.

Exporting the postgress logdb from PA-500 and importing it to a VM-100 (even not licensed) should provide the results your are looking for.

scp export logdb to userabc@1.2.4.3:c/a/b/c

scp import logdb from userabc@1.2.4.3:c/a/b/c

I wanted to try these operations some weeks ago in may labs and now I schedule for the next week.

Re: Custom Reports takes ages

ktm530russ — Wed, 22 May 2013 16:03:11 GMT

Hi, I am experiencing the same issue, on a PA2020 pair, since upgrading to 5.0 (currently at 5.0.4). The reports run fine (I am running a 30 day report on "online-personal-storage") even if it takes a while.

When trying to export (pdf, csv, xml) a new browser page starts, and sits, and sits, then eventually times out. I DID get ONE .pdf file that did export, one time, not sure why that worked...

Scheduling the report has the same issue also, the reports do not get emailed, pulling up the reports also cannot export them to any format.

I currently have 3 reports needing to be generated and distributed, clients are waiting....

Update: The Email scheduling and Scheduled reports had been cleared on the appliance, so this portion is unknown for me at this time. I have set this up to run and email, so should have another status tomorrow.

One report for the above shows for April 30th, this report cannot be exported using any format.

Message was edited by: Russel Smith (Clarifying Scheduling status)

Re: Custom Reports takes ages

ktm530russ — Fri, 24 May 2013 22:13:23 GMT

The scheduled report came through email, (PDF), but still cannot download the created report from the device.