Mendix Deployment Issue DDL Comamnds

0
Hi All I am facing following issue while deploying app on acceptance. Can some one please help. site_details_new is an external entity   Starting application failed: Application start failed 6:56:46 PMappERRORM2EE: An error occurred while executing action 'Execute DDL commands'. 6:56:46 PMappINFOcom.mendix.m2ee.api.AdminException: Executing DDL commands failed. 6:56:46 PMappINFOat com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:113) 6:56:46 PMappINFOCaused by: com.mendix.basis.connectionbus.ConnectionBusException: Error (SQL State: 42P01, Error Code: 0) on executing: 6:56:46 PMappINFO"main$supplierdetailsid" int8 NOT NULL, 6:56:46 PMappINFO"masterdata$site_details_newid" int8 NOT NULL, 6:56:46 PMappINFOWaiting for the application to shutdown... 6:56:46 PMappINFOAll changes are rolled back. 6:56:46 PMappINFOat com.mendix.connectionbus.modelsynchronization.DdlCommandExecutor.handleCommandExecutionException(DdlCommandExecutor.scala:140) 6:56:46 PMappINFOCaused by: org.postgresql.util.PSQLException: ERROR: relation "masterdata$site_details_new$pk" does not exist 6:56:46 PMappINFOat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2712) 6:56:46 PMappINFOat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2400) 6:56:46 PMappINFOat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:367) 6:56:46 PMappINFOat org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) 6:56:46 PMappINFOat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) 6:56:46 PMappINFOat org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335) 6:56:46 PMappINFOat org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321) 6:56:46 PMappINFOat org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297) 6:56:46 PMappINFOat org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292) 6:56:46 PMappINFOat org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) 6:56:46 PMappINFOat org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182)
asked
1 answers
0

Hi Harshit,

 

please try refer the below suggested approach and try restoring old database,

https://community.mendix.com/link/questions/110619

 

Thanks & Regards,

Manikandan K

answered