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

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

Article Id: 158033

Status: Published

Updated On: 23-07-2013 08:10

Legacy Id: TECH206473

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.