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

book

Article ID: 158033

calendar_today

Updated On:

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.