Error: Violation of PRIMARY KEY constraint 'PK__Resource__XXXXX'. Cannot insert duplicate key in object 'dbo.ResourceMerge'. The duplicate key value is

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

Active computers are not populating the database with current data.

Module: AeXSVC.exe

Source: Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.OnMessage_Impl

Description: Failed to process NSE :

( Exception Details: Altiris.NS.Exceptions.AeXException: Unable to update the specified item from the Altiris NS database ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Resource__XXXXXXXXXXXXXXXX'. Cannot insert duplicate key in object 'dbo.ResourceMerge'. The duplicate key value is (COMPUTER_NAME (COMPUTER_GUID)).

 

Module: AeXSVC.exe

Source: Altiris.NS.ClientMessaging.EventQueueDispatcher.Dispatch

Description: EventQueueDispatcher::Dispatch

( Exception Details: Altiris.NS.Exceptions.AeXException: Unable to update the specified item from the Altiris NS database ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Resource__XXXXX'. Cannot insert duplicate key in object 'dbo.ResourceMerge'. The duplicate key value is (COMPUTER_NAME (COMPUTER_GUID))

Cause

The computer has been merged, however the guid the computer has is the old guid causing it to be blocked every time new data is sent.

Resolution

This has been resolved in in the v5 rollup for version 7.1 SP2 MP1.  If the server is not at this level the steps in TECH206171 can be used until the server can be updated.