Excel Import Error

0
After upgrading to mendix version 9.24.12,  I am getting below error at the runtime while importing the excel Error in execution of monitored action '{"name":"ModuleExtensions.IVK_ImportTemplateDocument","type":"Microflow"}' (execution id: d6c4b0f9-bbd8-4a49-9cc5-b58de5eed056, execution type: CLIENT_ASYNC_MONITORED) java.lang.VerifyError: Cannot inherit from final class    at java.base/java.lang.ClassLoader.defineClass1(Native Method)    at java.base/java.lang.ClassLoader.defineClass(ClassLoader.java:1022)    at java.base/java.security.SecureClassLoader.defineClass(SecureClassLoader.java:174)    at java.base/java.net.URLClassLoader.defineClass(URLClassLoader.java:555)    at java.base/java.net.URLClassLoader$1.run(URLClassLoader.java:458)    at java.base/java.net.URLClassLoader$1.run(URLClassLoader.java:452)    at java.base/java.security.AccessController.doPrivileged(Native Method)    at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:451)    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:594)    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527)    at java.base/java.lang.Class.forName0(Native Method)    at java.base/java.lang.Class.forName(Class.java:398)    at java.base/java.util.ServiceLoader$LazyClassPathLookupIterator.nextProviderClass(ServiceLoader.java:1210)    at java.base/java.util.ServiceLoader$LazyClassPathLookupIterator.hasNextService(ServiceLoader.java:1221)    at java.base/java.util.ServiceLoader$LazyClassPathLookupIterator.hasNext(ServiceLoader.java:1265)    at java.base/java.util.ServiceLoader$2.hasNext(ServiceLoader.java:1300)    at java.base/java.util.ServiceLoader$3.hasNext(ServiceLoader.java:1385)    at java.base/java.lang.Iterable.forEach(Iterable.java:74)    at org.apache.poi.ss.usermodel.WorkbookFactory.<init>(WorkbookFactory.java:57)    at org.apache.poi.ss.usermodel.WorkbookFactory.<init>(WorkbookFactory.java:43)    at org.apache.poi.ss.usermodel.WorkbookFactory$Singleton.<clinit>(WorkbookFactory.java:46)    at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:327)    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:318)    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:277)    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:255)    at excelimporter.reader.readers.ExcelDataReader.readData(ExcelDataReader.java:23)    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:360)    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:118)    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: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:57)    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:829)
asked
1 answers
0

This can happen often due to changes in third-party libraries. You encountered this error after upgrading to Mendix version 9.24.12, it is possible that there is an incompatibility between the versions of Apache POI and the mendix runtime.

 

Below are a few steps to troubleshoot the issue:

 

1. Ensure there are no conflicting versions of Apache POI or other libraries in your project. Remove any duplicate or contradictory JAR files.

2 . Ensure that you are using compatible versions of all third-party libraries. Specifically, check the version of Apache POI being used and update it to a version compatible with Mendix 9.24.12.

Hope it helps!

answered