Question
Wells Fargo
IN
Last activity: 2 Mar 2017 21:57 EST
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.
Regards,
Santosh Kumar N.
***Updated by moderator: Lochan to update Categories***
Pegasystems Inc.
IN
Hi,
After modifiying the property/column(renaming) , you need to resave the db table instance.
But once you saved the db table instance,and then if you try to move the same code base to other environments, the issue will not reoccur.
Pegasystems Inc.
IN
Hi,
If you have a property in class say 'Sae-HRServices-Work' , you need to open the instance of Data-Admin-DB-Table specific to the above class and resave it .
Wells Fargo
IN
Yes , it helped me. But i doubt if it is the right approach. I am planning to move the DB instance and class instance , i mean pzInskey of both of them.