Update Set movement

[DMC046]

Hello,

I am attempting to transfer update sets from our development instance to the production environment. I have successfully captured and marked the local update set as complete. However, when I create a new connection in the update source and test the connection, I receive the following error: "Authentication to remote instance failed. Method Failed: Http:/ 1.1 401 unauthorized with code: 401." I am using my administrative credentials, which I use to log into ServiceNow, but the error persists.

Could you please assist me in resolving this issue?

Thank you.

[Robbie · Accepted solution]

Hi @DMC046,

Just to clarify, when setting up the connection between environments, you need to use the account credentials for the account you're attempting to connect to. For example, if trying to connect to Dev form Prod, you need to use the Dev credentials. Additionally, you need to make sure that account has the correct admin role. Please however read below before proceeding.

Before I offer an alternative and in my view a more targeted approach for moving update sets, can I just confirm where or how you are verifying your update set packages? Do you have a Test environment? I assume you have 3 environment in total - Dev, Test and Prod.

It is absolutely recommended to test your update sets in a Test environment before deploying to Production.

Based on this assumption, I would ensure that the connection between Prod and lower environments should actually be between Prod and Test, not Prod and Dev.

For a more targeted approach to move update sets (and ensure you only move what you need to rather, rather than all / any 'completed' update sets).  You can simply export the update set by clicking on the 'Export to xml' related link from within the update set record itself - this will download the update set and associated xml files.

On the instance you wish to push the update set(s) to, you can type 'Retrieved update sets' into the Navigation menu, and from here you can 'Import xml'. Once imported you can preview and manage the update set as required including commit.

To view the ServiceNow support site for the error you're experiencing, see here: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0535247

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.




Thanks, Robbie

[DMC046]

Thanks for your response, Robbie. We only have 2 environments Prod and Dev. I am capturing the update sets by going into local update sets on Dev and trying to retrieve them on Prod through update source. I am an admin on both Prod and Dev, however I get the 401 unauthorized error. 

I will try the XML approach today and will keep you posted if I run into any issues.

Thanks,

Pavan

[Robbie]

Hi @DMC046,

That is a difficult situation to manage - you are unable to test the update set itself (or release package as I like to call it).

Exporting and importing update sets however is a targeted approach, and one I favour.

I appreciate you mention you have an account for both Dev and Prod, and both accounts have the admin role. For security reason these should be different accounts, and therefor, when connect from Prod to Dev, you need to make sure on the connection to Dev you use your Dev credentials.

Regardless however, you can bypass this with the favoured export and imprt approach as I explain above.

Let me know how you go. I'd also recommend putting a case together for a 3rd ServiceNow instance to sit in between Dev and Prod so as to Test code and updates. Let me know if you need help with that.

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.




Thanks, Robbie

[DMC046]

Hi Robbie,

So I tried moving the update sets using the export and import options, however I get the below error message Could not find a record in sys_hub_flow for column flow_designer_flow referenced in this update.

I have tried all possible solutions I found on service now forum 
Could not find a record in sys_hub_flow for column... - ServiceNow Community
Solved: Flow action update set - Could not find a record i... - ServiceNow Community
How do I edit the Category of a Flow - ServiceNow Community

However when Export and Import I still get the same issue. Any suggestions? I am trying to move a catalog item from Dev to Prod.