Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Netflow Traffic Analyzer (NTA) > 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: 152 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
14:32, 10 Jan 2017

Tags

Classifications

Public