Value on new field in the update set are not retrieved on other instance

kannann_ · ‎03-03-2016

Hi All,

We have added a new field on sys_update_set table which will hold the value of the Change ID under which this update set is implemented.

When we Retrieve update sets on another instance it does not gives us the value on the Change ID field. I checked the UI Action "Retrieve Completed Update Sets" but was not able to find anything.

Please help me out on this.

Thanks,

Kannan

matthew_magee1 · ‎07-27-2016

Hi Kannan,

A few steps I had to do:

In DEV instance, create 'Application Version' on sys_update_set table
in DEV instance, create 'Application Version' on sys_remote_update_set table (make sure the dictionary is the exact as #1)
In DEV instance, update UI Action 'Export to XML', add line> retrievedUpdateSet.u_application_version = current.u_application_version;
In TEST instance (or any target instance), create 'Application Version' on sys_remote_update_set table

If I want to merge update sets in TEST, or any target instance, I filter on Remote Sys id>Application Version

Works like a champ

Matthew

View solution in original post

Brian Dailey1 · ‎03-03-2016

Hi Kannan,

I would open up the update's downloaded XML file and search it for your Change ID value. Perhaps your custom field is not being included in the exported data, and this is an easy enough thing to check.

Thanks,

-Brian

kannann_ · ‎03-03-2016

Hello Brian,

I did not export the update set from one instance and imported it on other. I went in Update Sources > Retrieve Completed Update Sets and all the completed update sets on the first instance was copied to the second. I have checked the XML value of the field Change ID for the Retrieved Update Sets and they are blank.

matthew_magee1 · ‎07-26-2016

Kannan-

Did you get this to work? I have a similar field I created on our sys_update_set table. The value will save in our source environment, but when I export that update set, the value for that field is not there; therefore it does not get pushed over to the target instance

Kannan Nadar · ‎07-26-2016

Hello Matthew,

Yes, you would have to create the same field on your Retrieved Update Set table and then edit the UI Action on "Export to XML" on the local update set.

Add a line in it like

retrievedUpdateSet.u_change_ticket = current.u_change_ticket;

It worked for me. Try and let me know.