Error during Configuration Wizard: “The index 'IX_NetFlowAddressToResolveLowPriority_Timestamp' is dependent on column 'Reason'” when upgrading to SolarWinds Platform 2025.4

11/6/2025 4:08 PM

4/4/2026 12:36 AM

During an upgrade to SolarWinds Platform 2025.4, the Configuration Wizard may fail during the database configuration phase. The following error is displayed:

 

Database configuration failed:

• Error while executing script - The index 'IX_NetFlowAddressToResolveLowPriority_Timestamp' is dependent on column 'Reason'.
ALTER TABLE DROP COLUMN Reason failed because one or more objects access this column.

The following corresponding entries may appear in the Configuration Wizard log in C:\ProgramData\SolarWinds\Logs\Orion:

ERROR DBConfigProcessor - Error while executing script - The index 'IX_NetFlowAddressToResolveLowPriority_Timestamp' is dependent on column 'Reason'.
ALTER TABLE DROP COLUMN Reason failed because one or more objects access this column.

System.Data.SqlClient.SqlException (0x80131904): The index 'IX_NetFlowAddressToResolveLowPriority_Timestamp' is dependent on column 'Reason'.

Failing Sql command:
IF EXISTS (SELECT 1 FROM sys.columns WHERE Name = N'Reason' AND Object_ID = Object_ID(N'[dbo].[NetFlowAddressToResolveLowPriorityIPv4]'))
BEGIN
    ALTER TABLE [dbo].[NetFlowAddressToResolveLowPriorityIPv4] DROP COLUMN [Reason];
END

This prevents the upgrade from completing successfully and halts the Configuration Wizard process.

Hybrid Cloud Observability

This issue occurs because the upgrade script attempts to drop the Reason column from the table [dbo].[NetFlowAddressToResolveLowPriorityIPv4], but an existing index (IX_NetFlowAddressToResolveLowPriority_Timestamp) still depends on that column.

SQL Server does not allow a column to be dropped while dependent objects (such as indexes, constraints, or statistics) still reference it.

To resolve the issue, please upgrade to SolarWinds Platform 2026.1 and above.  If an upgrade is not possible, perform the following steps to manually drop the dependent index before rerunning the Configuration Wizard.

Important: Always back up the SolarWinds database before making any direct SQL modifications.

1. Connect to your SQL Server instance hosting the SolarWinds database.
2. Run the following SQL script in SQL Server Management Studio (SSMS):

-- 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.

-- Drop the dependent index if exists
IF EXISTS (SELECT name FROM sys.indexes WHERE name = 'IX_NetFlowAddressToResolveLowPriority_Timestamp' AND object_id = OBJECT_ID('dbo.NetFlowAddressToResolveLowPriorityIPv4'))
BEGIN
    DROP INDEX IX_NetFlowAddressToResolveLowPriority_Timestamp ON dbo.NetFlowAddressToResolveLowPriorityIPv4;
END

-- Now, drop the "Reason" column
ALTER TABLE dbo.NetFlowAddressToResolveLowPriorityIPv4 DROP COLUMN Reason;

3. Re-run the Configuration Wizard.