Network Management

Unable to cancel SolarWinds Platform Upgrade to 2025.1.1 after Pollers go Offline and snapshot restore

While running an upgrade from the Centralized Upgrade page you may run into an issue where it can't continue or restart after the Additional Polling Engines or Additional Web Servers reboot.

First published date

8/15/2019 4:35 PM

Last published date

6/3/2025 11:05 PM

Overview

There is a flag in the database that needs to be manually cleared if you cant continue or cancel the upgrade. 

Product section

Orion Platform

Cause

This is caused when the Main Polling Engine can't reconnect to one or a few Additional Polling Engines or Addition Web Servers after a reboot or restart of services. 

Resolution

Open Database Manager or SQL Server Management Studio and run the below query on the SolarWinds database to clear the flag. 
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE [dbo].[swa_installationsession] SET Isactive=0

After it updates the row, you can either
  • Retry the Centralized Upgrade.
  • Run the Orion Installer manually to upgrade the Additional Polling Engines and the Additional Web Servers.