nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Blank report after a long time in web viewer

dsrikanth

Hi to all, 
 
In my report i have a query which is taking a long time to execute at database (lot of joins and functions). 
I am viewing the report in Web viewer, while running the report it displaying the progress bar, but after some time(1hr.) it goes blank. The query may take more than 1hr time to execute, but after that web viewer doesn't displays anything on the screen. Is the session expires? It is not displaying any errors even. 
 
I am getting this error when i am running this report in tomcat 6.0 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>java.lang.IllegalStateException: The viewing session has expired.
at org.eclipse.birt.report.session.ViewingSession.checkExpired(ViewingSession.java:105)
at org.eclipse.birt.report.session.ViewingSession.getImageTempFolder(ViewingSession.java:92)
at org.eclipse.birt.report.session.ViewingSessionManager$ViewingSessionWrapper.getImageTempFolder(ViewingSessionManager.java:113)
at org.eclipse.birt.report.service.ReportEngineService.createHTMLRenderOption(ReportEngineService.java:586)
at org.eclipse.birt.report.service.ReportEngineService.createRenderTask(ReportEngineService.java:1644)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1514)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.doRenderPage(BirtChangeParameterActionHandler.java:82)
at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:103)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Unknown Source)</pre>
 
Pls help me. 
Thanks in advance, 
Srikanth d.

Find more posts tagged with

Comments

mwilliams

In your viewer.properties file, is the value of viewer.session.timeout set to 0 so that it doesn't time out?

dsrikanth

Thanks for the reply Williams,

This is the properties file that what i am using for the application. Event though it is giving the error.

Regards,
Srikanth D.

mwilliams

If you run a simple report that doesn't take much time, it runs without the error?

dsrikanth

Thanks for the reply Williams, 
 
Running the simple report is not my requirement, I need to run reports on huge enterprise data, so that i need to maintain session for a long time. Why birt is taking lot of memory to run the report? My tomcat server shutting down because of insufficient memory(OutOfMemory) while processing the crosstab report. I have a 2GB of ram and i configured tomcat like 
 
Initial Memory Pool : 512 MB 
Maximum Memory Pool : 1024 MB 
 
I am attaching the expected pdf output file, csv and report files. Pls help to get desired result (Left columns headers). I am using tomcat 6.0 (not installer), birt 2.6. Pls tell me how to configure tomcat to use max memory. 
 
Regards, 
Srikanth

mwilliams

My reason for having you try a simple report was to see if this was an issue that was happening regardless of the report complexity and amount of data. How many MB of data are you processing?

dsrikanth

Thanks Williams,

I tried simple report, it works fine. Whenever it processing 1 month data(More than 86MB csv export) It stops working and taking lot of memory for a long time.

Regards,
Srikanth D

pratim

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="77874" data-time="1306964439" data-date="01 June 2011 - 02:40 PM">
If you run a simple report that doesn't take much time, it runs without the error? </blockquote>
 
Hi williams, 
Even i am seeing the same behavior, for me reports run properly from Eclipse BIRT dev setup, where viewer.properties file has viewer.session.timeout = 0. 
 
But when i run report from using tomcat server, screen goes blank for report that takes longer time to appear. 
 
Any help?

mwilliams

What is your output type you're trying to have? HTML? PDF? Paginated Viewer?

When you run from the designer, what are you doing to run the report?

When you run it from Tomcat, what URL are you using?

Let me know.

pratim

Hi William,

Output type is HTML.

when i run from the designer i used, "view report in webviewer"

When i am running from Tomcat, the url is "http://xx.****.xx.xx/frameset?__document=documents\ReportTmp_admin_336651721385798&__svg=false&__user=admin&__dbUrl=jdbc:postgresql://127.0.0.1:5432/collector"

Also, did some google and found this "http://www.eclipse.org/forums/index.php?t=tree&goto=259184&S=5f3bc28cf3c97fa4b05c9ebd2ff7a817#page_top"
But i did not get where can i found and set the value of "readTimeOut property".

Thanks.

mwilliams

That was a property of their websphere server, so if you're not using websphere, this probably won't help. If you look in the web.xml under apache -> conf -> web.xml, there is a "session-timeout" value that can be set. In my web.xml, it is set to 30 minutes. You could try increasing this to see if it helps.

cbond

I know this is an old post, but I might add some suggestions for others with similar issues.
 
Just a note when running in webviewer you are rendering an rptdocument. An output has not been chosen yet.
 
What I have found in the case that you are using a fixed layout, the rptdocument itself may perform very poorly.
 
In the case that you may be eventually using Excel, I would suggest using an auto layout. I have seen 65% reductions in rptdocument size by making this adjustment.