"Error while executing script- The index 'RouterNodeID_Includes' is dependent on column 'FirstSeen'." error in Configuration Wizard during upgrade to SolarWinds Platform2025.4

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

SolarWinds® Platform Database FAILED

Database configuration failed:
    •  Error while executing script- The index 'RouterNodeID_Includes' is dependent on column 'FirstSeen'.
ALTER TABLE ALTER COLUMN FirstSeen failed because one or more objects access this column.

The error occurs because an index is dependent on a column being dropped during the upgrade script execution.

Run the query below against the SolarWinds database using SQL Server Management Studio. Before proceeding, ensure that a current backup of the database is in place.

-- 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 = 'RouterNodeID_Includes' AND object_id = OBJECT_ID('dbo.UDT_IPAddressCurrent'))
BEGIN
    DROP INDEX RouterNodeID_Includes ON dbo.UDT_IPAddressCurrent;
END

Run the Configuration Wizard again and ensure it completes successfully.