Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Failed to open the report document(When I load a report on report viewer, its throwing the Failed to open the report document error.)
Failed to open the report document [message #903192] Wed, 22 August 2012 09:12 Go to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Hello Jason,

I have a report which is processing a huge data. There are multiple charts in it. Its a kind of dashboard. When I click on the link, the processing, please wait.. dialogue will run for more than 2 minutes and then throw the following error.


org.eclipse.birt.report.service.api.ReportServiceException: Failed to open the report document.
Hide Exception Stack Trace
Stack Trace:

org.eclipse.birt.report.service.api.ReportServiceException: Failed to open the report document.
   at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1114)
   at org.eclipse.birt.report.service.ReportEngineService.openReportDocument(ReportEngineService.java:511)
   at org.eclipse.birt.report.service.BirtViewerReportService.openReportDocument(BirtViewerReportService.java:269)
   at org.eclipse.birt.report.service.BirtViewerReportService.getPageCount(BirtViewerReportService.java:704)
   at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:138)
   at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
   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.handleGetPage(BirtDocumentProcessor.java:87)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:601)
   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(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:601)
   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:641)
   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
   at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)
Caused by: org.eclipse.birt.report.engine.api.EngineException: Failed to open the report document.
   at org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.loadCoreStreamHeader(ReportDocumentReader.java:241)
   at org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.(ReportDocumentReader.java:176)
   at org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.(ReportDocumentReader.java:150)
   at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDocument(ReportEngineHelper.java:483)
   at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDocument(ReportEngineHelper.java:459)
   at org.eclipse.birt.report.engine.api.impl.ReportEngine.openReportDocument(ReportEngine.java:645)
   at org.eclipse.birt.report.service.ReportEngineService.openReportDocument(ReportEngineService.java:505)
... 51 more
Caused by: java.io.FileNotFoundException: /core
   at org.eclipse.birt.core.archive.compound.ArchiveFileV3.lockEntry(ArchiveFileV3.java:163)
   at org.eclipse.birt.core.archive.compound.ArchiveFile.lockEntry(ArchiveFile.java:443)
   at org.eclipse.birt.core.archive.compound.ArchiveReader.lock(ArchiveReader.java:137)
   at org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.loadCoreStreamHeader(ReportDocumentReader.java:210)
... 57 more



The above exception is throwing When I am running this in Frameset mode. Follow the code:
frameset?__report=dashboard.rptdesign&__overwrite=false


If I am running the dashboard in run mode as in the below code, there is no error in the browser or in the server ~/birt/logs
run?__report=dashboard.rptdesign&__overwrite=false


Please help me out in this critical condition.

