Category
Report Builder
Product Version
8.0
Cannot export to Excel
Resolved
Application version: 8.0.1
Build: 20190320
Whenever I try to export to Excel, Yellowfin tells me it has a System Error, and logs me out. This appears to happen with any export to Excel that I run.
Checking the log, I see this error:
13-May-2019 14:55:49.232 SEVERE [http-nio-8080-exec-24] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [action] in context with path [/yf] threw exception [Servlet execution threw an exception] with root cause java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellTypeEnum()Lorg/apache/poi/ss/usermodel/CellType; at com.hof.report.render.XlsReportRenderer.G(XlsReportRenderer.java:1920) at com.hof.report.render.XlsReportRenderer.H(XlsReportRenderer.java:1880) at com.hof.report.render.XlsReportRenderer.render(XlsReportRenderer.java:783) at com.hof.report.component.ReportComponent.accept(ReportComponent.java:205) at com.hof.report.render.XlsRenderer.render(XlsRenderer.java:202) at com.hof.report.render.XlsRenderer.render(XlsRenderer.java:66) at com.hof.mi.web.action.MIReportOutputAction.A(MIReportOutputAction.java:1265) at com.hof.mi.web.action.MIReportOutputAction.execute(MIReportOutputAction.java:272) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.hof.servlet.BrowserHeaderFilter.doFilter(BrowserHeaderFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Files:
Capture.PNG
The same problem 
Thanks for the call earlier Jonathan.
As discussed, you've renamed your ROOT folder to YF and after the upgrade the ROOT folder got re-created, where the new XLSX exporter libraries went.
After manually copying across the \lib files to the YF folder and deleting the old ones, the export then worked again.
For reference, these were the 'poi' libraries.
I'll close this off, though if you ever want to look at the upgrade process again , so you don't get the ROOT folder each time, please let me know.
Regards,
David
Thanks for the call earlier Jonathan.
As discussed, you've renamed your ROOT folder to YF and after the upgrade the ROOT folder got re-created, where the new XLSX exporter libraries went.
After manually copying across the \lib files to the YF folder and deleting the old ones, the export then worked again.
For reference, these were the 'poi' libraries.
I'll close this off, though if you ever want to look at the upgrade process again , so you don't get the ROOT folder each time, please let me know.
Regards,
David
Hey Jonathan,
Can you do me a favor and make a copy of the \yellowfin\appserver\webapps\root\web-inf\lib folder and upload it to ftp.yellowfin.bi, just let me know once it's up.
Sounds like there could be an issue with the libraries, but I want to test here locally so I can add/remove files in the hopes of an easy fix.
Thanks,
David
Hey Jonathan,
Can you do me a favor and make a copy of the \yellowfin\appserver\webapps\root\web-inf\lib folder and upload it to ftp.yellowfin.bi, just let me know once it's up.
Sounds like there could be an issue with the libraries, but I want to test here locally so I can add/remove files in the hopes of an easy fix.
Thanks,
David
Replies have been locked on this page!