How to resolve an error creating while synchronizing the database ?
0
Question: I'm experiencing an issue while executing a DDL command in my Mendix application. Context: When trying to rename a table, I encounter the following error message: com.mendix.m2ee.api.AdminException: Executing DDL commands failed. at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:113) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Error (SQL State: 42P01, Error Code: 0) on executing: ALTER TABLE "anc_module$ncmfilter_ncmstatus" RENAME TO "ee65edd13633479595dba195e77cc572" All changes are rolled back. at com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.handleCommandExecutionException(DdlCommandExecutor.scala:142) Caused by: org.postgresql.util.PSQLException: ERROR: relation "anc_module$ncmfilter_ncmstatus" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) at org.postgresql.core.v3.QueryExecutorImpl.processResults(Query