Posted: 10 Feb 2017 1:02 EST Last activity: 2 Mar 2017 21:57 EST
Deploying : An altered table to higher environments
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***