Error in execution of monitored action RegularClientAction

1
Hi all, I'm upgrading from 9.12.14 to 9.24.3. In 9.24.3 I upgraded all marketplace modules to latest versions and checked userlib folder for older jar files. I completely removed all required jar files for Community Commons, ExcelImporter and ExcelExporter and updated the modules. We have a big project so there are quite some jar files in the userlib and also some older once since the app is running for quite some time now. But I'm sure the Required libs for ExcelImporter are only the latest jar versions.   Anyway I get it all compiled and just wanted to test to import an Excel file. Then I get the above error at java action StartImportByTemplate.   Stacktrace:   Error in execution of monitored action 'RegularClientAction' (execution id: 1692179730158-35, execution type: CLIENT) -------- 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:1017)     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:589)     at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)     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:357)     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.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.component.ExecutionCore.doExecuteSync(ExecutionCore.scala:148)     at com.mendix.basis.component.ExecutionCore.doExecuteSync$(ExecutionCore.scala:147)     at com.mendix.basis.component.InternalCore.doExecuteSync(InternalCore.scala:24)     at com.mendix.basis.component.ExecutionCore.executeSync(ExecutionCore.scala:97)     at com.mendix.basis.component.ExecutionCore.executeSync$(ExecutionCore.scala:94)     at com.mendix.basis.component.InternalCore.executeSync(InternalCore.scala:24)     at com.mendix.modules.microflowengine.MicroflowExecuter$.executeSync(MicroflowExecuter.scala:19)     at com.mendix.modules.microflowengine.actions.SubMicroflowAction.execute(SubMicroflowAction.scala:37)     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.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.MicroflowCallBuilderImpl.execute(MicroflowCallBuilderImpl.scala:62)     at com.mendix.webui.actions.client.MicroflowRuntimeOperationExecutor.runMicroflow(MicroflowRuntimeOperationExecutor.scala:131)     at com.mendix.webui.actions.client.MicroflowRuntimeOperationExecutor.$anonfun$apply$5(MicroflowRuntimeOperationExecutor.scala:62)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$.$anonfun$liftEither$1(RegularClientAction.scala:30)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.$anonfun$apply$4(RegularClientAction.scala:56)     at com.mendix.webui.requesthandling.helpers.StateHandling.withState(StateHandling.scala:46)     at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:43)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.withState(RegularClientAction.scala:46)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:54)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:46)     at com.mendix.webui.actions.client.MicroflowRuntimeOperationExecutor.apply(MicroflowRuntimeOperationExecutor.scala:63)     at com.mendix.webui.actions.client.RuntimeOperationAction.$anonfun$apply$1(RuntimeOperationAction.scala:55)     at scala.util.Either.flatMap(Either.scala:352)     at com.mendix.webui.actions.client.RuntimeOperationAction.apply(RuntimeOperationAction.scala:41)     at com.mendix.webui.actions.client.RuntimeOperationAction.apply(RuntimeOperationAction.scala:30)     at com.mendix.webui.actions.client.RegularClientAction$Helpers$.$anonfun$liftEither$1(RegularClientAction.scala:30)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$3(RegularClientAction.scala:120)     at scala.util.Try$.apply(Try.scala:210)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2(RegularClientAction.scala:120)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2$adapted(RegularClientAction.scala:118)     at com.mendix.webui.requesthandling.helpers.ContextHandling.$anonfun$inContext$7(ContextHandling.scala:58)     at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)     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.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:58)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:32)     at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:94)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:29)     at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:21)     at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:94)     at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$1(RegularClientAction.scala:118)     at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)     at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest(ProfileHandling.scala:14)     at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest$(ProfileHandling.scala:10)     at com.mendix.webui.actions.client.RegularClientAction.profileRequest(RegularClientAction.scala:94)     at com.mendix.webui.actions.client.RegularClientAction.execute(RegularClientAction.scala:115)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:105)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:78)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:37)     at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1(MxRuntimeConnector.scala:54)     at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1$adapted(MxRuntimeConnector.scala:54)     at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.scala:54)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.scala:221)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.scala:40)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)     at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)     at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170)     at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202)     at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635)     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1385)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)     at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1307)     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)     at org.eclipse.jetty.server.Server.handle(Server.java:563)     at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)     at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)     at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:936)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1080)     at java.base/java.lang.Thread.run(Thread.java:829)    
asked
4 answers
1

Dave, only keep the most up to date versions of the jar-files, remove ALL jar-files with older revision numbers.

answered
0

Hi Dave,

Give this a shot : https://github.com/cinaq/mendix-userlib-cleaner

answered
0

Update, still trying to solve…..

 

When I update the ExcelImporter with version 10.1.3 it all goes well, but when I update to the next version 10.2.0 (or 10.3.0 or 10.4.0) it fails and I get the error in this post. I only updated this module. 

answered
0

We’re having the same problem after upgrading from Studio Pro 9.24.2 to 10.1.1. We were already using Excel Importer 10.4.0 and got this error. We re-installed it hoping it would overwrite the existing .jar files but we still get the error. Somewhere in its dependencies (.jar files) it is incorrectly extending a “final” class. See this StackOverflow post:

https://stackoverflow.com/questions/18138136/cannot-inherit-from-final-class-error

We are troubleshooting by trying to find all the .jar files that might conflict. No luck yet.

 

We solved it! It had nothing to do with dependencies and .jar files. Ignore the information I posted above. The error was caused by a problem with the data in the Excel file we were trying to import using the Excel Importer module and an import template. Presumably the bad data caused the Java code to fail in an unexpected way and generate the error we were seeing.

 

In our case, the solution was to copy all the data out to a text editor (Notepad++) then copy the data from Notepad++ (Select All and Copy again from Notepad++ so it doesn’t have any “hidden” formatting codes), create a new workbook in Excel, paste the data in and and Save As “Excel 97-2003 Workbook (*.xls)”. That removed extraneous “hidden” formatting codes that we couldn’t see in Excel. The file imported without any errors after doing this.

answered