Thanks in advance,
Sidharth
Re: Failed to open the report document [message #903233 is a reply to message #903192] Wed, 22 August 2012 11:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

What version of BIRT are you using? Can you post the report?

Jason

On 8/22/2012 9:12 AM, sidharth mv wrote:
> Hello Jason,
> I have a report which is processing a huge data. There are multiple
> charts in it. Its a kind of dashboard. When I click on the link, the
> processing, please wait.. dialogue will run for more than 2 minutes and
> then throw the following error.
>
>
> org.eclipse.birt.report.service.api.ReportServiceException: Failed to
> open the report document.
> Hide Exception Stack Trace
> Stack Trace:
>
> org.eclipse.birt.report.service.api.ReportServiceException: Failed to
> open the report document.
> at
> org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1114)
>
> at
> org.eclipse.birt.report.service.ReportEngineService.openReportDocument(ReportEngineService.java:511)
>
> at
> org.eclipse.birt.report.service.BirtViewerReportService.openReportDocument(BirtViewerReportService.java:269)
>
> at
> org.eclipse.birt.report.service.BirtViewerReportService.getPageCount(BirtViewerReportService.java:704)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:138)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
>
> 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.handleGetPage(BirtDocumentProcessor.java:87)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:601)
> 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(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:601)
> 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:641)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>
> at
> org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
>
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
> at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
>
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>
> at java.lang.Thread.run(Thread.java:722)
> Caused by: org.eclipse.birt.report.engine.api.EngineException: Failed to
> open the report document.
> at
> org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.loadCoreStreamHeader(ReportDocumentReader.java:241)
>
> at
> org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.(ReportDocumentReader.java:176)
>
> at
> org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.(ReportDocumentReader.java:150)
>
> at
> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDocument(ReportEngineHelper.java:483)
>
> at
> org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDocument(ReportEngineHelper.java:459)
>
> at
> org.eclipse.birt.report.engine.api.impl.ReportEngine.openReportDocument(ReportEngine.java:645)
>
> at
> org.eclipse.birt.report.service.ReportEngineService.openReportDocument(ReportEngineService.java:505)
>
> ... 51 more
> Caused by: java.io.FileNotFoundException: /core
> at
> org.eclipse.birt.core.archive.compound.ArchiveFileV3.lockEntry(ArchiveFileV3.java:163)
>
> at
> org.eclipse.birt.core.archive.compound.ArchiveFile.lockEntry(ArchiveFile.java:443)
>
> at
> org.eclipse.birt.core.archive.compound.ArchiveReader.lock(ArchiveReader.java:137)
>
> at
> org.eclipse.birt.report.engine.api.impl.ReportDocumentReader.loadCoreStreamHeader(ReportDocumentReader.java:210)
>
> ... 57 more
>
>
> The above exception is throwing When I am running this in Frameset mode.
> Follow the code:
> frameset?__report=dashboard.rptdesign&__overwrite=false
>
> If I am running the dashboard in run mode as in the below code, there is
> no error in the browser or in the server ~/birt/logs
> run?__report=dashboard.rptdesign&__overwrite=false
>
> Please help me out in this critical condition.
>
> Thanks in advance,
> Sidharth
Re: Failed to open the report document [message #908346 is a reply to message #903233] Wed, 05 September 2012 03:51 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

BIRT Run time is 2.6

The files are


76.74.255.168:8080/Downloads/res_dash_prod.rptdesign
76.74.255.168:8080/Downloads/res_library_prod.rptlibrary

[Updated on: Wed, 05 September 2012 04:12]

Report message to a moderator

Re: Failed to open the report document [message #908460 is a reply to message #908346] Wed, 05 September 2012 08:22 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Hello Jason,

One more update on this. This dashboard consists of more than one chart. There is a section for Growth Trends. If I remove that and run the dashboard. It works fine, even though takes little more time. Also I tried running only the Growth trends as a separate report. Which was not working. So I find a trouble there. Either the query need to be optimized or some tweaks in the time out parameters of MySql Server or BIRT need to be checked.

1. In BIRT what is the default time out for a data set or for a report?

2. How to cache a huge report(millions of records) which is repeatedly accessing. __overwrite=false is not working it seems. any other alternate way?

--Sid
Re: Failed to open the report document [message #908604 is a reply to message #908460] Wed, 05 September 2012 12:23 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

On the query time out, edit the data set and look at the property
binding entry. There should be a query time out in seconds setting.

On caching: When you run the report the first time specify a
__document=yourrptdocname.rptdocument in the url. When you run in later
you should be able to omit the __report= parameter and only specify the
__document parameter.

Jason

On 9/5/2012 8:22 AM, sidharth mv wrote:
> Hello Jason,
>
> One more update on this. This dashboard consists of more than one chart.
> There is a section for Growth Trends. If I remove that and run the
> dashboard. It works fine, even though takes little more time. Also I
> tried running only the Growth trends as a separate report. Which was not
> working. So I find a trouble there. Either the query need to be
> optimized or some tweaks in the time out parameters of MySql Server or
> BIRT need to be checked.
> 1. In BIRT what is the default time out for a data set or for a report?
>
> 2. How to cache a huge report(millions of records) which is repeatedly
> accessing. __overwrite=false is not working it seems. any other
> alternate way?
>
> --Sid
Re: Failed to open the report document [message #909669 is a reply to message #908604] Fri, 07 September 2012 10:35 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Hello Jason,

I am little confused in your reply. I will give an example how I am accessing the report through URL.

localhost:8080/birt/run?__report=dashboard.rptdesign&__overwrite=false

So, as per your suggestion the URL should look like as follows...

localhost:8080/birt/run?__report=dashboard.rptdesign&__document=dashboard.rptdesign

and next time when we run the same report the URL should look like below..

localhost:8080/birt/run?__document=dashboard.rptdesign

Is this what you meant?

Thanks
sidharth
Re: Failed to open the report document [message #909749 is a reply to message #909669] Fri, 07 September 2012 13:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Sidharth

/run does not creae a rptdocument. That needs to be done with a /frameset mapping.

Jason
Re: Failed to open the report document [message #911832 is a reply to message #909749] Wed, 12 September 2012 08:09 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Hello Jason,

Thank you for your suggestions and insights. It worked well.

Kudos..!!!

I did it in this way...

For caching the report>> context-path/frameset?__report=report.rptdesign&__document=report.tptdocument

And to render the cached report>> context-path/run?__document=report.rptdocument

It was great!!

And,

1. Is there a way to setup a cronjob to run this caching? Because the report needs to be refreshed, may be in every hour. If yes, how?

2. For over writing the rptdocument, 'context-path/frameset?__report=report.rptdesign&__document=report.tptdocument&__overwrite=true' will work?



Thanks,
Sidharth

[Updated on: Wed, 12 September 2012 09:30]

Report message to a moderator

Re: Failed to open the report document [message #912489 is a reply to message #911832] Thu, 13 September 2012 12:55 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

1 - take a look at:
http://stackoverflow.com/questions/10867779/how-to-configue-cron-job-for-jsp-page
I would use curl

2 - That should work.

Jason
Previous Topic:Export Feature
Next Topic:BIRT timeout render
Goto Forum:
  


Current Time: Tue Jul 29 08:47:38 EDT 2014

Powered by FUDForum. Page generated in 0.02311 seconds