New imported Groups have mismatched sys_id between Prod and Dev, causing issues when trasnferring workflows.

galavodasal · ‎07-31-2017

Hi all,

Newly created Groups (imported from AD) do not have matching sys id's between Prod and Dev, causing an issue with workflows when transferred.

I believe we cloned Prod to Dev sometime after implementation, which made the Groups have synced sys id's.

What's the best way to "fix" this without cloning Prod to Dev?

Chuck Tomasi · ‎07-31-2017

Either dev or prod needs to be considered the "source of truth" for your group records. I prefer to make it prod since all the related records have sys_ids that point to the current groups and users, and you don't want to get in to updating all the references throughout the system.

Export the groups (and if necessary, users and group members tables too). sys_user_group, sys_user, and sys_user_grmember respectively.
Delete the records in dev and import the tables from your XML files (from prod)
Update the workflows and anything else in dev that references the "old" groups.
Promote those changes to prod.

View solution in original post

galavodasal · ‎07-31-2017

I agree, and thank you for the advice and recommendations Chuck.

Ok perfect, just wanted to clarify and confirm. Thank you again Chuck.

Pradeep Sharma · ‎07-31-2017

Hello Alexander,

Avoid creating groups in dev and instead, fetch the records from prod via "Importing from Another ServiceNow Instance - ServiceNow Wiki ". and schedule this via schedule data imports http://wiki.servicenow.com/index.php?title=Scheduling_Data_Imports#gsc.tab=0

In the transformation script at import set level, you can set the exact sys_id of the record. Please check section 5.4 for the exact script required.

Importing from Another ServiceNow Instance - ServiceNow Wiki

This will ensure that sys_id's match between prod and dev instance.

galavodasal · ‎07-31-2017

Thank you for the information.

Pradeep Sharma · ‎07-31-2017

You are very welcome Alexander. Let me know if that answered your question. If so, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. Thank you

How To Mark Answers Correct From Community Inbox