Uploading file failed: com.mendix.core.CoreRuntimeException: Failed to commit [User 'MxAdmin' with session id '3adaa2f0-XXXX-XXXX-XXXX-XXXXXXXX0d8d' and roles 'Administrator'] -------- com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Failed to commit at com.mendix.filedocumentprocessor.internal.FileDocumentProcessorImpl.storeImageInternal(FileDocumentProcessorImpl.scala:168) Caused by: com.mendix.core.CoreRuntimeException: Failed to commit at com.mendix.basis.component.TransactionCore.doCommit(TransactionCore.scala:164) 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.ActionManager.executeSync(ActionManager.scala:108) 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$.withContextClassLoader(Runner.scala:23) 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:153) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.scala:30) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23) Caused by: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation ; "uniq_system$user_name" table: "system$user" at com.mendix.basis.action.user.CommitAction$$anonfun$commitPersistableObjects$5.applyOrElse(CommitAction.scala:117) at com.mendix.basis.action.user.CommitAction$$anonfun$commitPersistableObjects$5.applyOrElse(CommitAction.scala:114) at scala.util.Failure.recoverWith(Try.scala:240) at com.mendix.basis.action.user.CommitAction.commitPersistableObjects(CommitAction.scala:114) at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:59) at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:31) 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:104) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103) at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.scala:27) at com.mendix.basis.actionmanagement.EventExtendedAction.execute(EventExtendedAction.scala:60) 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:105) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeInTransactionSync$1(ActionManager.scala:115) at scala.util.Try$.apply(Try.scala:210) at com.mendix.basis.actionmanagement.ActionManager.executeInTransactionSync(ActionManager.scala:115) at com.mendix.basis.component.TransactionCore.doStore$1(TransactionCore.scala:206) at com.mendix.basis.component.TransactionCore.storeObjectsAndAutoCommittedObjects(TransactionCore.scala:214) at com.mendix.basis.component.TransactionCore.doCommit(TransactionCore.scala:143) at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:116) at com.mendix.basis.component.TransactionCore.commit$(TransactionCore.scala:110) at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:24) at com.mendix.basis.component.TransactionCore.commitWithEvents(TransactionCore.scala:66) at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:25) at com.mendix.basis.component.TransactionCore.commit$(TransactionCore.scala:24) at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:24) at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:20) at com.mendix.basis.component.TransactionCore.commit$(TransactionCore.scala:20) at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:24) at com.mendix.filedocumentprocessor.internal.FileDocumentProcessorImpl.storeImageInternal(FileDocumentProcessorImpl.scala:155) at com.mendix.filedocumentprocessor.internal.FileDocumentProcessorImpl.storeImage(FileDocumentProcessorImpl.scala:79) at com.mendix.basis.component.FileDocumentCore.storeImageDocumentContent(FileDocumentCore.scala:51) at com.mendix.basis.component.FileDocumentCore.storeImageDocumentContent$(FileDocumentCore.scala:44) at com.mendix.basis.component.InternalCore.storeImageDocumentContent(InternalCore.scala:24) at com.mendix.webui.requesthandling.FileUploadHelper.$anonfun$doUpload$2(FileUploadHelper.scala:142) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18) 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.requesthandling.FileUploadHelper.withState(FileUploadHelper.scala:30) at com.mendix.webui.requesthandling.helpers.StateHandling.withState(StateHandling.scala:40) at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:33) at com.mendix.webui.requesthandling.FileUploadHelper.withState(FileUploadHelper.scala:30) at com.mendix.webui.requesthandling.FileUploadHelper.doUpload(FileUploadHelper.scala:126) at com.mendix.webui.requesthandling.FileUploadHelper.handleUpload(FileUploadHelper.scala:44) at com.mendix.webui.requesthandling.FileRequestHandler.handleRequest(FileRequestHandler.scala:39) at com.mendix.webui.requesthandling.FileRequestHandler.processRequest(FileRequestHandler.scala:31) 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:218) 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:1384) 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:1306) 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$RequestDispatchable.dispatch(HttpChannel.java:1598) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501) 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:421) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277) at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149) at java.base/java.lang.Thread.run(Thread.java:829)
asked
sabitha k
1 answers
1
Hi sabitha ,
Check the system.user table and identify if any rows have duplicate adminstartor(user name)