Eclipse Community Forums: BIRT » Error when trying to open report with charts

Home » Archived » BIRT » Error when trying to open report with charts

Error when trying to open report with charts [message #686487]

Wed, 22 June 2011 06:41

Eclipse User

Hi,

I am trying to open a report that has three data sets from two data sources in it.
If I try it in viewer on my design machine it works fine, but when I export it to Tomcat server and try to access it through url it returns data in a part where the table is, but two other parts (charts) don't show up.

Any idea? Thanks!

What I get is this error message (sorry for pasting this long data set, but I didn't know what you may need):

The following items have errors:

Chart (id = 135):
- CREATE_EXTENSION_FAIL
CREATE_EXTENSION_FAIL ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: CREATE_EXTENSION_FAIL
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1199)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1046)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:579)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:163)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:661)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:284)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1545)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)
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:616)
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:616)
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:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)
Caused by: org.eclipse.birt.chart.exception.ChartException: CREATE_EXTENSION_FAIL
at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1257)
at org.eclipse.birt.chart.util.PluginSettings.getDevice(PluginSettings.java:633)
at org.eclipse.birt.chart.api.ChartEngine.getRenderer(ChartEngine.java:119)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.prepareDeviceRenderer(ChartReportItemPresentationBase.java:1137)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.generateRenderObject(ChartReportItemPresentationBase.java:894)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:860)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1023)
... 66 more
Caused by: org.eclipse.birt.core.framework.FrameworkException: CREATE_EXTENSION_FAIL
at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:39)
at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1253)
... 73 more
Caused by: org.eclipse.core.runtime.CoreException: Plug-in "org.eclipse.birt.chart.device.extension" was unable to instantiate class "org.eclipse.birt.chart.device.image.PngRendererImpl".
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.throwException(RegistryStrategyOSGI.java:194)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:188)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:904)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:35)
... 74 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.eclipse.birt.chart.device.image.PngRendererImpl
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at java.lang.Class.newInstance0(Class.java:372)
at java.lang.Class.newInstance(Class.java:325)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:184)
... 78 more

Chart (id = 132):
- CREATE_EXTENSION_FAIL
CREATE_EXTENSION_FAIL ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: CREATE_EXTENSION_FAIL
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1199)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1046)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:579)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:163)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:661)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:284)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1545)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)
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:616)
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:616)
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:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)
Caused by: org.eclipse.birt.chart.exception.ChartException: CREATE_EXTENSION_FAIL
at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1257)
at org.eclipse.birt.chart.util.PluginSettings.getDevice(PluginSettings.java:633)
at org.eclipse.birt.chart.api.ChartEngine.getRenderer(ChartEngine.java:119)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.prepareDeviceRenderer(ChartReportItemPresentationBase.java:1137)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.generateRenderObject(ChartReportItemPresentationBase.java:894)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:860)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1023)
... 66 more
Caused by: org.eclipse.birt.core.framework.FrameworkException: CREATE_EXTENSION_FAIL
at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:39)
at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1253)
... 73 more
Caused by: org.eclipse.core.runtime.CoreException: Plug-in "org.eclipse.birt.chart.device.extension" was unable to instantiate class "org.eclipse.birt.chart.device.image.PngRendererImpl".
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.throwException(RegistryStrategyOSGI.java:194)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:188)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:904)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:55)
at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:35)
... 74 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.eclipse.birt.chart.device.image.PngRendererImpl
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at java.lang.Class.newInstance0(Class.java:372)
at java.lang.Class.newInstance(Class.java:325)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:184)
... 78 more

