nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

BIRT 4.5 XLSX Export using ExcelEmitter.TemplateFile(XLSX Export works in Designer not with Runtime)

CS_IN_TX

Exporting Report to spreadsheet with functional formulas works using Birt Designer 4.5. by setting User Property ExcelEmitter.TemplateFile. Export fails from server to reporting application when using Tomcat 7.0, java 8 and BIRT runtime 4.5. Have tried removing the MANIFEST directory from runtime jar and apache.poi jars. as suggested in <a data-ipb='nomediaparse' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=398774#c18'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=398774#c18</a> No luck. Any ideas. Thank you. 
Stack Trace
SEVERE: An error happened while running the report. Cause: 
java.lang.SecurityException: class "org.apache.poi.util.PackageHelper"'s signer information does not match signer information of other classes in the same package 
 at java.lang.ClassLoader.checkCerts(ClassLoader.java:895) 
 at java.lang.ClassLoader.preDefineClass(ClassLoader.java:665) 
 at java.lang.ClassLoader.defineClass(ClassLoader.java:758) 
 at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) 
 at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2957) 
 at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1210) 
 at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1690) 
 at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) 
 at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:204) 
 at uk.co.spudsoft.birt.emitters.excel.XlsxEmitter.openWorkbook(XlsxEmitter.java:49) 
 at uk.co.spudsoft.birt.emitters.excel.ExcelEmitter.start(ExcelEmitter.java:202) 
 at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:645) 
 at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:321) 
 at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1555) 
 at org.eclipse.birt.report.service.BirtViewerReportService.renderReport(BirtViewerReportService.java:369) 
 at org.eclipse.birt.report.service.actionhandler.BirtRenderReportActionHandler.__execute(BirtRenderReportActionHandler.java:65) 
 at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) 
 at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.doService(FramesetFragment.java:224) 
 at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.service(FramesetFragment.java:86) 
 at org.eclipse.birt.report.servlet.ViewerServlet.__doGet(ViewerServlet.java:181) 
 at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:278) 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) 
 at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 
 at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 
 at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) 
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) 
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) 
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) 
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) 
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) 
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) 
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) 
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) 
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) 
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315) 
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
 at java.lang.Thread.run(Thread.java:745)

Find more posts tagged with

Comments

CS_IN_TX

Update: Adding a jar containing the xlsx template file to tomcat and Birt 4.5 in the tomcat webapps will get me a null pointer exception. Ok. a step in the right direction....?
stack trace:
Oct 15, 2015 10:59:15 AM org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions 
SEVERE: An error happened while running the report. Cause: 
java.lang.NullPointerException 
 at uk.co.spudsoft.birt.emitters.excel.ExcelEmitter.start(ExcelEmitter.java:194) 
 at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:645) 
 at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:321) 
 at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1555) 
 at org.eclipse.birt.report.service.BirtViewerReportService.renderReport(BirtViewerReportService.java:369) 
 at org.eclipse.birt.report.service.actionhandler.BirtRenderReportActionHandler.__execute(BirtRenderReportActionHandler.java:65) 
 at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) 
 at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.doService(FramesetFragment.java:224) 
 at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.service(FramesetFragment.java:86) 
 at org.eclipse.birt.report.servlet.ViewerServlet.__doGet(ViewerServlet.java:181) 
 at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:278) 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) 
 at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) 
 at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 
 at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) 
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) 
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) 
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) 
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) 
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) 
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) 
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) 
 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) 
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) 
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315) 
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
 at java.lang.Thread.run(Thread.java:745)

JFreeman

Do you only get this behavior with: ExcelEmitter.TemplateFile?
Do you get the same behavior with other spudsoft settings such as ExcelEmitter.DisplayGridlines?
 
Instead of setting it as a user property, if you put that directly into an event in the report, such as beforeFactory, do you get the same behavior?

CS_IN_TX

Sorry for the late reply, end of year...busy.
I think this does not work because it does not work anyway in the version of spudsoft I tried. I have added a bug to spudsoft. Had to replace my machine as Window Office failed. When I was able to work on it again, locally, the export of a BIRT report to the XLSX format using a template completely failed. The output was a two sheet .XLSX with the first sheet, the template, the second sheet the output from the birt report. It was not overwritting the template at all. Switched tactics and tried exporting formulas. The formulas are created and assigned to elements in beforeFactory. These data elements have the User Properties of ExcelEmitter.Formula and ExcelEmitter.ValueAsFormula set. This did not work for Birt 4.5 out of the box. Added older version spudsoft emitter as suggested in a spudsoft bug entry and this worked great......locally. Does not work in exports of reports via tomcat. No particular errors, just fails. Still working on that one. Who knows maybe an older version of spudsoft will work......

CS_IN_TX

Update. Using an older version (uk.co.spudsoft.birt.emitters.excel_0.8.0.201307252232) of Spudsoft worked and export the formulas created in beforeFactory. That is great when using BIRT 4.5 Designer but not so great for running reports using BIRT 4.5 runtime with Tomcat 7.0. I do not know which version of spudsoft was added to the runtime jar for BIRT 4.5 but if it is the same version used for BIRT Designer 4.5, it does not work. It looks very much like I will have to replace the spudsoft version the the runtime jar. (Oh Goody) or find some sort of work around to make use the spudsoft jar version I designate instead of the one included. Is spudsoft even supposed to work with BIRT 4.5? Hints? Comments?