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

10/5/2026 4:17 PM

Last published date

10/28/2026 2:27 PM

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

Orion Platform

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:

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

  2. 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.
  3. Update the affected rows with a valid, non-NULL PolledStatus value (for example, 2 for Down):

    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.
    The correct status will be restored automatically once polling resumes after the upgrade.
  4. Re-run the Configuration Wizard to complete the upgrade.