Customized addon events in Replication Records Stuck for Stores on HO Replication Dashboard

Customized addon events in Replication Records Stuck for Stores on HO Replication Dashboard

Internal Purpose

Environment : iVend 6.6

Problem Statement : It was noticed that iVend Enterprise replication monitor has add-on related records ,stucked for long time and need to ignore it .

​

Symptoms : Customized Addons were applied on iVend Enterprise MC to be replicated towards Stores

Resolution/Work Around : It was noticed that iVend Enterprise replication monitor has add-on related records ,stucked for long time and need to ignore it .If it is the case, bellow steps can be used :

  1. Please execute below queries on HO Database :

 

Delete from RepReplicationTransaction where SourceType in (6000,6001)

 

Delete from RepReplicationTransactionDetail Where ReplicationTransactionKey IN

(select ReplicationTransactionKey from RepReplicationTransaction where SourceType in (6000,6001))

 

 

Delete from RepReplicationTransactionDetailSend Where ReplicationTransactionKey IN

(select ReplicationTransactionKey from RepReplicationTransaction where SourceType in (6000,6001))

 

  1. Once above queries executed successfully go to HO Replication Dashboard.
  2. Please refresh the dashboard and verify the records.
  3. All add-on related records will be cleared from HO Replication dashboard.


Recommendations /Suggestion : Such SQL queries should be executed with Support Team.


    • Related Articles

    • Replication records stuck/ not moving from HO to all available stores

      Product Version 6.5 Update 5 Incident Reference: INC0011720 Problem Statement: Replication records stuck/ not moving from HO to all available stores Details: Replication records were stuck at HO and piled up for each and every store and they were not ...

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

    • Replication not working: Specific Replication records are stuck from store to HO

      Version: 6.5 Update 6 Issue: Some records from a store are stuck in the replication monitor which is never being replicated to Enterprise. Steps: Restarted the server, the configuration manager and Replication service however the issue remains the ...

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

    • Records are not moving from HO to Stores(iVend 6.5 Update 6)

      Problem: Records are not moving from HO to Stores(iVend 6.5 Update 6). However, records from store to HO replicating fine. Or Getting an error "No upgrade license found" in the replication Log file Troubleshooting Steps: Please check the replication ...