Re: Error when trying to open report with charts [message #686625 is a reply to message #686487]

Wed, 22 June 2011 11:59

Eclipse User

Is the deployment version the same as the designer? How do you have the viewer deployed?

Jason

Re: Error when trying to open report with charts [message #687614 is a reply to message #686625]

Wed, 22 June 2011 16:54

Eclipse User

I was using the same file for the designer and the viewer on the server. I can see another report fine (it has only a single table in it which lists data from database), but in this case I have a table and two charts next to it. Table can be seen fine, but I am getting errors related to charts.

Here is the procedure I was following in order to deploy viewer on the Tomcat:

Once you have Tomcat installed, you have to add Commons Logging and JTDS JDBC driver in order to make it work. Unzip the Commons Logging package and copy listed files
commons-logging-1.1.1
commons-logging-1.1.1-javadoc
commons-logging-1.1.1-sources
commons-logging-adapters-1.1.1
commons-logging-api-1.1.1
commons-logging-tests

(you can see them highlighted in the picture below) to the \lib directory of your Tomcat installation (Example: C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib). To make our JTDS JDBC connection working we need jtds-1.2.5 JAR file to be put into Tomcat's driver directory (tomcat6/webapps/birt-viewer/WEB-INF/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127/drivers.)

Now we need to install BIRT Viewer into Tomcat. Locate the "Web Viewer Example" directory under the birt-runtime directory you downloaded. Copy the "Web Viewer Example" directory to the webapps directory of your Tomcat installation and rename it to something like "birt-viewer". Restart Tomcat, and now test it by going to http://localhost8080/managerhtml.
You should be able to see birt-viewer listed as an application. Click it and you should see the confirmation that the BIRT viewer has been installed. Look at the example to confirm that installation is working correctly.

Deploying Reports

After you are done with report design it is easy to deploy it to the server. All that needs to be done is to copy your_report.rptdesign file from the workspace where your project resides to the birt-vewer directory of your Tomcat installation. Once it is done you will be able to access it through a URL that should have this format:
http://server_host:8080/birt-viewer/frameset?__report=your_report.rptdesign
You can embed this link and make your reports accessible from wherever.

Re: Error when trying to open report with charts [message #687913 is a reply to message #687614]

Thu, 23 June 2011 10:01

Eclipse User

Can you remove your webviewer install and just copy the WebViewerExample folder from the runtime download to the the tomcat/webapps directory? BTW you may also want to try the 3.7 runtime which was released yesterday.

Jason

Re: Error when trying to open report with charts [message #689765 is a reply to message #687913]

Tue, 28 June 2011 06:07

Eclipse User

Hi Jason,

what is the upgrade process for BIRT? Is there an update option in BIRT, installer, or just remove the folder (save somewhere .rptdesign files..) and unpack the new one?

Thanks!

Re: Error when trying to open report with charts [message #689922 is a reply to message #689765]

Tue, 28 June 2011 11:05

Eclipse User

For the designer you can use the update manager
http://www.eclipse.org/birt/phoenix/build/

For the runtime it is manual. Old reports should still run in the new
engine so just swap the runtime folders.

Jason

On 6/28/2011 6:07 AM, nlajka wrote:
> Hi Jason,
>
> what is the upgrade process for BIRT? Is there an update option in BIRT,
> installer, or just remove the folder (save somewhere .rptdesign files..)
> and unpack the new one?
>
> Thanks!

Re: Error when trying to open report with charts [message #691437 is a reply to message #689922]

Fri, 01 July 2011 09:04

Eclipse User

Hello Jason,

This folder: \tomcat\webapps\Birt\WEB-INF\platform\plugins\org.eclipse. birt.report.data.oda.jdbc_2.6.1.v20100909\drivers

doesn't exist in 3.7 runtime webviever. Where to put drivers and common logging in this case?

Thanks!

Re: Error when trying to open report with charts [message #691529 is a reply to message #691437]

Fri, 01 July 2011 12:39

Eclipse User

Just needs to be in the webapp classpath. So you can put it in
WEB-INF/lib or in the app servers common lib.

Jason

On 7/1/2011 9:04 AM, nlajka wrote:
> Hello Jason,
>
> This folder: \tomcat\webapps\Birt\WEB-INF\platform\plugins\org.eclipse.
> birt.report.data.oda.jdbc_2.6.1.v20100909\drivers
>
> doesn't exist in 3.7 runtime webviever. Where to put drivers and common
> logging in this case?
>
> Thanks!

Re: Error when trying to open report with charts [message #692414 is a reply to message #686487]

Mon, 04 July 2011 07:53

Eclipse User

Using 3.7 doesn't make a difference.
The worst part is that now even old reports I've moved to the 3.7 viewer don't work anymore.

Thanks.

Re: Error when trying to open report with charts [message #692432 is a reply to message #692414]

Mon, 04 July 2011 08:31

Eclipse User

what I am trying to do is to have a table listing data from one data set(pulling data from data source 'a'), a chart displaying data from another data set (pulling data from data source 'b'), in a way to improvise a dashboard. When I try it in a designer it works fine, but when I export it to a viewer on a Tomcat server it fails with error showed above.

Re: Error when trying to open report with charts [message #692936 is a reply to message #692432]

Tue, 05 July 2011 09:20

Eclipse User

Does the attached TopNPercent report work in your 3.7 deloyed viewer?
When you deploy the 3.7 viewer to tomcat all you should have to do is
copy the WebViewerExample directory from the runtime download to the
apache-tomcat-version\webapps directory. Nothing needs to be removed.
Add your db drivers to the WebViewerExample/web-inf/lib directory.

Jason

On 7/4/2011 8:31 AM, nlajka wrote:
> what I am trying to do is to have a table listing data from one data
> set(pulling data from data source 'a'), a chart displaying data from
> another data set (pulling data from data source 'b'), in a way to
> improvise a dashboard. When I try it in a designer it works fine, but
> when I export it to a viewer on a Tomcat server it fails with error
> showed above.

Attachment: TopNPercent.rptdesign
(Size: 145.30KB, Downloaded 390 times)

Re: Error when trying to open report with charts [message #693118 is a reply to message #692936]

Tue, 05 July 2011 16:18

Eclipse User

I did exactly what you told me regarding drivers, and even added common logging.

When I try to run TopNPercent report it would let me put parameters in. I would leave default values and click ok.
It gives me error box saying:

Exception: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
Show Exception Stack Trace

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1106)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1553)
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(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
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:616)
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:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:318)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1547)
... 46 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.eclipse.birt.chart.device.image.PngRendererImpl
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at org.eclipse.birt.core.framework.jar.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:46)
at org.eclipse.birt.core.framework.eclipse.EclipseConfigurationElement.createExecutableExtension(EclipseConfigurationElement.java:35)
at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:1253)
at org.eclipse.birt.chart.util.PluginSettings.getDevice(PluginSettings.java:633)
at org.eclipse.birt.chart.api.ChartEngine.getRenderer(ChartEngine.java:119)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.prepareDeviceRenderer(ChartReportItemPresentationBase.java:1152)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.generateRenderObject(ChartReportItemPresentationBase.java:901)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:867)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1023)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:579)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:163)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:681)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:294)
... 47 more

