0

I created an index and later deleted the index from an entity. After changes I am not able to run the application, with the following error : com.mendix.m2ee.api.AdminException: Executing DDL commands failed. at com.mendix.core.MxRuntime.d(SourceFile:536) Caused by: l: Error (SQL State: 42501, Error Code: -5501) on executing: DROP INDEX "idximporttrades$movementimportlinemovementstatus" All changes are rolled back. at bq.a(SourceFile:86) Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: idximporttrades$movementimportlinemovementstatus in statement [DROP INDEX "idximporttrades$movementimportlinemovementstatus"] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at bq.a(SourceFile:177) at bq.a(SourceFile:48) at h.a(SourceFile:196) at h.a(SourceFile:191) at h.c(SourceFile:172) at com.mendix.core.MxRuntime.d(SourceFile:531) at fL.a(SourceFile:30) at fQ.execute(SourceFile:26) at com.mendix.m2ee.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:132) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111) at org.eclipse.jetty.server.Server.handle(Server.java:351) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:890) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:944) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:642) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534) at java.lang.Thread.run(Thread.java:662) Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: idximporttrades$movementimportlinemovementstatus at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.StatementSchema.getResult(Unknown Source)

asked 2015-07-13

1 answers