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

asked on

Push transactional replication fail with violation of primary key

Hi,
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
Aneesh
Flag of Canada image

what is your sql server(s) version\edition\SP?
also check:
http://www.replicationanswers.com/General.asp
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
 
ASKER CERTIFIED SOLUTION
Avatar of imran_fast
imran_fast

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