Websphere+Birt 3.7: Report generation aborts after 1 minute. Timeout? [message #728397] |
Fri, 23 September 2011 08:11 |
Paul Ramsden Messages: 84 Registered: February 2011 Location: BW, Germany |
Member |
|
|
I have a really ugly query which takes around 3 minutes to complete. In the report designer it runs fine and displays results. However, on the server I see the 'Processing' message but this disappears after exactly 1 minute. I have looked in the logs on the server but can see nothing there.
It is almost certainly a timeout issue - but where? Does BIRT have a timeout on queries? Is it a web server timeout?
[Update]
I just tried it out in my local tomcat server and it returns after 45 seconds and displays the first page of 248. I can then page up and down and the response time is fast. Not sure why Websphere takes so much longer. In the preview window the request took 2-3 minutes but then displayed the whole result set.
[Updated on: Fri, 23 September 2011 09:11] Report message to a moderator
|
|
|
|
|
Re: Websphere+Birt 3.7: Report generation aborts after 1 minute. Timeout? [message #728653 is a reply to message #728538] |
Fri, 23 September 2011 15:33 |
|
Paul,
You did not set a query timeout in the report did you?
In the viewer.properties file what is your session timeout set to?
Can you set the log level to FINEST and post the log?
Jason
On 9/23/2011 8:59 AM, Paul Ramsden wrote:
> Hi Jeanbaptiste
>
> Tomcat works fine for me - it's just Websphere which timesout. I could
> not see any error messages in the output files on WAS. I'm guessing it
> is a transport timeout as it is always exactly 60 seconds. I've tweaked
> all the settings I can find....
|
|
|
|
Re: Websphere+Birt 3.7: Report generation aborts after 1 minute. Timeout? [message #729883 is a reply to message #729861] |
Tue, 27 September 2011 08:09 |
Paul Ramsden Messages: 84 Registered: February 2011 Location: BW, Germany |
Member |
|
|
Well, it's back again.
I updated a report and restarted the server. Here is the log (FINEST)
27.09.2011 10:05:41 null null
INFO: Found JDBC driverinfo extension: driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
27.09.2011 10:05:41 null null
INFO: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.hive.HiveDriver, connectionFactory=null
27.09.2011 10:05:41 null null
INFO: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver, connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory
27.09.2011 10:05:41 null null
INFO: Loaded JDBC driver class in class path: com.microsoft.sqlserver.jdbc.SQLServerDriver
27.09.2011 10:07:13 null null
INFO: load font config in wsjar:file:/D:/WebSphere70/AppServer/profiles/AppSrv/installedApps/Cell/BirtViewer_war.ear/WASBirtViewer.war/WEB-INF/lib/org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar!/fontsConfig.xml cost 16ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/share/fonts/zh_CN/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in C:/windows/fonts cost:47ms
27.09.2011 10:07:13 null null
INFO: register fonts in /var/lib/defoma/x-ttcidfont-conf.d/dirs/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_5/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/zh_CN.GB18030/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/ar/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/zh.GBK/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/X11R6/lib/X11/fonts/tt cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/share/fonts/ko/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/X11R6/lib/X11/fonts/truetype cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/X11R6/lib/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/X/lib/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/hi_IN.UTF-8/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/X11R6/lib/X11/fonts/OTF cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_15/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_13/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/share/fonts/ja/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in g:/WINNT/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in g:/windows/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/X11R6/lib/X11/fonts/TTF cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/KOI8-R/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in e:/WINNT/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/zh_TW.BIG5/X11/fonts/TT cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/th_TH/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in e:/windows/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_8/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/euro_fonts/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_2/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/zh/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/share/fonts/zh_TW/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/zh_TW/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/share/fonts/truetype cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/ko.UTF-8/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/ko/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/ja/X11/fonts/TT cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/ru.ansi-1251/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/zh_HK.BIG5HK/X11/fonts/TT cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/share/fonts/default/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in f:/WINNT/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in f:/windows/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_9/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in d:/WINNT/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in C:/WINNT/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in d:/windows/fonts cost:0ms
27.09.2011 10:07:13 null null
INFO: register fonts in /usr/openwin/lib/locale/iso_8859_7/X11/fonts/TrueType cost:0ms
27.09.2011 10:07:13 null null
INFO: load font config in wsjar:file:/D:/WebSphere70/AppServer/profiles/AppSrv/installedApps/Cell/BirtViewer_war.ear/WASBirtViewer.war/WEB-INF/lib/org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar!/fontsConfig_win32.xml cost 0ms
27.09.2011 10:07:13 null null
INFO: load font config in wsjar:file:/D:/WebSphere70/AppServer/profiles/AppSrv/installedApps/Cell/BirtViewer_war.ear/WASBirtViewer.war/WEB-INF/lib/org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar!/fontsConfig_pdf.xml cost 0ms
Not much to see!
Paul
[Updated on: Tue, 27 September 2011 08:11] Report message to a moderator
|
|
|
Re: Websphere+Birt 3.7: Report generation aborts after 1 minute. Timeout? [message #730097 is a reply to message #729883] |
Tue, 27 September 2011 15:26 |
|
Paul,
Does this happen with all long running reports or just the one?
Jason
On 9/27/2011 4:09 AM, Paul Ramsden wrote:
> Well, it's back again.
>
> I updated a report and restarted the server. Here is the log (FINEST)
>
> 27.09.2011 10:05:41 null null
> INFO: Found JDBC driverinfo extension:
> driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
> 27.09.2011 10:05:41 null null
> INFO: Found JDBC driverinfo extension:
> driverClass=org.eclipse.birt.report.data.oda.hive.HiveDriver,
> connectionFactory=null
> 27.09.2011 10:05:41 null null
> INFO: Found JDBC driverinfo extension:
> driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver,
> connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory
>
> 27.09.2011 10:05:41 null null
> INFO: Loaded JDBC driver class in class path:
> com.microsoft.sqlserver.jdbc.SQLServerDriver
>
> Not much to see!
>
> Paul
|
|
|
Powered by
FUDForum. Page generated in 0.04487 seconds