Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA - Knowledgebase Articles > Database configuration failed: Error while executing script- Violation of PRIMARY KEY constraint 'PK_NetFlowTransactionLog'. Cannot insert duplicate key in object 'dbo.NetFlowTransactionLog'. The statement has been terminated

Database configuration failed: Error while executing script- Violation of PRIMARY KEY constraint 'PK_NetFlowTransactionLog'. Cannot insert duplicate key in object 'dbo.NetFlowTransactionLog'. The statement has been terminated

Created by Norsolihati Selamat, last modified by Alexander Aguilar on Jan 10, 2017

Views: 1,223 Votes: 1 Revisions: 8

Overview

Configuration Wizard ends with the following error:
Database configuration failed: Error while executing script- Violation of PRIMARY KEY constraint 'PK_NetFlowTransactionLog'. Cannot insert duplicate key in object 'dbo.NetFlowTransactionLog'. The statement has been terminated

Environment

NTA 4.0 and earlier

Resolution

Note: Make sure to backup your database before making any direct changes.

  1. Log in to SQL Management Studio in SQL server using an SQL sa account.
  2. Run the following query against the Orion/SolarWinds database:
    GO
    IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[NetFlowTransactionLog]') AND name = N'PK_NetFlowTransactionLog')
    ALTER TABLE [dbo].[NetFlowTransactionLog] DROP CONSTRAINT [PK_NetFlowTransactionLog]
    GO
  3. Re-run the Configuration Wizard.

 

Last modified

Tags

Classifications

Public