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

0
Hello,   I made some changes to my domain model. The Modeler does not show any errors. However, when I wanted to restart the app, when synchronizing the database, I ran into the following error. When I create a new database the problem does not occur. But I don't want to lose my data. Is there any way to get rid of this error? It looks like something is blocking the removal of an index.   An error occurred while executing action 'Execute DDL commands'. -------- com.mendix.m2ee.api.AdminException: Executing DDL commands failed.     at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:117) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Error (SQL State: 42501, Error Code: -5501) on executing: DROP INDEX "idx_integration_salesforce$cdwh_salesforceaccount_system$owner" All changes are rolled back.     at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.execute(DdlCommandExecutor.java:77) Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: idx_integration_salesforce$cdwh_salesforceaccount_system$owner in statement [DROP INDEX "idx_integration_salesforce$cdwh_salesforceaccount_system$owner"]     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:170)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.executeImpl(SynchronizationManager.scala:161)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.execute(SynchronizationManager.scala:108)     at com.mendix.connectionbus.ConnectionBusImpl.executeDDLCommands(ConnectionBusImpl.java:383)     at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:109)     at com.mendix.basis.impl.MxRuntimeImpl.executeDDLCommands(MxRuntimeImpl.java:960)     at com.mendix.basis.action.admin.ExecuteDDLCommandsAction.call(ExecuteDDLCommandsAction.java:26)     at com.mendix.basis.action.admin.RuntimeAdminAction.execute(RuntimeAdminAction.java:18)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:128)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)     at org.eclipse.jetty.server.Server.handle(Server.java:561)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)     at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)     at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)     at java.lang.Thread.run(Thread.java:748) Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: idx_integration_salesforce$cdwh_salesforceaccount_system$owner     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.error.Error.error(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:170)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.executeImpl(SynchronizationManager.scala:161)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.execute(SynchronizationManager.scala:108)     at com.mendix.connectionbus.ConnectionBusImpl.executeDDLCommands(ConnectionBusImpl.java:383)     at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:109)     at com.mendix.basis.impl.MxRuntimeImpl.executeDDLCommands(MxRuntimeImpl.java:960)     at com.mendix.basis.action.admin.ExecuteDDLCommandsAction.call(ExecuteDDLCommandsAction.java:26)     at com.mendix.basis.action.admin.RuntimeAdminAction.execute(RuntimeAdminAction.java:18)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:128)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)     at org.eclipse.jetty.server.Server.handle(Server.java:561)     at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)     at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)     at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)     at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)     at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)     at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)     at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)     at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)     at java.lang.Thread.run(Thread.java:748)  
asked
2 answers
0

Even when I delete the complete entity, I get this error.... 

Is there any way to delete the entity and underlying indexes manually?

answered
0

You need to update your Database access, as your user account do not have sufficient access to remove an index from the database.

 

" user lacks privilege or object not found: idx_integration_salesforce$cdwh_salesforceaccount_system$owner in statement [DROP INDEX "idx_integration_salesforce$cdwh_salesforceaccount_system$owner"]"

answered