Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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

Cannot insert NULL value into column "IsGroupOfEntity"

Created by Marjune Obana, last modified by MindTouch on Jun 23, 2016

Views: 123 Votes: 0 Revisions: 19

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
21:49, 22 Jun 2016

Tags

Classifications

Public