Error executing java action GenerateExcelDoc

0
Hi,   When trying to execute the java action I got the following error:   Error in execution of monitored action '{"name":"MasterProceso.ACT_ExportarExcelOportunidades","type":"Microflow"}' (execution id: ba7213f0-cfef-4012-bf6b-f90d8552b22c, execution type: CLIENT_ASYNC_MONITORED) -------- java.lang.NoSuchMethodError: org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.builder()Lorg/apache/commons/io/output/UnsynchronizedByteArrayOutputStream$Builder;    at org.apache.poi.util.IOUtils.peekFirstNBytes(IOUtils.java:144)    at org.apache.poi.poifs.filesystem.FileMagic.valueOf(FileMagic.java:209)    at org.apache.poi.openxml4j.opc.internal.ZipHelper.verifyZipHeader(ZipHelper.java:143)    at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipStream(ZipHelper.java:175)    at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:130)    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:312)    at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:59)    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:289)    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:285)    at xlsreport.report.export.ExportExcel.<init>(ExportExcel.java:61)    at xlsreport.actions.GenerateExcelDoc.createExport(GenerateExcelDoc.java:202)    at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:73)    at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:30)    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:106)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:105)    at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:59)    at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:35)    at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:11)    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:38)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:32)    at scala.Option.flatMap(Option.scala:283)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:29)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAfterBreakingIfNecessary$2(MicroflowImpl.scala:167)    at scala.Option.flatMap(Option.scala:283)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:167)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:114)    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:89)    at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:687)    at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:467)    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)    at java.base/java.lang.Thread.run(Thread.java:834)   I have seen that the problem may be due to the userlib files. These are the files I have at the moment:     Thanks
asked
4 answers
0

I think you might be missing the org.apache.commons.io jar file.

Try searching for this file and download this to your userlib directory.

answered
0

As Erwin says, it looks like commons.io.<version>.jar is missing.

 

To fix this, I suggest reinstalling the Excel Exporter module from the Marketplace as it should contain this missing .jar file.

 

Good luck!

 

answered
0

Looking at the screenshot of your userlib I can see multiple versions of the same .jar files. You need to clean out duplicates, keeping only the version with the highest revision number.

 

For example, you have three versions of commons-codec.jar. Delete commons-codec-commons-codec-1.15 and commons-codec-1.15, and keep commons-codec.1.16.0 as it's the version with the highest revsion number.

 

Do the same for the other modules in your userlib.

 

I hope this helps, good luck!

answered
0

Maybe this can help https://www.youtube.com/watch?v=K1FYgziVXCM

answered