Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Error: Violation of PRIMARY KEY constraint 'PK_Migration_WirelessIndexMapping'. Cannot insert duplicate key in object 'dbo.Migration_WirelessIndexMapping'. The statement has been terminated

Error: Violation of PRIMARY KEY constraint 'PK_Migration_WirelessIndexMapping'. Cannot insert duplicate key in object 'dbo.Migration_WirelessIndexMapping'. The statement has been terminated

Updated June 7, 2017

Overview

The following error is displayed when running the configuration wizard:

Violation of PRIMARY KEY constraint 'PK_Migration_WirelessIndexMapping'. Cannot insert duplicate key in object 'dbo.Migration_WirelessIndexMapping'. The duplicate key value is (22, C, 744).
The statement has been terminated.

Environment

NPM 12.1

Resolution

  1. Check permissions using the Orion Permission Checker.
  2. Rerun the configuration wizard.
 
Or
1. Login to the SQL management studio
2. backup the database (Important!)
3. run the following script against the DB
ALTER TABLE Migration_WirelessIndexMapping DROP CONSTRAINT PK_Migration_WirelessIndexMapping

 

Last modified

Tags

Classifications

Public