Launching soon: The world's first vendor agnostic bug scrubLearn more & join waitlist
OPERATIONAL DEFECT DATABASE
...
...
After upgrading to 9.4.1, adhoc excel/xml reports fail. CSV reports are successful.In Voyence.conf, the following errors are present:WARN : 2016-07-21 06:00:06,889: SchedulerServiceImpl: Job finished executing: jobId=12345ERROR: 2016-07-21 07:00:04,329: ReportWriterFactory: org.apache.poi.hssf.record.UnicodeString.<init>(Ljava/lang/String;)VERROR: 2016-07-21 07:00:05,289: AdhocReportServiceImpl: Exception received running reportjava.lang.RuntimeException: java.lang.NoSuchMethodError: org.apache.poi.hssf.record.UnicodeString.<init>(Ljava/lang/String;)V at com.voyence.reporting.adhoc.export.ReportWriterFactory.writeReportToDisk(ReportWriterFactory.java:115) at com.voyence.reporting.adhoc.task.AdhocEmailReportTask.populateReportResult(AdhocEmailReportTask.java:92) at com.voyence.reporting.adhoc.task.AbstractAdhocReportTask.run(AbstractAdhocReportTask.java:40) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) 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)Caused by: java.lang.NoSuchMethodError: org.apache.poi.hssf.record.UnicodeString.<init>(Ljava/lang/String;)V at org.apache.poi.hssf.usermodel.HSSFRichTextString.<init>(HSSFRichTextString.java:51) at com.voyence.reporting.adhoc.export.XlsReportWriter.createDocument(XlsReportWriter.java:82) at com.voyence.reporting.adhoc.export.ReportWriterFactory.writeReportToDisk(ReportWriterFactory.java:102) ... 7 more
poi-2.0-final-20040126.jar enables support for porting (read and write) XML/Excel data using java. In some situations, there is a more current version of the poi jar in the same directory that causes conflict at runtime.
To resolve the issue, take the following steps:Run: service tomcat stop mv /usr/tomcat/apache-tomcat-8.0.23/webapps/web/WEB-INF/lib/poi-2.0-final-20040126.jar /usr/tomcat/apache-tomcat-8.0.23/webapps/web/WEB-INF/lib/poi-2.0-final-20040126.jar.OLD service tomcat start If the changes do not resolve the issue, revert the changes and follow up with your support engineer: service tomcat stop mv /usr/tomcat/apache-tomcat-8.0.23/webapps/web/WEB-INF/lib/poi-2.0-final-20040126.jar.OLD /usr/tomcat/apache-tomcat-8.0.23/webapps/web/WEB-INF/lib/poi-2.0-final-20040126.jar chmod tomcat:tomcat /usr/tomcat/apache-tomcat-8.0.23/webapps/web/WEB-INF/lib/poi-2.0-final-20040126.jar service tomcat start