Error (SQL State: 42S01) Production database moved tot test. At startup this error. [Table mxmodelreflection$mxobjectreference already exists]

0
My client has made a dump of the production environment. They upload this dump into a NEW MySQL database connected to the Test environment. After they uploaded it the run the application and get the following error. 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR ERROR: Executing execute_ddl_commands did not succeed: result: 1, message: Executing DDL commands for component MyFirstComponent failed., caused by: Error (SQL State: 42S01, Error Code: 1050) on executing: 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR CREATE TABLE `mxmodelreflection$mxobjectreference` ( 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `id` BIGINT NOT NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `changeddate` DATETIME NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `createddate` DATETIME NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `associationowner` NVARCHAR(8) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `parententity` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `completename` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `module` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `referencetype` NVARCHAR(12) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `name` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `readablename` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `system$owner` BIGINT NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR `system$changedby` BIGINT NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR PRIMARY KEY(`id`)) 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] ERR All changes are rolled back. 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] OUT `name` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] OUT WARNING: start failed, stopping 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] OUT `readablename` NVARCHAR(200) NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] OUT `system$owner` BIGINT NULL, 2019-06-26T11:08:58.06+0200 [APP/PROC/WEB/0] OUT INFO: stopping app... 2019-06-26T11:08:58.07+0200 [APP/PROC/WEB/0] OUT `system$changedby` BIGINT NULL, 2019-06-26T11:08:58.07+0200 [APP/PROC/WEB/0] OUT PRIMARY KEY(`id`)) 2019-06-26T11:08:58.07+0200 [APP/PROC/WEB/0] OUT All changes are rolled back. 2019-06-26T11:08:58.07+0200 [APP/PROC/WEB/0] OUT INFO: Waiting for the application to shutdown... 2019-06-26T11:08:58.07+0200 [APP/PROC/WEB/0] OUT at com.mendix.connectionbus.modelsynchronization.DDLCommandExecutor.execute(DDLCommandExecutor.java:77) 2019-06-26T11:08:58.07+0200 [APP/PROC/WEB/0] OUT Caused by: java.sql.SQLSyntaxErrorException: Table 'mxmodelreflection$mxobjectreference' already exists   This never happened before and we cannot pinpoint what is going wrong. They have their application running on premise on Pivotal with Cloud Foundry support. I don't know what is going on and why its not working properly so i need help.
asked
0 answers