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

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

    • Replication from HO to store or from store to HO is freezed

      Environment: 6.5 updates 6 and before Problem Statement: Replication is not working between store and Enterprise Resolution: One of the basic reasons for replication not working can be the replication service not working correctly or there is SQL ...

    • iVend Replication showing red symbol in connected status on the replication dashboard

      Environment : 6.6 integrated with SAP Symptoms: Replication was not working from Store to Enterprise and Vic Versa. Problem Statement : Enterprise and store showing a red symbol in connected status on the replication dashboard. Resolution/Work ...

    • Steps to create New Store in iVend

      Environment iVend 6.6 7989 Query Steps to create New Store in iVend HO MC Answer One can follow our e-Learning Video on Store Creation from below link/ portal: It is also suggested to create Store backup file from iVend Enterprise MC in downtime when ...