Network Management
Configuration Wizard fails with "Cannot insert the value NULL into column 'PolledStatus'" during upgrade to SolarWinds Platform 2026.4
During the upgrade to SolarWinds Platform 2026.4, the Configuration Wizard can fail while migrating legacy node data into the new NodesDataSplit tables. This article explains why this happens and how to complete the upgrade.
First published date
Last published date
Overview
The SolarWinds Platform 2026.4 introduces NodesDataSplit tables, which split the legacy NodesData table into partitioned tables (NodesDataSplitData_man_x / NodesDataSplitData_poll_x).
The dbm_MigrateMEData stored procedure copies existing rows into these partitions. The legacy PolledStatus column in NodesData allows NULL values, while the corresponding column in NodesDataSplitData_XX_X is defined as NOT NULL with a DEFAULT. As a result, any existing row with a NULL PolledStatus causes the migration to fail.
When running the Configuration Wizard, you may get this error:
Error while executing script- dbm_MigrateMEData: Cannot insert the value NULL into column 'PolledStatus', table 'SolarWindsOrion.dbo.NodesDataSplitData_poll_4'; column does not allow nulls. INSERT fails. INSERT INTO [dbo].[NodesDataSplitData_man_1]
If you attempt to run the Configuration Wizard again, you will get a different error when selecting the database:
"Couldn't connect to database SolarWindsOrion! The database is not a SolarWinds Platform database or configuration is not finished"
Product section
Cause
Legacy NodesData rows with a NULL PolledStatus value fail to migrate into the non-nullable NodesDataSplitData_XX_X.
Resolution
This issue is addressed in SolarWinds Platform 2026.4.1. Consider upgrading your environment. If you can't upgrade, perform the workaround steps below:
-
If the Configuration Wizard has already failed, restore the SolarWinds database to the backup taken before the Configuration Wizard ran, while keeping 2026.4 installed.
-
Identify the affected nodes by running the following query against the SolarWinds database:
SELECT NodeID, Caption, ObjectSubType, Status, PolledStatus FROM dbo.NodesData WHERE PolledStatus IS NULL;
-- 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. -
Update the affected rows with a valid, non-NULL PolledStatus value (for example, 2 for Down):
The correct status will be restored automatically once polling resumes after the upgrade.UPDATE dbo.NodesData SET PolledStatus = 2 WHERE PolledStatus IS NULL;
-- 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. -
Re-run the Configuration Wizard to complete the upgrade.