LDAP Synch Import - Failed to Commit error - Mendix Forum

LDAP Synch Import - Failed to Commit error

0

Hello guys,

We recently upgraded Mendix from 6.9 to 7.21 and started getting “Failed to Commit” during LDAP Synch (Version 5.3.1) job execution. We are using below LDAP settings. Please share your thoughts.

I tried cleaning all User Account data and freshly imported into two lower environments. One environment able to successfully imported and another environment still getting Failed to Commit Msg. Same code and same data from Active Directory but two different results.   

Error Message:

2019-04-03 10:58:02.926 ERROR - Ldap: com.mendix.core.CoreRuntimeException: Failed to commit
at com.mendix.basis.component.CommitHandler.commit(CommitHandler.scala:155)
Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', all database changes executed by this action were rolled back
at com.mendix.basis.actionmanagement.ActionManagerBase.executeInTransactionSync(ActionManagerBase.java:125)
Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', all database changes executed by this action were rolled back
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:159)
Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', all database changes executed by this action were rolled back
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)
Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', all database changes executed by this action were rolled back
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:160)
Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.NullPointerException
at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.java:43)
Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.NullPointerException
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:159)
Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.NullPointerException
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)
Caused by: java.lang.NullPointerException: null
at java.lang.AbstractStringBuilder.append(Unknown Source)
at java.lang.StringBuilder.append(Unknown Source)
at com.mendix.basis.action.user.UniquenessChecker.findEntityOnAttribute(UniquenessChecker.scala:103)
at com.mendix.basis.action.user.UniquenessChecker.existsInDatabase(UniquenessChecker.scala:81)
at com.mendix.basis.action.user.UniquenessChecker.$anonfun$check$6(UniquenessChecker.scala:46)
at com.mendix.basis.action.user.UniquenessChecker.$anonfun$check$6$adapted(UniquenessChecker.scala:41)
at scala.Option.foreach(Option.scala:257)
at com.mendix.basis.action.user.UniquenessChecker.$anonfun$check$5(UniquenessChecker.scala:41)
at com.mendix.basis.action.user.UniquenessChecker.$anonfun$check$5$adapted(UniquenessChecker.scala:38)
at scala.collection.immutable.List.foreach(List.scala:388)
at com.mendix.basis.action.user.UniquenessChecker.$anonfun$check$4(UniquenessChecker.scala:38)
at scala.collection.immutable.List.flatMap(List.scala:334)
at com.mendix.basis.action.user.UniquenessChecker.checkUniqueness$1(UniquenessChecker.scala:34)
at com.mendix.basis.action.user.UniquenessChecker.check(UniquenessChecker.scala:57)
at com.mendix.basis.action.user.CommitAction.commitPersistableObjects(CommitAction.scala:92)
at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:59)
at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:29)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)
at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.java:41)
at com.mendix.basis.actionmanagement.EventExtendedAction.execute(EventExtendedAction.java:104)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18)
at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)
at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)
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:68)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:153)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeInTransactionSync(ActionManagerBase.java:118)
at com.mendix.basis.component.CommitHandler.$anonfun$storeObjectsAndAutoCommittedObjects$1(CommitHandler.scala:169)
at scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:233)
at scala.collection.immutable.List.foreach(List.scala:388)
at scala.collection.TraversableLike.map(TraversableLike.scala:233)
at scala.collection.TraversableLike.map$(TraversableLike.scala:226)
at scala.collection.immutable.List.map(List.scala:294)
at com.mendix.basis.component.CommitHandler.storeObjectsAndAutoCommittedObjects(CommitHandler.scala:167)
at com.mendix.basis.component.CommitHandler.commit(CommitHandler.scala:127)
at com.mendix.basis.component.CommitHandler.commit$(CommitHandler.scala:109)
at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:7)
at com.mendix.basis.component.CommitHandler.commitWithEvents(CommitHandler.scala:68)
at com.mendix.basis.component.CommitHandler.commit(CommitHandler.scala:27)
at com.mendix.basis.component.CommitHandler.commit$(CommitHandler.scala:26)
at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:7)
at com.mendix.basis.component.CommitHandler.commit(CommitHandler.scala:22)
at com.mendix.basis.component.CommitHandler.commit$(CommitHandler.scala:22)
at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:7)
at com.mendix.core.Core.commit(Core.java:444)
at system.proxies.User.commit(User.java:108)
at ldap.ImportUserRecord.processUserImport(ImportUserRecord.java:538)
at ldap.ImportUserRecord$UserMapper.handleNameClassPair(ImportUserRecord.java:344)
at org.springframework.ldap.core.LdapTemplate.search(LdapTemplate.java:367)
at org.springframework.ldap.core.LdapTemplate.search(LdapTemplate.java:328)
at ldap.LdapModule.pagedSearch(LdapModule.java:433)
at ldap.LdapModule.searchAD(LdapModule.java:387)
at ldap.ImportUserRecord.importUsers(ImportUserRecord.java:230)
at ldap.ImportUserRecord.runImportUsers(ImportUserRecord.java:113)
at ldap.actions.ImportLdapUsers.executeAction(ImportLdapUsers.java:49)
at ldap.actions.ImportLdapUsers.executeAction(ImportLdapUsers.java:27)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)
at com.mendix.basis.component.InternalCoreBase.execute(InternalCoreBase.java:414)
at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:56)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)
at com.mendix.basis.component.InternalCoreBase.executeSync(InternalCoreBase.java:492)
at com.mendix.modules.microflowengine.actions.SubMicroflowAction.execute(SubMicroflowAction.scala:51)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)
at com.mendix.basis.component.InternalCoreBase.executeSync(InternalCoreBase.java:492)
at com.mendix.modules.microflowengine.actions.other.NestedLoopedMicroflowAction.$anonfun$executeLoop$2(NestedLoopMicroflowAction.scala:67)
at com.mendix.modules.microflowengine.actions.other.NestedLoopedMicroflowAction.$anonfun$executeLoop$2$adapted(NestedLoopMicroflowAction.scala:58)
at scala.collection.TraversableLike$WithFilter.$anonfun$foreach$1(TraversableLike.scala:788)
at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:58)
at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:51)
at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47)
at scala.collection.TraversableLike$WithFilter.foreach(TraversableLike.scala:787)
at com.mendix.modules.microflowengine.actions.other.NestedLoopedMicroflowAction.executeLoop(NestedLoopMicroflowAction.scala:58)
at com.mendix.modules.microflowengine.actions.other.NestedLoopedMicroflowAction.execute(NestedLoopMicroflowAction.scala:40)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:150)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:155)
at com.mendix.basis.component.InternalCoreBase.executeSync(InternalCoreBase.java:492)
at com.mendix.modules.microflowengine.actions.SubMicroflowAction.execute(SubMicroflowAction.scala:51)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201)
at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)
at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.DefaultActionMonitor$.$anonfun$run$1(CustomMonitoredAction.scala:18)
at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)
at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)
at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49)
at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25)
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:68)
at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:55)
at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55)
at com.mendix.basis.actionmanagement.AsyncExecution.$anonfun$call$1(AsyncExecution.scala:21)
at scala.util.Try$.apply(Try.scala:209)
at com.mendix.basis.actionmanagement.AsyncExecution.call(AsyncExecution.scala:21)
at com.mendix.basis.actionmanagement.AsyncExecution.$anonfun$execute$1(AsyncExecution.scala:17)
at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:654)
at scala.util.Success.$anonfun$map$1(Try.scala:251)
at scala.util.Success.map(Try.scala:209)
at scala.concurrent.Future.$anonfun$map$1(Future.scala:288)
at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:29)
at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:29)
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:60)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

asked
3 answers
0

1- Upgrade new ldap module

2- Test connection

3- Then try to sync again

 

answered
0

There are ongoing nullpointer exception from many days and used to import the User account. No microflows are being triggered during Ldap Synch execution. Only Ldap Java action system logic is being triggered.

However, last night the job successfully imported but this issue is inconsistently after Mendix Upgrade to 7.21.0 and also, getting similar Failed to Commit during User login into application from Start_Siteminder_login java action.

We are wondering this issue is something to do with Mendix upgrade and with System entities (Account & User) during commit.

answered
0

As you’re getting a nullpointer exception, it seems that a microflow is being triggered that expects an object but that object is not available. Do you have any event microflows running on your account entity that might be causing this issue?

answered