Upon Deployment to another environment, I'm having a duplicate table like "TableA" and "TableA1". In Dev Environment we are using Outsystem DB while in UAT environment we are using sql server.Can i know what is the possible cause and fix for this ? Thank you everyone :)
Hi Darryl,
In both the place you are using same name of table like in Outsystem DB and sql server?
From one environment to another you are deploying outsystem DB also goes. Have you checked?
If possible can you change your table name from anyone place. So both the places having different name. You can try this or you can share some screenshot if possible we will understand more.
Regards,
Rajat
From DEV environment we are using internal database which is the outsystem db, in UAT we are using external database which is sql, its just we are using different DB in UAT. After deployment we're having a duplicate table like "OSSYS_USER" and "OSSYS_USER 1".
Hi @Darryl Villanueva ,
I would think that at some point, you have changed your entity name or maybe accidentally copied and pasted the entity. This may cause OutSystems to actually create a new table.
Another thing to look into, is your UAT database a clone of the one in DEV and then you deployed dev to uat? It is possible that the same tablename already exists in the database, so OutSystems will try to create a new table.
Either way, there is a forge component that you can use to fix and remap your entities https://www.outsystems.com/forge/component-overview/5018/db-cleaner-on-steroids-o11
Hope this helps.
Bryan
Hi @Bryan Villalobos, thank you for your detailed response.