Cannot export to Excel

Johnathon Warren shared this problem 3 months ago
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)

Best Answer
photo

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

Comments (4)

photo
1

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

photo
1

Done.

photo
1

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

photo
1

Thank you very much for your help <3

photo