lost updates for field creation

[El Cuchi]

Hi All,

I hope everyone is ok.

Here is the situation

i created 2 fields in the cmdb_ci table and then added them to several classes. All this supposed to be captures in an update set. After this,  I run the preview in UAT for the update set and for some reason the creation of those fields were not there, only the addition of them to the classes. Hence i had several errors.

Issue

I could not find the creation of these 2 fields anywere, so the big question is how do i capture the creation of both fields in a new update set in DEV to move it to UAT?

regards,

[Community Alums]

Hi @El Cuchi ,

Make sure while making any changes, you should capture in the update set. Always go back and check if the changes you made got captured in the Update set or not before you close and ready to be migrated to the next environment.

Now, you have only one option to crate an update set, make it current and start making the changes.

[Mark Manders]

Since we weren't standing behind you when you did, we can only guess to what happened. Did you check the cmdb_ci dictionary for the fields? Did you check the entire dictionary for the fields (maybe on a different table?).

Did you check the sys_update_xml table to see what happened around the time you created the fields? Also check what happened during the adding of them. Since you added them to the tables (I assume you mean forms, since they are inherited to the tables from cmdb_ci?), they must exist. 

[El Cuchi]

HI Mark,

Thank you very much for your tip. i am investigating this table. but could not find anything yet.

regards,

max

[El Cuchi]

Hi Mark,

I found the following update in the table you suggested.

This update is in the update set but i dont think is the one that creates those fields. Must be the one that adds them to the form.

Any idea?