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.
Db Changes not made in PD after Promotion
-
- Posts: 472
- Joined: November 16th, 2021, 11:15 am
- Contact:
Db Changes not made in PD after Promotion
Last edited by CathyC on May 3rd, 2023, 11:38 am, edited 1 time in total. word count: 102
Tags:
-
- Posts: 329
- Joined: August 26th, 2021, 9:18 am
- Contact:
-
- Posts: 47
- Joined: September 7th, 2021, 1:04 pm
- Contact:
Re: Db Changes not made in PD after Promotion
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.
word count: 27
-
- Posts: 329
- Joined: August 26th, 2021, 9:18 am
- Contact:
-
- Posts: 47
- Joined: September 7th, 2021, 1:04 pm
- Contact:
Re: Db Changes not made in PD after Promotion
Confirmed new column is there.
A column name was changed in table MRO_Requests from PurchasingValidate to ValidateIMA. Please update production table.
A column name was changed in table MRO_Requests from PurchasingValidate to ValidateIMA. Please update production table.
word count: 22
-
- Posts: 329
- Joined: August 26th, 2021, 9:18 am
- Contact:
-
- Posts: 88
- Joined: August 26th, 2021, 5:21 pm
- Contact:
Re: Db Changes not made in PD after Promotion
I have moved 10597 to high pty to resolve it.
word count: 10
-
- Posts: 47
- Joined: September 7th, 2021, 1:04 pm
- Contact:
Re: Db Changes not made in PD after Promotion
I had this issue again today. I added column FromSTR to TG_FinishedGoodsItemMaintenance table and it is not showing in PD.
word count: 21
-
- Posts: 576
- Joined: August 26th, 2021, 9:56 am
- Contact:
Re: Db Changes not made in PD after Promotion
This issue has been resolved in DesignTime revision 2379.
word count: 9