iVend 6.6 Replication Issue post applying patch it was throwing line number error in SendDump

iVend 6.6 Replication Issue post applying patch it was throwing line number error in SendDump

iVend Version:

6.6 Patch (7723)


Error Details:

SendDumpProcessor: error : Cannot update identity column 'LineNumber'.,

paylaod :B448FEC3-B6FC-41F6-8891-0957FD7FA3FC : Site ID 1


Steps: 

The Steps to resolve the Issue are explained below:


Step 1:

Stop Replication App Pool at HO and Store through IIS (Internet Information Server)


Step 2:

On the receiving machine execute following commands as:

Delete from RepReplicationReceivedEvents Where ReceiveSiteId = <Site ID of the Site from where Data is coming>

Delete from RepReplicationReceivedPayload Where SiteId = <Site ID of the Site from where Data is coming>

 

Step 3:

Run the following queries on the Site i.e. transmitting the data

Delete from RepReplicationTransaction Where ReplicationTransactionKey NOT IN 

(Select ReplicationTransactionKey from RepReplicationTransactionDetailSend WITH (NOLOCK)

UNION

Select ReplicationTransactionKey from RepReplicationTransactionDetail WITH (NOLOCK))

TRUNCATE TABLE RepReplicationTransactionDetail

TRUNCATE TABLE RepReplicationTransactionDetailSend

TRUNCATE TABLE RepReplicationSendDump

Update RepReplicationTransaction SET SendDumpSequenceNumber = NULL

 

Step 4:

Open Command Prompt with Administrative Privileges' and run command IISReset at both Store and HO 

Start Replication App Pool at IIS both at Store and HO through IIS (Internet Information Server)

 


    • Related Articles

    • 6.6 iVend Retail - Patch Deployment Process

      Query: How to plan iVend 6.6 upgrade and Patch update? Solution: Please follow the attached "iVend 6.6 Patch deployment Process" document. Additional Information: Patch deployment process document is available in Download section of iVend retail. In ...

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

    • Microsoft Azure is available in ivend if yes in which patch level or version

      Product version: iVend 6.6 Problem statement: Kindly update us about single sign on for Microsoft Azure is available in ivend if yes in which patch level or version ?? Proposed solution/workaround: SSO is not feasible through custom development in ...

    • iVend Patch not getting updated at POS

      Environment: iVend 6.6 Patch 7915 Problem Description: Patches in HO and the POS indicates that it has already been updated but in POS it stays in a cycle asking for an update and does not allow it to be done. Scenario: None Solution: 1) At POS the ...