Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Configuring Tribix for Excel Export
Abhyshek
Hi,
My configuration
BIRT - 2.5.1 (birt-report-designer-all-in-one-2_5_1)
Tribix - 2.5
POI - 3.6
Running report - I am running it via designer which opens report in BIRT Viewer and then I am trying to export to excel
OS - Windows XP
I am working with a retail company in India/Asia and we have a data warehouse on Netezza (using SAS for reporting) but for some other reports I am trying to use BIRT (I read the two books - basics & integrating BIRT) as personally I have found it very interesting.
Currently I am trying to export a sample report (with chart) to excel and for chart to be rendered in excel I am trying to configure Trbix. I am not good at eclipse and doesnt understand the plugin thing very well, but I do understand J2EE, I did following as per the readme file of Tribix -
Installation
1. Install and run Birt correctly first.
2. Extract the downloaded plugin file into the eclipse plugins directory.
3. Download Apahce POI library from apache site, put it in the /lib directory under the extracted plugin folder. (I copied the POI jars into the /lib directory of extracted plugin - org.uguess.birt.report.engine.emitter.xls_2.5.0.200907171402lib)
4. Ok, now create a report as usual and choose preview as XLS.
Now when I run the report from designer and try exporting in excel it gives a ClassNotFoundException - java.lang.ClassNotFoundException: org.apache.poi.hssf.usermodel.HSSFAnchor
Could anyone please help me idenifying the problem? when I extract the POI jar I could see this class: HSSFAnchor under the correct package path. Where is the problem? Please help.
org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
at org.eclipse.birt.report.utility.BirtUtility.makeAxisFault(BirtUtility.java:748)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:94)
at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(EngineFragment.java:318)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(AbstractBaseFragment.java:76)
at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(BirtEngineServlet.java:120)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(BaseReportEngineServlet.java:185)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.service(BaseReportEngineServlet.java:116)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:318)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:380)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:540)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:213)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
Caused by: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1065)
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:888)
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
... 27 more
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:199)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:882)
... 30 more
Caused by: java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFAnchor
at org.uguess.birt.report.engine.emitter.xls.XlsEmitter.initialize(XlsEmitter.java:100)
at org.eclipse.birt.report.engine.nLayout.LayoutEngine.initialize(LayoutEngine.java:146)
at org.eclipse.birt.report.engine.api.impl.EngineTask.initializeContentEmitter(EngineTask.java:1894)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:117)
... 32 more
Caused by: java.lang.ClassNotFoundException: org.apache.poi.hssf.usermodel.HSSFAnchor
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:494)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:398)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:105)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
... 36 more
Thanks.
Abhishek.
Find more posts tagged with
Comments
mwilliams
Hi Abhishek,
You for sure copied the poi-3.2-FINAL-20081019.jar into the /lib folder? Not a different version? I believe this is the specified version.
Abhyshek
Dear Michael,
I had copied poi-3.6-20091214.jar into the /lib folder, as it was the latest one and I couldnt find it mentioned anywhere that one should use only 3.2 version (or maybe I missed it). Now I downloaded poi-3.2-FINAL-20081019.jar and copied under /lib folder and its woring perfectly. Great.
Thanks a ton! Happy New Year.
Thanks & Regards,
Abhyshek.
mwilliams
Abhyshek,
Glad to help. Happy new year to you as well!
