Replication related issue,

Question

Replication related issue,

I am explaining my architecture .

I have created , its transactinal replication process

1. 2 Publisher on table vendors script I have given below,
2. A Distributor
3. 2 Subscribers

Data replication set up is like this as :

Table VENDORS gets replicated from 2-publishers to 2-subcribers via-Distributor.

While replication, ERROR issued in Distributor database as :

Here, What must happen is

Pub1 (creates pubs table vendors) –> inserts (vendors) data to Distributor. -> pull by subscribers

What is happening now for me is ,

Pub1 (creates pubs table vendors-done) -> Throws error at distributor database as

Replication-Replication Distribution Subsystem: agent abc-serv1\PRD01-star-star Billing-PROD-VREPL1\REPL01-25 failed. Violation of PRIMARY KEY constraint 'PK_vendors'. Cannot insert duplicate key in object 'dbo.vendors'.

Error is issued while operation is done between Publishers to Distributor.

Answer 1

The Primary Key at the Publisher has to be maintained at the Subscriber when using Transactional Replication. It sounds as though a record with the given key value already exists at the Subscriber.

From your topology description you have two separate Publications.

So:

• Subscriber 1 receives Publication 1
• Subscriber 2 receives Publication 2

Is there any crossover i.e. can Subscriber 2 also receives Publication 1. If so then you will encounter Primary Key conflicts unless you manage the key ranges on both Publishers or use an alternative Replication technology, such as Merge Replication.