Eclipse Community Forums: BIRT » Failed to open the report document

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.)

Show: Today's Messages :: Show Polls :: Message Navigator

Failed to open the report document [message #903192]

Wed, 22 August 2012 09:12

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

Report message to a moderator

Re: Failed to open the report document [message #903233 is a reply to message #903192]

Wed, 22 August 2012 11:33

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Failed to open the report document [message #908346 is a reply to message #903233]

Wed, 05 September 2012 03:51

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

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

Report message to a moderator

Re: Failed to open the report document [message #908604 is a reply to message #908460]

Wed, 05 September 2012 12:23

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Failed to open the report document [message #909669 is a reply to message #908604]

Fri, 07 September 2012 10:35

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

Report message to a moderator

Re: Failed to open the report document [message #909749 is a reply to message #909669]

Fri, 07 September 2012 13:42

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Failed to open the report document [message #911832 is a reply to message #909749]

Wed, 12 September 2012 08:09

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

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	Export Feature
Next Topic:	BIRT timeout render

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 18:07:13 EDT 2013