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) > Configuration wizard error: Error while executing script- Foreign key 'FK_AlertActive_AlertObjects' references invalid column 'AlertObjectID' in referenced table 'dbo.AlertObjects'. Could not create constraint. See previous errors

Configuration wizard error: Error while executing script- Foreign key 'FK_AlertActive_AlertObjects' references invalid column 'AlertObjectID' in referenced table 'dbo.AlertObjects'. Could not create constraint. See previous errors

Created by Norsolihati Selamat, last modified by Aileen de Lara_ret on Aug 31, 2016

Views: 16 Votes: 0 Revisions: 4

Overview

When upgrading to NPM 11.5, the following Configuration Wizard error occurs:
Error while executing script- Foreign key 'FK_AlertActive_AlertObjects' references invalid column 'AlertObjectID' in referenced table 'dbo.AlertObjects'.
Could not create constraint. See previous errors.

Environment

NPM version 11.5 and earlier

 

Cause 

The error is caused by created tables named AlertObjects in the past. New alerting (NPM 11.5 onwards) needs this table name reserved. 

Resolution

Note: Create a full backup of your database before making any direct changes. 

To resolve this error:

  1. Open SQL Management Studio.
  2. Locate AlerObject and delete it.
  3. Re-run the Configuration Wizard.

 

 

 

 

Last modified
23:02, 30 Aug 2016

Tags

Classifications

Public