Error while importing the excel file in Mendix 9.1.1 version

7
Hello Everyone,  I am getting this error while importing the excel file at the point of startImportByTemplate java action in Mendix 9.1.1 version. Can anyone suggest me some way to resolve this error. Error in execution of monitored action '{"name":"ExcelImporter.IVK_ImportTemplateDocument","type":"Microflow"}' (execution id: 7dc5bca8-aa54-4402-a285-010e85eac1c0, execution type: CLIENT_ASYNC_MONITORED)   --------   java.lang.IncompatibleClassChangeError: Found class org.apache.poi.util.POILogger, but interface was expected at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:436) at org.apache.poi.util.IOUtils.closeQuietly(IOUtils.java:471) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:247) at excelimporter.reader.readers.ExcelXLSXDataReader.readData(ExcelXLSXDataReader.java:29) at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:370) at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:120) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:54) at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:25) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:70) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.scala:25) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:80) at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:19) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:79) at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:35) 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:31) at scala.Option.flatMap(Option.scala:283) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:28) 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:46) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:70) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.scala:25) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:50) at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:19) at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:50) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:47) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.scala:25) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:64) at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:672) at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:431) 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) Thanks in advance.
asked
5 answers
3

H Vignesh,

Add the latest org.apache.poi.util.POILogger jar from this link and Synch it, test once

https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml

And also make sure , version of poi-ooxml and poi jars should be the same.

answered
2

Hi Vignesh Kannan,

Download the previous version (Excel Importer) by replacing the existing module. Let me know if it works.

Thanks,

Vignesh Rajan.

answered
0

Any updates abouts this error? For me the option worked to change it from xlsx to xls but that is not a futureproof solution

answered
0

I had this issue also before with xlsx files.

Try to remove all the .jar files in the userlib folder which also have a .jar.ExcelImporter.RequiredLib file and download the excelimporter again. (dont remove when another module has used the same jar file).

 

answered
-1

Have you upgraded an older version of Excel Importer to the current version – 9.0.3?

If you have, did you see in the release notes that you need to manually remove older versions of the Apache POI libraries? 


“We have upgraded the apache poi libraries. If you are upgrading this module from an older version, make sure to manually locate and remove versions of the Apache POI libraries that are older than 4.1.2 from the userlib folder.”

If you aren’t sure which ones are which, delete all the poi libraries from userlib, and then reinstall the module from the Marketplace which should recreate the correct versions for you.

Good luck

answered