We have had a long time where we have been unable to refresh DEV from PROD.
If we had, stuff like this wouldn't happen.
Here's what happened...
I had fruition build a workflow in DEV. We moved it to TEST. The assignment group
The script to spot the differences and figure out how to reconcile
var gr = new GlideRecord('sys_user_group'); gr.addQuery('sys_id','ff7d513901daa0c094adf4b82250a606'); gr.query(); while(gr.next()) { gs.print("group name = " + gr.name); } var gr2 = new GlideRecord('sys_user_group'); gr2.addQuery('name','STARTSWITH','INF'); gr2.query(); while(gr2.next()) { gs.print("group name = " + gr2.name + " and sysid: " + gr2.sys_id); }
Then to fix
I had to blow away the bad record for INF Telecom group from sys_user_group on DEV, and import the XML export from the record in TEST.
Then I needed to make a new update set, revise the workflow, save the changes, promote the changes in the update set to TEST. And update the requirement to mention the second update set.