Observability

Configuration Wizard ERROR Cannot ALTER Column after upgrading to 2025.1. Database configuration failed.

After the upgrade to 2025.1 the configuration wizard fails with, "Database configuration failed"

First published date

5/6/2025 12:01 AM

Last published date

5/6/2025 11:38 PM

Overview

After upgrading to 2025.1, the Configuration Wizard fails with a similar error as the example below, which can be seen in the Configuration Wizard log at C:\ProgramData\SolarWinds\Logs\Orion:

 

2025-04-24 20:03:17,709 [10] ERROR DBConfigProcessor - Error while executing script - 
dbm_AlterTableColumn: dbm_AlterTableColumn: Cannot ALTER column: [LastTimeUp] on a table: 
[APM_CurrentComponentStatus]! This is an indexed column used by following index(es): 
[_dta_index_APM_CurrentComponentStatus_5_1438680223__col__], 
[IX_APM_CurrentComponentStatus_ApplicationID_Timestamp]! All parameters: @table_name: 
APM_CurrentComponentStatus, @column_name: LastTimeUp, @new_data_type: datetime2(7)
dbm_AlterTableColumn: dbm_AlterTableColumn: Cannot ALTER column: [TimeStamp] on a table: 
[APM_CurrentComponentStatus]! This is an indexed column used by following index(es): 
[_dta_index_APM_CurrentComponentStatus_5_1438680223__K5_K1_3_4], 
[_dta_index_APM_CurrentComponentStatus_5_1438680223__K1_K5_3_4], 
[_dta_index_APM_CurrentComponentStatus_5_1438680223__K1_3_4], 
[_dta_index_APM_CurrentComponentStatus_5_1438680223__K5_K1_3_4_1912],

Product section

Hybrid Cloud Observability

Cause

This is being caused by custom indices that were created on these tables by the database tuner tool.

 

[_dta_index_APM_CurrentComponentStatus_5_1438680223__K1_K5_3_4], [_dta_index_APM_CurrentComponentStatus_5_1438680223__K1_3_4], [_dta_index_APM_CurrentComponentStatus_5_1438680223__K5_K1_3_4_1912], [_dta_index_APM_CurrentComponentStatus_5_1438680223__K1_K5_3_4_4149], [_dta_index_APM_CurrentComponentStatus_5_1438680223__col__], [_dta_index_APM_CurrentComponentStatus_5_1438680223__K5_K1_3_4_2533], 

Resolution

To resolve this, the custom indexes must be removed from the tables that are shown in the ERRORs. The tables are listed in the error as seen below:

Cannot ALTER column: [TimeStamp] on a table: [APM_CurrentComponentStatus]! 

Using SQL Management Studio, navigate to this table and remove the indexes. You can right-click ->Delete the unwanted indexes.

They will be listed on the following:

Once all of the custom indexes are removed, the Configuration Wizard will complete as expected.