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