Capture multiple Tables (With Associations) and Fields in an update set

wasimakhtar
Tera Contributor

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.

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@wasimakhtar 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@wasimakhtar 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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

wasimakhtar
Tera Contributor

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.