Creating excel importer templates in ASU

0
Using an older version 6.10.5, creating an excel importer template using model reflection works and can be done in the ASU. However, using 7.5.1 I am running in to an after-build error: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity":{"type":"End"},"name":"AppAdmin.ASU_StartApplication","type":"Microflow"}', all database changes executed by this action were rolled back at com.mendix.basis.component.InternalCore.execute(InternalCore.java:506) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity":{"type":"End"},"name":"AppAdmin.ASU_StartApplication","type":"Microflow"}', all database changes executed by this action were rolled back at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity":{"type":"End"},"name":"AppAdmin.ASU_StartApplication","type":"Microflow"}', all database changes executed by this action were rolled back at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"current_activity":{"type":"End"},"name":"AppAdmin.ASU_StartApplication","type":"Microflow"}', all database changes executed by this action were rolled back at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:155) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: Autocommitted objects detected at end of transaction for system session for entities: - ExcelImporter.AdditionalProperties: 1 instances at com.mendix.basis.action.RequestScope$$anonfun$com$mendix$basis$action$RequestScope$$verifyNoAutoCommitsForSystemSessionExists$1$1.apply(RequestScope.scala:117) at com.mendix.basis.action.RequestScope$$anonfun$com$mendix$basis$action$RequestScope$$verifyNoAutoCommitsForSystemSessionExists$1$1.apply(RequestScope.scala:115) at scala.Option.foreach(Option.scala:257) at com.mendix.basis.action.RequestScope.com$mendix$basis$action$RequestScope$$verifyNoAutoCommitsForSystemSessionExists$1(RequestScope.scala:115) at com.mendix.basis.action.RequestScope$$anonfun$endTransaction$1.apply(RequestScope.scala:131) at com.mendix.basis.action.RequestScope$$anonfun$endTransaction$1.apply(RequestScope.scala:128) at scala.Option.foreach(Option.scala:257) at com.mendix.basis.action.RequestScope.endTransaction(RequestScope.scala:128) at com.mendix.basis.action.ContextImpl.endTransaction(ContextImpl.java:204) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:168) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:76) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51) at com.mendix.basis.actionmanagement.DefaultActionMonitor$$anonfun$run$1.apply(CustomMonitoredAction.scala:18) at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49) at com.mendix.basis.actionmanagement.CustomMonitoredAction.monitor(CustomMonitoredAction.scala:22) at com.mendix.basis.actionmanagement.DefaultActionMonitor$.run(CustomMonitoredAction.scala:18) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:65) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51) at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174) at com.mendix.basis.component.InternalCore.execute(InternalCore.java:500) at com.mendix.basis.component.InternalCore.execute(InternalCore.java:515) at com.mendix.basis.impl.MxRuntimeImpl.doFire(MxRuntimeImpl.java:588) at com.mendix.basis.impl.MxRuntimeImpl.fireZeeMissile(MxRuntimeImpl.java:543) at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:340) at com.mendix.basis.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:274) at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:50) at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:31) at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:368) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:942) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:647) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:745) From what I can tell, there is an auto-commit on one of the objects that is a part of the excel importer module, and the runtime doesn't like the autocommit when there isn't a session ID/user session. Is this something that was added new in version 7+? Cheers!
asked
2 answers
0

Harry,

This is just a copy of the comment made by Chris that seems a valid workaround and allows this issue to be closed if this works for you.

Chris suggested: As a workaround you can pick a user and use the community commons ExecuteMicroflowAsUser

Is this a valid workaround in your case?

answered
0

Why can't you explicitly commit or delete the AdditionalProperties object in your logic?

answered