Capture multiple Tables (With Associations) and Fields in an update set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 03:17 AM
Hey there
I have a custom app with 4 tables in a global scope. Let say the 4 tables are Tab1, Tab2, Tab3 and Tab4.
Tab3 and Tab4 are associated with Tab1 and Tab1 is associated with Tab2.
What is the best way to move these tables from a legacy instance to OOTB new instance. I have already tried multiple ways to achieve it.
1. Created a new update set and then from the Table details page clicked on Related Links > "Add to Update Set" for all the 4 tables.
2. Created separate update sets for each table and then committed in the sequence Tab3, Tab4, Tab1 and then Tab2
3. Tried renaming all the customer updates and update sets which is associated with these table.
But none of the above worked and I am getting 1000's of error
- sys_ui_list(1000) "Could not find a table field (Tab1.active) referenced in this update"
- sys_security_acl(100): Could not find a record in sys_security_attribute for column security_attribute referenced in this update
- sys_ui_actions(100): Could not find a record in sys_ui_action for column sys_overrides referenced in this update
- sys_ui_section(100): Could not find a table field (Tab1.priority) referenced in this update.
Please help. Let me know if more information is needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 04:14 AM
did you create those in custom scope or in global scope only?
Did you not capture those in an update set of Global scope?
Do this
1) create an update set in global scope
2) go to sys_update_xml and search your customer updates and move them to your above update set
3) then migrate this update set to other instance
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 08:00 PM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 11:46 PM
Hi Ankur
Yes, I created the update set in global scope.
And I have already tried this approach, but the problem is there are more than 300 update sets related to these 4 tables and around 10k customer updates. Few of the update sets have around 100 customer updates with only 2 or 3 related to these tables. I have to make sure whatever I choose should be relevant to my app. I cannot be 100% sure that I have selected the correct customer updates and nothing relevant is being missed. So, I wanted a clean approach to move my app to the new OOTB instance.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2025 11:44 PM
Hi Ankur
Yes, I created the update set in global scope.
And I have already tried this approach, but the problem is there are more than 300 update sets related to these 4 tables and around 10k customer updates. Few of the update sets have around 100 customer updates with only 2 or 3 related to these tables. I have to make sure whatever I choose should be relevant to my app. I cannot be 100% sure that I have selected the correct customer updates and nothing relevant is being missed. So, I wanted a clean approach to move my app to the new OOTB instance.