"Invalid column name 'AllowOrionMapsManagement'" when upgrading to SolarWinds 2023.2.4 to 2023.4

11/8/2023 6:18 PM

2/19/2025 8:55 PM

After performing an upgrade to SolarWinds Platform 2023.4, the Configuration Wizard fails with the following error:
 

The following can also be found in the ConfigurationWizard.log file located in C:\ProgramData\SolarWinds\Logs\Orion\:
 

ERROR TaskAdapter - Error running task Orion.ConfigureDatabase SolarWinds Platform Database SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Invalid column name 'AllowOrionMapsManagement'.

Network Performance Monitor

Missing column in the Accounts table of the SolarWinds database.

Resolution 1:
 

1. Connect to the SolarWinds Platform server.
2. Open Database Manager in the SolarWinds Platform folder of the Start menu.
3. Select Add Orion Server.
4. Expand the server selection, right click on the SolarWinds database in bold and select New query...
5. Paste the following in the query window on the right:

   -- 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.
   
   ALTER TABLE [dbo].[Accounts]
   ADD [AllowOrionMapsManagement] [char](1) NULL

6. Select Execute query.
7. Run the Configuration Wizard again.

Resolution 2:

As an alternative resolution, first upgrade to 2020.2.6 as this adds the necessary columns, then upgrade to 2023.4.