Capture table schema in Update set

dinesh91n
Tera Expert

Hi All,

I missed to capture the table schema in update set while creating the table. Now am trying to capture the table data in new update set. But, when i am trying to move the update set to other instance. The table label is changing as "LABEL". Please see the image. So the table is not create properly. Please advice.

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Hi Dinesh,



Try this... (in dev)



Create a new local update set.



Use the application navigator filter to go to sys_update_xml.list



find_real_file.png



See if you can find the sys_dictionary entry for your table label using the various filters. If says anything other than "Default" in the Update Set column, leave it alone. If it is blank or says Default, change the record to point to your update set.



You can now mark your new update set Complete and promote it as any other.



If the record is associated with any other update set as noted above, then you will need to go to the sys_dictionary table, locate your table label and export the XML from dev and manually import it in to test & prod.



Exporting and Importing XML Files - ServiceNow Wiki


View solution in original post

6 REPLIES 6

Chuck Tomasi
Tera Patron

Hi Dinesh,



Try this... (in dev)



Create a new local update set.



Use the application navigator filter to go to sys_update_xml.list



find_real_file.png



See if you can find the sys_dictionary entry for your table label using the various filters. If says anything other than "Default" in the Update Set column, leave it alone. If it is blank or says Default, change the record to point to your update set.



You can now mark your new update set Complete and promote it as any other.



If the record is associated with any other update set as noted above, then you will need to go to the sys_dictionary table, locate your table label and export the XML from dev and manually import it in to test & prod.



Exporting and Importing XML Files - ServiceNow Wiki


Thank you chuck


Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Dinesh,



Chuck is correct. You should be able to move changes of the customer updates which is captured in the wrong update set.


Mini-Lab: Moving Update Set Customer Update Records


Thanks for the update pradeep