Excel Export Error - Generate Doc - Java action error

0
Problem Summary I'm experiencing an issue with the 'Generate Excel Doc' action in Mendix. When I try to generate a report, it throws an error with the following stacktrace: java.lang.NoSuchMethodError: 'org.apache.commons.io.input.UnsynchronizedByteArrayInputStream$Builder org.apache.commons.io.input.UnsynchronizedByteArrayInputStream.builder()' at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1424) at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1410) at xlsreport.report.export.ExportExcel.writeData(ExportExcel.java:169) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:160) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:30) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:73)   Context and Error Message The error occurs when trying to generate an Excel report. The XML data works fine when sent through Postman, and I've imported the SSL certificate and certificate into the App Settings certificate tab. Question Could you please help me resolve this issue and understand what's causing the NoSuchMethodError?
asked
3 answers
0

This usually happens if you have older versions of the required .jar files in your userlib.

 

To fix this, look in your userlib and see if you have any .jar files with the same name. If you do, delete the ones with the lowest version numbers, keeping the highest only.

 

It is also worth looking in your vendorlib to see if you have a version there. If you do, delete the versions in the userlib.

 

I hope this helps. Good luck!

answered
1

Hi!

Have you had a look at your userlib folder? Perhaps you have missing or duplicate JARs in which case you should remove the old ones and restart your app.

answered
0

Are you using the Excel Document Export Overview page? Did you create a template there for the export? If so, please make sure that the configuration is correct, especially the input object.

answered