Upgrade fails due to Configuration Wizard error linked to '_dta' index

The following can be seen in the log at C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log:

2026-04-17 12:01:52,860 [13] ERROR DBConfigProcessor - Error while executing script - The index '_dta_index_IPAM_Node_7_1412200081__K5_K1_K2_K4_K7_K8_3_9_11_12_14_15_16_18_20_21_23_25_28_30_32' is dependent on column 'IPNodeId'.
The index '_dta_index_IPAM_Node_7_1412200081__K2_K1_K12_K28_K5_3_4_7_8_9_11_14_15_16_18_20_21_23_25_30_32' is dependent on column 'IPNodeId'.
ALTER TABLE ALTER COLUMN IPNodeId failed because one or more objects access this column..
 Error details: System.Data.SqlClient.SqlException (0x80131904): The index '_dta_index_IPAM_Node_7_1412200081__K5_K1_K2_K4_K7_K8_3_9_11_12_14_15_16_18_20_21_23_25_28_30_32' is dependent on column 'IPNodeId'.
The index '_dta_index_IPAM_Node_7_1412200081__K2_K1_K12_K28_K5_3_4_7_8_9_11_14_15_16_18_20_21_23_25_30_32' is dependent on column 'IPNodeId'.
ALTER TABLE ALTER COLUMN IPNodeId failed because one or more objects access this column.

2026-04-17 12:01:52,860 [13] ERROR DBConfigProcessor - Failed on C:\Program Files (x86)\SolarWinds\Orion\OrionCoreDatabaseScheme.dbConfig script with error SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- The index '_dta_index_IPAM_Node_7_1412200081__K5_K1_K2_K4_K7_K8_3_9_11_12_14_15_16_18_20_21_23_25_28_30_32' is dependent on column 'IPNodeId'.
The index '_dta_index_IPAM_Node_7_1412200081__K2_K1_K12_K28_K5_3_4_7_8_9_11_14_15_16_18_20_21_23_25_30_32' is dependent on column 'IPNodeId'.
ALTER TABLE ALTER COLUMN IPNodeId failed because one or more objects access this column.

2026-04-17 12:01:52,876 [13] ERROR TaskAdapter - Error running task Orion.ConfigureDatabase SolarWinds Platform Database
SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- The index '_dta_index_IPAM_Node_7_1412200081__K5_K1_K2_K4_K7_K8_3_9_11_12_14_15_16_18_20_21_23_25_28_30_32' is dependent on column 'IPNodeId'.
The index '_dta_index_IPAM_Node_7_1412200081__K2_K1_K12_K28_K5_3_4_7_8_9_11_14_15_16_18_20_21_23_25_30_32' is dependent on column 'IPNodeId'.
ALTER TABLE ALTER COLUMN IPNodeId failed because one or more objects access this column.

The indexes and statistics that start with the prefix _dta

Back up the database first before proceeding.

1. Run the query below directly from SQL Server Management Studio:

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

DECLARE @sql NVARCHAR(MAX) = N'';
SELECT @sql += 'DROP INDEX ' + QUOTENAME(i.name) + ' ON ' + QUOTENAME(SCHEMA_NAME(t.schema_id)) + '.' + QUOTENAME(t.name) + ';'
FROM sys.indexes i
INNER JOIN sys.tables t ON i.object_id = t.object_id
WHERE i.name LIKE '_dta%';

2. Turn off the Database tuning advisor by running the next script.

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

-- Disable automatic plan forcing (reverting to last good plan)
ALTER DATABASE [YourDatabaseName] 
SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = OFF );

3. Once done, re-run the Configuration Wizard.