com.mendix.m2ee.api.AdminException: Executing DDL commands for failed.

1
  Hello Everyone,        I am upgrading my project from mendix 6 to 7, i  updated all app store modules and widgets, everything is running successfull….       But when i am deploying the project it is throwing some error like Executing DDL Commands..      Can you people please help me with this problem?   com.mendix.m2ee.api.AdminException: Executing DDL commands for component MyFirstComponent failed.     at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:115) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Error (SQL State: 42504, Error Code: -5504) on executing: CREATE TABLE "mendixsystem$unique_constraint" (     "name" VARCHAR_IGNORECASE(255) NOT NULL,     "table_id" VARCHAR_IGNORECASE(36) NOT NULL,     "column_id" VARCHAR_IGNORECASE(36) NOT NULL,     PRIMARY KEY("name","column_id")) All changes are rolled back.     at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.execute(DdlCommandExecutor.java:77) Caused by: java.sql.SQLSyntaxErrorException: object name already exists: mendixsystem$unique_constraint in statement [CREATE TABLE "mendixsystem$unique_constraint" (     "name" VARCHAR_IGNORECASE(255) NOT NULL,     "table_id" VARCHAR_IGNORECASE(36) NOT NULL,     "column_id" VARCHAR_IGNORECASE(36) NOT NULL,     PRIMARY KEY("name","column_id"))]     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)     at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)     at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)     at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.executeDdlCommands(DdlCommandExecutor.java:134)     at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.execute(DdlCommandExecutor.java:41)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.synchronizeModel(SynchronizationManager.scala:151)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.executeImpl(SynchronizationManager.scala:142)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.execute(SynchronizationManager.scala:90)     at com.mendix.connectionbus.ConnectionBusImpl.executeDDLCommands(ConnectionBusImpl.java:402)     at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:112)     at com.mendix.basis.impl.MxRuntimeImpl.executeDDLCommands(MxRuntimeImpl.java:999)     at com.mendix.basis.action.admin.ExecuteDDLCommandsAction.call(ExecuteDDLCommandsAction.java:27)     at com.mendix.basis.action.admin.RuntimeAdminAction.execute(RuntimeAdminAction.java:18)     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:748) Caused by: org.hsqldb.HsqlException: object name already exists: mendixsystem$unique_constraint     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)     at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)     at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)     at org.hsqldb.StatementSchema.getResult(Unknown Source)     at org.hsqldb.StatementSchema.execute(Unknown Source)     at org.hsqldb.Session.executeCompiledStatement(Unknown Source)     at org.hsqldb.Session.executeDirectStatement(Unknown Source)     at org.hsqldb.Session.execute(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)     at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)     at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)     at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.executeDdlCommands(DdlCommandExecutor.java:134)     at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.execute(DdlCommandExecutor.java:41)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.synchronizeModel(SynchronizationManager.scala:151)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.executeImpl(SynchronizationManager.scala:142)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.execute(SynchronizationManager.scala:90)     at com.mendix.connectionbus.ConnectionBusImpl.executeDDLCommands(ConnectionBusImpl.java:402)     at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:112)     at com.mendix.basis.impl.MxRuntimeImpl.executeDDLCommands(MxRuntimeImpl.java:999)     at com.mendix.basis.action.admin.ExecuteDDLCommandsAction.call(ExecuteDDLCommandsAction.java:27)     at com.mendix.basis.action.admin.RuntimeAdminAction.execute(RuntimeAdminAction.java:18)     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:748)    
asked
3 answers
1

See the documentation here: https://docs.mendix.com/refguide/uniqueness-constraint-migration#1-introduction

Regards,

Ronald

 

answered
1

Manually deleting the [mendixsystem$unique_constraint] table did the trick for me. Hope dit solution helps anyone that comes across the same problem.

answered
0

I am not sure what is causing this, but are you sure you are pointing to a Mendix database that is clean enough? Clean meaning there is nothing left behind in the database because of earlier attempts to migrate to Mendix 7.

You may want to restore a Mendix 6 database and retry.

answered