Violation of PRIMARY KEY constraint 'PK_sysnotificationuser'.cannot insert duplicate key in object

****** Internal to CitiXsys******

Environment:

6.6 Patch 7608

Problem Statement: 

Getting error while restoring the backup file at a new store.

Symptom:

Below is the error message:

'violation of PRIMARY KEY constraint 'PK_sysnotificationuser'.cannot insert duplicate key in object dbo.SysnotificationUser'

Cause:

Seems huge data in table SysnotificationUser causing the issue.

Solution: 

1) We ran SQL queries and excluded tables "SysNotification, SysNotificationUser" at HO Database so that these tables are not included in backup at HO.

2) Then took a fresh backup from Enterprise MC which got restored at Store successfully.

3) Below are the queries used to exclude the tables taken from backup:

Select * from RepObjectMapDB where TableName like '%notification%' and ObjectID in (370, 371)

--Update RepObjectMapDB set ExcludeInStoreBackup = 1 where TableName like '%notification%' and ObjectID in (370, 371)

• Related Articles

• Violation of PRIMARY KEY constraint 'PK_TrxTransaction'. Cannot insert duplicate key in object 'dbo.

  Product Version: iVend 6.5 Update 6 Replication Problem Statement: One of their store replication monitor logs is not moving from both sides (Enterprise and store) and its culminating in the replication monitor. Replication log file: Error message : ...

• During EndOfDay the error message"Violation of PRIMARY KEY constraint'PK_RtlStoreData_1'is displayed

  Environment: iVend 6.5 Update 6 Problem Statement: At the time of End of day below message appear “Violation of PRIMARY KEY constraint 'PK_RtlStoreData_1'. Cannot insert duplicate key in object 'dbo.RtlStoreData'.” Proposed Solution: With such an ...

• commit failed object type transaction sale item key"key number"

  Problem Statement :- Getting an error "commit failed object type transaction sale item key"key number" while completing the sale transaction . Proposed solution:- Check the POS log file if below error occur "Violation of PRIMARY KEY constraint ...

• Replication from store to HO not working (duplicate key in object)

  Internal document Problem Statement: Replication is not moving from the store to HO. The replication log error shows: 2627:Violation of PRIMARY KEY constraint 'PK_ReplicationTransaction'. Cannot insert duplicate key in object ...

• iVend Primary Key Violation issue after Re-initialize of Store

  Product Version: 6.5 Update 6 Patch 2 Problem Statement - Primary Key Violation issue after Re-initialize of Store. Proposed Solution: - We require to increase sysnextnumber for smooth function of store. Steps if any: Below are the steps we require ...