Error when uploading file

0
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
1 answers
1

 

               

Hi sabitha ,

                Check the system.user table and identify if any rows have duplicate adminstartor(user name)

values.

answered