Hello everyone,
Initially, I deployed my application with its schema via "cf deploy" using MTA archive, and also redeployed it many times successfully. Then application worked for some time and the tables got filled.
After some time I needed to transfer the content of my HDI container to a new HDI container. For that, I went to Database Explorer, chose "Export Catalog Objects", added whole schema to export, and exported it as binary. Then I unbound all applications from my instance of HDI container and deleted it, created a new instance, and bound applications to a new container. In Database Explorer I opened my new container and made "Import Catalog Objects" with the new name of the schema (Clicked "Rename"). Import was completed successfully, so as a result, I had a new container with the same tables and data, but the schema was renamed.
The problem occurred when I tried to run "cf deploy" again. The logs of db-deployer showed
Error: com.sap.hana.di.table: could not create the database object Error: com.sap.hana.di.table: Database error 288: cannot use duplicate table name <name>
for one table. Same error when running "cds deploy -2 hana". The schema's name in the logs is the new one.
I tried to exclude this table from deployment, but the error was shown again for other tables.
I try with the newest version of cds 7.1.2
I suppose that there is some kind of conflict that appeared in the container after exporting and importing data...
Any help about how to fix redeploy will be appreciated!