error: only Database Uniqueness Validation is supported

1
Hi, I encountered an error while running the app. Could anyone help me out with it?   com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime: Detected unique constraint violation [association: UserManagement.Buyer_Branch, column: BranchManagement.BranchID] Since Mendix 9, only Database Uniqueness Validation is supported. If your project still uses Runtime Uniqueness Validation, please contact support.     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:268) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Detected unique constraint violation [association: UserManagement.Buyer_Branch, column: BranchManagement.BranchID] Since Mendix 9, only Database Uniqueness Validation is supported. If your project still uses Runtime Uniqueness Validation, please contact support.     at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.validateConstraints(ModelSynchronizationUpdater.java:170)     at com.mendix.connectionbus.modelsynchronization.ModelSynchronizationUpdater.analyzeAndRender(ModelSynchronizationUpdater.java:114)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeMappingModel(SynchronizationManager.scala:239)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeModel(SynchronizationManager.scala:230)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeCurrentDatabase(SynchronizationManager.scala:148)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$3(SynchronizationManager.scala:81)     at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:52)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeCopying(SynchronizationManager.scala:187)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$2(SynchronizationManager.scala:80)     at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:52)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyzeSourceStructureForCopy(SynchronizationManager.scala:156)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.$anonfun$stateMachine$1(SynchronizationManager.scala:79)     at com.mendix.connectionbus.modelsynchronization.SimpleStateMachine$SimpleStateMachine.effect(SynchronizationManager.scala:52)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.analyze(SynchronizationManager.scala:138)     at com.mendix.connectionbus.ConnectionBusImpl.collectDatabaseSynchronizationInformation(ConnectionBusImpl.scala:270)     at com.mendix.basis.impl.MxRuntimeImplBase.collectDdlCommands(MxRuntimeImplBase.java:375)     at com.mendix.basis.impl.MxRuntimeImplBase.doSynchronization(MxRuntimeImplBase.java:286)     at com.mendix.basis.impl.MxRuntimeImplBase.startConnectionBus(MxRuntimeImplBase.java:275)     at com.mendix.basis.impl.MxRuntimeImplBase.start(MxRuntimeImplBase.java:247)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.scala:30)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.scala:17)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandlerBase.service(HttpAdminHandlerBase.java:128)     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.doHandle(ServletHandler.java:529)     at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1378)     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.handler.ScopedHandler.nextScope(ScopedHandler.java:174)     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1300)     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:562)     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:319)     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:412)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:381)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:268)     at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:138)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:407)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:894)     at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1038)     at java.base/java.lang.Thread.run(Thread.java:834)      
asked
3 answers
0

you probably changed a many to 1 into a 1 to 1? 

answered
0

Hi Manish,
Can you tell how you solved this issue?

answered
0

Put the association back to *:* or 1:*, Clean up the duplicates and set it to the desired state.

answered