In this post, I will demonstrate System Center Orchestrator upgrade from 1807 to 2019.
- Back up the Orchestrator database.
- Backup all Runbooks (Right click on Runbooks folder and Export)
- Note all the Monitor Runbooks.
- Stop all running runbooks by executing the below query against the Orchestrator database.
USE Orchestrator -- Ensure that this is the name of your Orchestrator database GO Declare @polID nvarchar(40) Declare @SeqNum bigint Declare @getid CURSOR Declare @getid2 CURSOR Set @getid = cursor for SELECT pin.PolicyID, ppq.SeqNumber FROM [SCO].[dbo].[POLICY_PUBLISH_QUEUE] ppq -- Verify database Name LEFT JOIN SCO.dbo.POLICYINSTANCES pin on pin.PolicyID = ppq.PolicyID -- Verify database Name LEFT JOIN SCO.dbo.POLICIES pin2 on pin2.UNiqueID = ppq.PolicyID -- Verify database Name Where AssignedActionServer IS NOT NULL and TimeEnded IS NULL Set @getid2 = cursor for SELECT pin.PolicyID, ppq.SeqNumber FROM [SCO].[dbo].[POLICY_PUBLISH_QUEUE] ppq -- Verify database Name LEFT JOIN SCO.dbo.POLICYINSTANCES pin on pin.PolicyID = ppq.PolicyID -- Verify database Name LEFT JOIN SCO.dbo.POLICIES pin2 on pin2.UNiqueID = ppq.PolicyID -- Verify database Name Where AssignedActionServer IS NOT NULL and TimeEnded IS NULL OPEN @getid Fetch next From @getid into @PolID, @SeqNum WHile @@FETCH_STATUS = 0 Begin EXEC [dbo].[sp_UnpublishPolicyRequest] @PolID, @SeqNum Fetch next From @getid into @PolID, @SeqNum End DECLARE @return_value int EXEC @return_value = [Microsoft.SystemCenter.Orchestrator.Runtime.Internal].[ClearOrphanedRunbookInstances] SELECT 'Return Value' = @return_value Close @getid Deallocate @getid OPEN @getid2 Fetch Next From @getid2 into @PolID, @SeqNum While @@FETCH_STATUS = 0 Begin EXEC [dbo].[sp_PublishPolicy] @PolID Fetch next From @getid2 into @PolID, @SeqNum End Close @getid2 Deallocate @getid2
- Uninstall all 4 Orchestrator components (Control Panel/Uninstall a program)
- Install the Orchestrator 2019 from the installation media.
- Uninstall Integration Packs (IP) and unregister them by using Deployment Manager.
- Register and deploy 2019 IPs using Deployment Manager.
- Install the latest roll ups.
- Reconfigure the Data Store Configuration by entering the database server and selecting the existing database.
- Check if the Orchestrator services are running. If not, start them manually.
- Upgrading Orchestrator resets the root Runbook folder permissions. Modify it accordingly.
- Start all Monitor runbooks.