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 ...