Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Transaction Replication problem

edited Jul 18, 2017 7:53AM in Retail Point-of-Service Solutions (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center