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

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 'dbo.RepReplicationTransaction'. The duplicate key value is (31000000000691153).

 

Proposed Solution:

Check the record with key' ' whether record is present in HO db or not using the below query to check the record in HO


Select * from repreplicationTransaction where ReplicationTransactionKey='enter the key for record for which issue is occurring '


Example:-Select * from repreplicationTransaction where ReplicationTransactionKey='31000000000691153'


select * into Backup_repreplicationtransaction from repreplicationtransaction

delete from repreplicationtransaction where replicationTransactionkey='key' and SourceType='enter source key'


    • Related Articles

    • Duplicate replication entry blocking replication from Store to HO

      ******Internal to CitiXsys****** Environment: iVend 6.5 update 6 with SAP B1 9.2 Problem statement: Duplicate replication entry blocking replication from Store to HO Symptoms: Error in Replication log : Violation of PRIMARY KEY constraint ...
    • Replication stuck and Not Moving

      Problem: Replication not moving from HO to Specific Store. Symptoms: Replication Log File Not generated and Event Viewer is showing "INVALID CLASS ERROR" What need to be Check : 1. Right Click on My PC 2. Click on Manage 3. Now Go to Services and ...
    • 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 : ...
    • Replication not working

      Environment: iVend 6.6 Problem Statement: Replication service not working due to controller application Error Screenshot: Solution: - This issue happened due to there’s an error showing from controller application when customer removed this ...
    • Replication not working from store server to HO server.

      Problem Reported - It was observed that Replication does not work from a particular store server to HO server. Cause: Problematic store database was corrupted. Troubleshooting Step: Check the store database health. Run the below command in the store ...