DDL Operation Error

0
I change the Entity name "MsgHistory" to "LinedMsgHistory" and add Some attribute. And Commit two days ago, But two days later the Mendix Server is not Operate and Can't be restart. I renamed the changed tables revert name. Still Can not start the server.   What makes this problem occur, How to  recover this DB Server. (ex, re-synchronize the database about now mendix setting)     Mendix error msg :   M2EE: Anerror occured while executing action 'Execute DDL commands'. com.mendixs.m2ee.api.AdminException: Executing DDL commands failed. at com.mendix.basis.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:113)   Caused by: com.mendix.basis.connectionbus.ConnectionBusExceptioin: Error(SQL State: 42000, Error Code: 904) on executing: ALTER TABLE "JBCOMMONMODULE$LINKEDHISTORY" DROP COLUMN "MSGCD"   Successful changes were not rolled back. We advise you to restore the database from a backup before trying to synchronize again. at com.mendix.connectionbus.modelsynchronization.DdlcommandExecutor.handleCommandExecutionException(DdlCommandExecutor.scala:142)   Caused by: java.sql.SQLSyntaxErrorExceptioin: ORA-00904: "MSGCD": invalid indentifier   https://doc.oracle.com/error-help/db/ora-00904 ...    
asked
2 answers
0

Hi Lee,

 

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

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

 

Hope it helps!

 

Thanks & Regards,

Manikandan K

answered
0

I resolve this problem to cascade delete the tables while  server stoped.

And, Restart the m2ee server. This proccess rebuild the database tables by Recently Tables

answered