iVend Replication not working from Store to Enterprise

iVend Replication not working from Store to Enterprise

Product version: 

6.5 Update6

 

Problem statement :

Replication was not working from Store to Enterprise

 

Proposed solution: 

In this case we require to check replication log file  on below path C:\Program Files (x86)\CitiXsys\iVend Retail\Replication and found below error

 

5/14/2019 8:20:30 PM : Invalid column name 'Comment'.

------------------------------------------------------------------------------------------

5/14/2019 8:20:30 PM : 207:Invalid column name 'Comment'. for record number:1000000000000001

------------------------------------------------------------------------------------------

5/14/2019 8:20:30 PM : Query Failed to execute: if exists(select 1 From CusCustomer where CustomerKey = 1000000000000001) 


we found that  record was not correct in rereplicationsendump table CusCustomer which was causing the issue. Comment column does not exist on Table CusCustomer.

 

So we  corrected data through Sql query which made the replication work.

 

Steps if any:

NA


Constraints / Scenarios : 

NA


    • Related Articles

    • 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 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 at store(s) (TLS 1.2)

      Environment:  6.6 Problem statement:  Replication not working at store(s). Symptoms: It was observed that at iVend Enterprise/Store where the "iVend Cloud Security Enhancements"(TLS 1.2) enabled, does not have the compatible TLS 1.2 replication ...

    • 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 is not working for Offline POS

      Problem Statement: Replication is not working for Offline POS as shown below (Connection status Is Red): Symptoms: Below are the known symptoms: API Service is either not configured or working properly. IIS (Internet information services) is not ...