Page 1 of 1

Db Changes not made in PD after Promotion

Posted: July 5th, 2022, 11:19 am
by CathyC
I have had 2 projects go live in PD, then have support issues raised which were due to db changes not being made in PD despite making the changes in the IDE promotion path and moving them through with the dev workbench. The issues were in different tenants.

The first was in April where datatypes were not updated.
The second was mid June where new columns were not added.

I talked with Matt M and he had a similar issue early June.

I have been talking about this with Justin, but I wanted to open a forum post to officially track this.

Re: Db Changes not made in PD after Promotion

Posted: July 5th, 2022, 12:33 pm
by SteveCap
I have created task #10597.

Re: Db Changes not made in PD after Promotion

Posted: July 11th, 2022, 11:58 am
by kathy.pride
I had the same issue with new columns not added to tables in PD in May and again today. The columns were in both DV and QA.

Re: Db Changes not made in PD after Promotion

Posted: July 11th, 2022, 1:37 pm
by SteveCap
Your column has been added in PD.

Re: Db Changes not made in PD after Promotion

Posted: July 11th, 2022, 1:55 pm
by kathy.pride
Confirmed new column is there.

A column name was changed in table MRO_Requests from PurchasingValidate to ValidateIMA. Please update production table.

Re: Db Changes not made in PD after Promotion

Posted: July 11th, 2022, 2:23 pm
by SteveCap
Column has been updated

Re: Db Changes not made in PD after Promotion

Posted: August 2nd, 2022, 6:14 am
by SumanPrasad
I have moved 10597 to high pty to resolve it.

Re: Db Changes not made in PD after Promotion

Posted: August 3rd, 2022, 9:55 am
by kathy.pride
I had this issue again today. I added column FromSTR to TG_FinishedGoodsItemMaintenance table and it is not showing in PD.

Re: Db Changes not made in PD after Promotion

Posted: August 30th, 2022, 3:11 pm
by JustinVanRegenmorter
This issue has been resolved in DesignTime revision 2379.