Transaction Replication problem
Hi Mosc,
we have implemented the cluster node to replicate the transactions from store to xcenter
we have two nodes to replicate the transactions , in replication status i could see the
Cluster member name of this Xcenter instance: xcent-prod-01
Members in cluster: 2
Cluster members, store ranges:
xcent-prod-01-(this instance)
Store Range : orgId 1000, storeId 0{0}..<218
Store Range : orgId 1000, storeId 0{0}..<218
xcent-prod-02-
Store Range : orgId 1000, storeId >=218..max{999+}
Store Range : orgId 1000, storeId >=218..max{999+}
But in rpl_replication_data table in xcenter replication schema, we could see the transaction publish_status as 'ERROR' and the error details are
dtv.data2.access.exception.PrimaryKeyViolationException: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'pk_trn_trans'. Cannot insert duplicate key in object 'dbo.trn_trans'. The duplicate key value is (1000, 250, Jul 10 2017 12:00AM, 1, 77450).