SantoshN4550 Member since 2015 7 posts
Wells Fargo
Posted: 3 years ago
Last activity: 3 years 6 months ago

Deploying : An altered table to higher environments

Hi Team,

We have renamed an existing column name in the Data base table, created a property with same name as the renamed column, saved the DB table instance. Now when we deployed 1)The Property is moved to next environment, 2)Executed the altered query . But still , we got error stating "pyCommitError:** Problem writing an instance to the database :code:904 SQL State: 42000 Message: ORA-00904: " NEW PROPERTY":invalid identifier. Later we saved the DB Table instance, then we did not got any error. Is it the way we are supposed to do even if we move to UAT, Production ? But this seems to be not a correct way.Please let us know if there is any other better way.


Santosh Kumar N.

***Updated by moderator: Lochan to update Categories***

System Administration Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn