Focal Point
[CLOSED] Reports taking long time to run

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/575107945

October 13, 2010, 03:46 PM
kpiracha
[CLOSED] Reports taking long time to run
I have a report which used to take 10mins to run but now it is taking 2hrs to run.

We recently upgrade from JDE 8.10 to JDE 9.

I am not sure if that is the issue.

When I run the report and check the status under Agents, the FOCUS/External IO stays at 0/0.

since I am new the WebFOCUS, I am not sure what troubleshooting steps I need to take.

thanks,

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.9
Windows 2003
HTML, Plain Text
October 13, 2010, 04:38 PM
Waz
What is your data source, is it an RDBMS ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

October 14, 2010, 10:36 AM
Arif
quote:
t is your data source, is it an RDBMS ?

Has there been any change in your IIS or Apachi server? I had this problem. I bounced my Apachi service; but yoour problem is little different. How long ago did you update your JAVA? Usually low response time can be because of garbage collection interval.


WebFOCUS 7.6.10
Windows
HTML
October 14, 2010, 10:48 AM
kpiracha
Actually there are only couple of report not all.


WebFOCUS 7.6.9
Windows 2003
HTML, Plain Text
October 14, 2010, 04:00 PM
Waz
You have not given us much information to go on.

With this sort of issue, the more information about your data source and the program, the better.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!