Db Changes not made in PD after Promotion

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
CathyC
Posts: 472
Joined: November 16th, 2021, 11:15 am
Contact:

Db Changes not made in PD after Promotion

Unread post 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.
Last edited by CathyC on May 3rd, 2023, 11:38 am, edited 1 time in total. word count: 102

Tags:
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: Db Changes not made in PD after Promotion

Unread post by SteveCap »

I have created task #10597.
word count: 5
kathy.pride
Posts: 47
Joined: September 7th, 2021, 1:04 pm
Contact:

Re: Db Changes not made in PD after Promotion

Unread post 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.
word count: 27
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: Db Changes not made in PD after Promotion

Unread post by SteveCap »

Your column has been added in PD.
word count: 7
kathy.pride
Posts: 47
Joined: September 7th, 2021, 1:04 pm
Contact:

Re: Db Changes not made in PD after Promotion

Unread post 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.
word count: 22
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: Db Changes not made in PD after Promotion

Unread post by SteveCap »

Column has been updated
word count: 4
SumanPrasad
Posts: 88
Joined: August 26th, 2021, 5:21 pm
Contact:

Re: Db Changes not made in PD after Promotion

Unread post by SumanPrasad »

I have moved 10597 to high pty to resolve it.
word count: 10
kathy.pride
Posts: 47
Joined: September 7th, 2021, 1:04 pm
Contact:

Re: Db Changes not made in PD after Promotion

Unread post by kathy.pride »

I had this issue again today. I added column FromSTR to TG_FinishedGoodsItemMaintenance table and it is not showing in PD.
word count: 21
JustinVanRegenmorter
Posts: 576
Joined: August 26th, 2021, 9:56 am
Contact:

Re: Db Changes not made in PD after Promotion

Unread post by JustinVanRegenmorter »

This issue has been resolved in DesignTime revision 2379.
word count: 9
Post Reply