Applications Systems
Configuration Wizard fails with Invalid column name 'ProbeType' during upgrade
The Configuration Wizard may fail during the database configuration stage with the error Invalid column name 'ProbeType' while running the migration script Migrate\116_WPM_Remove_IE_FromDatabase.sql. This issue has been observed in some environments during upgrades from affected pre-fix builds, but it does not affect every upgrade.
First published date
Last published date
Overview
This issue is related to WPM/SEUM schema cleanup during upgrade. In affected environments, the migration script attempts to reference or remove legacy columns such as ProbeType from dbo.SEUM_Recordings, but the database schema is already partially changed or out of sync, which causes the Configuration Wizard to fail.
You may see the following in the Configuration Wizard:
-
SolarWinds Platform Database FAILED
-
Database configuration failed
-
Error while executing script - Invalid column name
ProbeType -
Failing SQL command:
Migrate\116_WPM_Remove_IE_FromDatabase.sql
Figure 1 below shows a sample Configuration Wizard failure for this issue.
Figure 1: Configuration Wizard database failure showing invalid column name ProbeType.
The ConfigurationWizard log can show entries similar to the following: ERROR DBConfigProcessor - Error while executing script - Invalid column name 'ProbeType' and the failing command may reference Migrate\116_WPM_Remove_IE_FromDatabase.sql.
Product section
Cause
In affected environments, the WPM cleanup migration expects legacy columns such as ProbeType to be available in dbo.SEUM_Recordings while processing Internet Explorer recording cleanup. If the column is already absent, the migration can fail with Invalid column name 'ProbeType'.
Resolution
Before making changes, create a backup of the SolarWinds Platform database and take a snapshot of the server.
-
Open the following file in a text editor with administrative privileges:
D:\Program Files\SolarWinds\Orion\OrionCoreDatabaseScheme.dbConfigor the equivalent SolarWinds installation path on the server. -
Locate the following script block:
Migrate\116_WPM_Remove_IE_FromDatabase.sql. -
Change the condition from:
IF [dbo].[GetSEUMDbVersion]() < 7to:
IF [dbo].[GetSEUMDbVersion]() < 6 -
Save the file.
-
Re-run the SolarWinds Platform Configuration Wizard as administrator.
This workaround has resolved the issue in affected cases and allowed the Configuration Wizard to complete successfully.