Cannot add attribute to domain model with existing data

0
Hello all,  I am having difficulty adding an attribute to an existing domain model with data. We are using the built in Mendix DB for storing our data. We do not have an issue when testing locally but when running m2ee instance on our lower envs we are prompted to execute DB query to update the schema. This fails to run with the following error:    ERROR - M2EE: 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:113) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Error (SQL State: 60000, Error Code: 604) on executing: 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:151) Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database or pluggable database open for read-only access We have existing data that we cannot remove. Is there a way to perform this table update without removing all of our existing data? 
asked
1 answers
0

This looks like an Oracle error, so I assume you are self-hosting your Mendix application and not using the Mendix Cloud. If this is the case you need to talk to your DBA and ask them to allow the application to make changes to the database structure.

 

Good luck!

answered