Smarts NCM: Unable to genrate ad-hoc report after upgrade to 9.4.1

Products

• VMware Smart Assurance

Issue/Introduction

Symptoms:


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=12345
ERROR: 2016-07-21 07:00:04,329: ReportWriterFactory: org.apache.poi.hssf.record.UnicodeString.<init>(Ljava/lang/String;)V
ERROR: 2016-07-21 07:00:05,289: AdhocReportServiceImpl: Exception received running report
java.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
 

Environment

VMware Smart Assurance - NCM

Cause

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.

Resolution

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