Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

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 Kevin.Swinson on Nov 09, 2017

Views: 35 Votes: 0 Revisions: 5

Updated August 31st, 2016

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

Tags

Classifications

Public