Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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: 290 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