Network Management

Database configuration fails with "Invalid column name 'AllowOrionMapsManagement'"during an upgrade to SolarWinds Platform 2023.4 or 2023.4.1

Database configuration fails with the message Error while executing script- Invalid column name 'AllowOrionMapsManagement'.

First published date

11/16/2023 5:33 PM

Last published date

2/18/2025 4:19 PM

Overview

When you attempt to upgrade from Orion Platform 2020.2.1 through 2020.2.5 to SolarWinds Platform 2023.4 or 2023.4.1, database configuration fails. The Configuration Wizard displays the following message:

Database configuration failed:
Error while executing script- Invalid column name 'AllowOrionMapsManagement'.

This error occurs in deployments that have at least one user account without administrative privileges.

Product section

Orion Platform

Cause

This issue occurs due to a database column is missing from the Accounts table.

Resolution

To resolve this problem, please upgrade to SolarWinds Platform 2023.4.2 and above.

If you encounter this issue, complete the following steps. If you are planning to upgrade to an affected version and you want to avoid this issue, complete steps 1 and 2 before starting the upgrade.

Download upgrade_fix.zip and extract the files on the database server.
Run the script.
Rerun the Configuration Wizard.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.