Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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 13:12 Go to next message
sidharth mv is currently offline sidharth mvFriend
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 15:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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 07:51 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mvFriend
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 08: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 12:22 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mvFriend
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 16:23 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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 14:35 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mvFriend
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 17:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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 12:09 Go to previous messageGo to next message
sidharth mv is currently offline sidharth mvFriend
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 13: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 16:55 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
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: Fri Mar 29 02:18:45 GMT 2024

Powered by FUDForum. Page generated in 0.05769 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top