Duplicate replication entry blocking replication from Store to HO

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 'PK_ReplicationTransaction'. Cannot insert duplicate key in object 'dbo.RepReplicationTransaction'. The duplicate key value is (22000000000923477).
The statement has been terminated. for record number:1000000000000018

Resolution/Work Around:

Delete the duplicate record from HO DB Repreplicationtransation table in order to make room for new record from store.
Note : take table backup before removing the record and check thoroughly.

Recommendations/Suggestion:

This is resolved in latest version  of iVend i.e 6.6

    • Related Articles

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

    • Addon information was not updated for newly created store

      Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...

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

    • Require to make the inventory as Zero for particular store

      Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...

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