Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

Push transactional replication fail with violation of primary key

I'm running transactional replication, distribution agent found fail due to the last action was duplicating, what should I do now to solve this kind of problem?
Avatar of Aneesh
Flag of Canada image

what is your sql server(s) version\edition\SP?
also check:
See related problem and solution:

"How to....... have 2 publications with one table in common?  "
  The same table may be added to each publication. However, one of the publications will need to be set up as a no-sync and if you are using automatic range management you'll receive a PK error like this:

Violation of PRIMARY KEY constraint 'PK__MSrepl_identity___4D5F7D71'. Cannot insert duplicate key in object 'MSrepl_identity_range'.

So, on the upload-only publication you'll just need to disable automatic range management for your table article
Avatar of imran_fast

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial