Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Cannot insert NULL value into column "IsGroupOfEntity"

Cannot insert NULL value into column "IsGroupOfEntity"

Updated March 11th, 2016

Overview

The following error message appears during the Configuration Wizard process:

Database configuration failed. Errorwhile executing script - Cannot insert the NULL value into column "IsGroupOfEntity', table 'SolarWindsOrion.dbo.LimitationTypes'; column does not allow nulls. INSERT fails.

cannot_insert_null.png

Environment

All NPM versions.

Resolution

  1. Open SQL Management Studio.
  2. Go to Tools > Options > Designers.
  3. Under Table Options, deselect Prevent saving changes that require table recreation.
    01.png
  4. Expand the Orion table to show the tables under the database.
  5. Right click on the LimitationType table and click Design.
  6. Select the Allow Nulls check box for IsGroupOfEntity.
    02.png
  7. Rerun Configuration Wizard.
  8. Go to Tools > Options > Designers.
  9. Under Table Options, select Prevent saving changes that require table recreation.

If this does not work, refer to the following article:

Database configuration failed: Error while executing script- Cannot insert the value NULL into column IsGroupOfEntity, table Bozz_Orion.dbo.LimitationTypes; column does not allow nulls

Cause

The limitation types table is having issues through NULL values.

Last modified

Tags

Classifications

Public