Re: Error when trying to open report with charts [message #693393 is a reply to message #693118]

Wed, 06 July 2011 07:35

Eclipse User

Jason,

I tried TopNPercent report in designer and it works fine in preview and when I click on "View Report in Web Viewer" button.
However, after exporting it to Tomcat it fails in web browser.
What I have found odd is that if I try test.rptdesign that came with Viewer it works fine, but if I try test1.rptdesign it fails (I would choose "1" for parameter2 value).

Re: Error when trying to open report with charts [message #693662 is a reply to message #693393]

Wed, 06 July 2011 20:22

Eclipse User

Do you have any other jars in the web-inf/lib other than the ones in the
webviewer?

Jason

On 7/6/2011 7:35 AM, nlajka wrote:
> Jason,
>
> I tried TopNPercent report in designer and it works fine in preview and
> when I click on "View Report in Web Viewer" button.
> However, after exporting it to Tomcat it fails in web browser. What I
> have found odd is that if I try test.rptdesign that came with Viewer it
> works fine, but if I try test1.rptdesign it fails (I would choose "1"
> for parameter2 value).

Re: Error when trying to open report with charts [message #693828 is a reply to message #693662]

Thu, 07 July 2011 05:24

Eclipse User

I can't follow you right now.

If you think of /var/lib/tomcat6/webapps/birt-viewer/WEB-INF/lib
there are 84 jar files, and none of them has been added by me.

I have left the old version and changed it's name by adding 2.6 /var/lib/tomcat6/webapps/birt-viewer2.6/WEB-INF/lib

and it contains some 37 jar files. I added common logging files to it only (I didn't add them to the latest version this time. First time when I installed the 3.7 version I did add common logging files too, but report still didn't work).

Is there any other place where I should look for jar files?

Thank you for your help.

Re: Error when trying to open report with charts [message #694499 is a reply to message #693828]

Fri, 08 July 2011 13:47

Eclipse User

Take a look at this thread:
http://www.birt-exchange.org/org/forum/index.php/topic/12886-chart-not-loading-birt-viewer-unix/?=newpost&t=12886

Jason

On 7/7/2011 5:24 AM, nlajka wrote:
> I can't follow you right now.
>
> If you think of /var/lib/tomcat6/webapps/birt-viewer/WEB-INF/lib
> there are 84 jar files, and none of them has been added by me.
>
> I have left the old version and changed it's name by adding 2.6
> /var/lib/tomcat6/webapps/birt-viewer2.6/WEB-INF/lib
>
> and it contains some 37 jar files. I added common logging files to it
> only (I didn't add them to the latest version this time. First time when
> I installed the 3.7 version I did add common logging files too, but
> report still didn't work).
>
> Is there any other place where I should look for jar files?
>
> Thank you for your help.

Re: Error when trying to open report with charts [message #695340 is a reply to message #686487]

Mon, 11 July 2011 10:26

Eclipse User

Adding JAVA_OPTS="$JAVA_OPTS -Dprogram.name=birtviewer -Djava.awt.headless=true"

to /usr/share/tomcat6/bin/catalina.sh

what they suggested didn't make a difference.
We are getting the same error.

Re: Error when trying to open report with charts [message #695497 is a reply to message #695340]

Mon, 11 July 2011 17:53

Eclipse User

It looks like there is the same problem. Charts not rendering on UNIX system.
Is it possible that GUI (API that it contains) is all we need? We will try it...

http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=/com.ibm.tivoli.tcr.doc_21/tstcr_charts_not_render.html

Charts in reports do not appear
Symptoms
When rendering a report, charts do not appear and an error appears in the log files. The log file is in the directory TCR_install_dir/profiles/TIPProfile/logs in the form YYYY MM DD hh mm ss.log, where YYYY is the year, MM is the month, DD is the day, hh is the hour, mm is the minute, and ss is the second. The file reports the following error: May 19, 2010 2:09:43 PM org.eclipse.birt.chart.exception.ChartException logThis WARNING: Exception org.eclipse.birt.chart.exception.ChartException: CREATE_EXTENSION_FAIL at org.eclipse.birt.chart.util.PluginSettings.getPluginXmlObject(PluginSettings.java:987)at org.eclipse.birt.chart.util.PluginSettings.getDisplayServer(PluginSettings.java:545)at org.eclipse.birt.chart.device.swing.SwingRendererImpl.init(SwingRendererImpl.java:130)at org.eclipse.birt.chart.device.swing.SwingRendererImpl.<init>(SwingRendererImpl.java:122)at org.eclipse.birt.chart.device.image.JavaxImageIOWriter.<init>(javaxImageIOWriter.java:123)at org.eclipse.birt.chart.device.image.PngRendererImpl.<init>(PngRendererImpl.java:18).
The error appears on UNIX operating system.

Causes
BIRT requires a graphical user interface API to render charts. This error appears only on UNIX-like systems, where a graphical user interface is an optional component. It does not appear on Windows, where the Win32 API always contains the graphical user interface API.
Resolving the problem
Install the X system. Below is a list of packages that help for SUSE Linux (for other distributions, similar packages are available:
Linux SLES (9.156.46.78) [10:44] root /usr/lib # rpm -qa | grep xorg
xorg-x11-server-6.9.0-50.58
xorg-x11-fonts-75dpi-6.9.0-50.58
xorg-x11-6.9.0-50.58
xorg-x11-fonts-100dpi-6.9.0-50.58
xorg-x11-Xvnc-6.9.0-50.58
xorg-x11-driver-video-radeon-6.6.3-0.19
xorg-x11-server-glx-6.9.0-50.58
xorg-x11-libs-6.9.0-50.58
xorg-x11-driver-video-nvidia-6.9.0-46.51
xorg-x11-fonts-scalable-6.9.0-50.58
xorg-x11-libs-32bit-6.9.0-50.58
xorg-x11-Xnest-6.9.0-50.58
xorg-x11-driver-video-6.9.0-46.51

[Updated on: Mon, 11 July 2011 18:07] by Moderator

Re: Error when trying to open report with charts [message #695594 is a reply to message #695497]

Tue, 12 July 2011 00:26

Eclipse User

What is the app name? Is it birtviewer?

Jason

On 7/11/2011 5:53 PM, nlajka wrote:
> I know that this is not BIRT, but it looks like there is the same
> problem. Charts not rendering on UNIX system.
> Can anybody say if something similar can help us (our viewer is on
> Debian system) and what?
>
> http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=/com.ibm.tivoli.tcr.doc_21/tstcr_charts_not_render.html
>

Re: Error when trying to open report with charts [message #695639 is a reply to message #695594]

Tue, 12 July 2011 04:10

Eclipse User

I have changed its default name WebViewerExample to birt-viewer.

Re: Error when trying to open report with charts [message #695658 is a reply to message #695639]

Tue, 12 July 2011 05:11

Eclipse User

Finally!

Doing apt-get install xorg

did the job!

Thank you Jason for your help!

Re: Error when trying to open report with charts [message #696292 is a reply to message #695658]

Wed, 13 July 2011 12:03

Eclipse User

Thanks for posting your fix.

Jason

On 7/12/2011 5:11 AM, nlajka wrote:
> Finally!
> Doing apt-get install xorg
>
> did the job!
>
> Thank you Jason for your help!

Re: Error when trying to open report with charts [message #697033 is a reply to message #696292]

Fri, 15 July 2011 07:11

Eclipse User

You are welcome.

After seeing how much effort you put into helping us, this at least what I can do in order to payback to the community.
I know how many times I've seen people asking for help, find a solution and leave it only for themselves. There are so many of just starting, and I hate when I see (especially in open source community) that seniors or those that know just assume that we know what they know....

Oh well, I am venting out a bit since it was so frustrating for me, but I know that this is one of the ways to learn Very Happy

)))))

Once again, thank you Jason for all your help!

P.S. I already asked, and nobody answered, is there a place where we can find some gauges that we can incorporate into reports? Free, of course Smile

Re: Error when trying to open report with charts [message #698007 is a reply to message #697033]

Mon, 18 July 2011 11:07

Eclipse User

Sorry for the delay in response. I was out on vacation. I do not know
of any examples of free gauges, but if you could find some flash gauges
you should be able to incorporate them using a text element which allows
embedded html.

Jason

On 7/15/2011 7:11 AM, nlajka wrote:
> You are welcome.
>
> After seeing how much effort you put into helping us, this at least what
> I can do in order to payback to the community.
> I know how many times I've seen people asking for help, find a solution
> and leave it only for themselves. There are so many of just starting,
> and I hate when I see (especially in open source community) that seniors
> or those that know just assume that we know what they know....
>
> Oh well, I am venting out a bit since it was so frustrating for me, but
> I know that this is one of the ways to learn :d)))))
>
> Once again, thank you Jason for all your help!
>
> P.S. I already asked, and nobody answered, is there a place where we can
> find some gauges that we can incorporate into reports? Free, of course :)

Re: Error when trying to open report with charts [message #699260 is a reply to message #698007]

Thu, 21 July 2011 04:23

Eclipse User

Thank you Jason,

I'll try.

Have a good one.

Previous Topic:	BIRT RCP designer - Section 508 information
Next Topic:	Data Set as input to a second Data Set FROM Clause

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 17:45:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter