Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > Violation of Primary Key PK_UDT_PortToEndPointCounts

Violation of Primary Key PK_UDT_PortToEndPointCounts

Created by Kevin Twomey, last modified by MindTouch on Jun 23, 2016

Views: 16 Votes: 1 Revisions: 4

 

Overview

Completing the Orion Configuration Wizard

The configuration wizard has failed

Database configuration failed:

Error while executing script- Violation of PRIMARY KEY constraint 'PK_UDT_PortToEndPointCounts'. Cannot insert duplicate key in object 'dbo.UDT_PortToEndpointCounts'. The duplicate key value is (327336).

The statement has been terminated.

Environment

  • NPM 12
  • UDT 3.2.2

Resolution

As a workaround, empty the script in UDT installation directory:

  1. Go to C:\Program Files (x86)\SolarWinds\Orion\UDT\UDTDatabaseScheme.dbConfig and create a backup of the file in your desktop.
  2. Edit the original file by by selecting all and deleting the whole content. Save.
  3. Configuration Wizard will bypass UDT.
  4. Upgrade UDT 3.2.4 which will replace the the same file(UDTDatabaseScheme.dbConfig).

 

Last modified
00:01, 23 Jun 2016

Tags

Classifications

Public