Submit a ticketCall us
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