Re: violation of unique constraint in distribution database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
Date: Mon, 5 Mar 2007 10:04:41 -0500

What is the exact error message you are getting? Is it this one?

"Violation of PRIMARY KEY
constraint 'PK__@snapshot_seqnos__2E23455'. Cannot insert
duplicate key in object '#2E0AB83D'."

The numbers could be different.

If this is the case apply the latest sp again.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Sal" <Sal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F857942-2A59-4BFF-893F-3AE1D304E2CA@xxxxxxxxxxxxxxxx

Hi:

we are getting violation of unique constraint in distribution database.
We
stoped and restarted the distribution agent but still the same error.
There
are no duplicates in publisher and/or subscriber. It seems like a record
was deleted in publisher but did not get deleted in subscriber and later
was
reinserted. I can't really find much in distribution database. Not sure
how
to troubleshoot this. Can someone help us resolve this?

Thanks

Prev by Date: Re: Cannot create subscription for a SQL Server 2005 Mobile database
Next by Date: Minor Error 25081,The new value generated for the inserted row is outside the range for an INTEGER or BIGINT data type.
Previous by thread: Re: violation of unique constraint in distribution database
Next by thread: Re: Sql Replication log Reader Agent
Index(es):
- Date
- Thread

Relevant Pages

PK violation error during replication
... Violation of PRIMARY KEY ... constraint 'PK__@snapshot_seqnos__66DE2538'. ... duplicate key in object '#65EA00FF'. ...
(microsoft.public.sqlserver.server)
Violation of primary key
... Violation of PRIMARY KEY constraint 'PK_CUSTOM2'. ... duplicate key in object 'MHGROUP.Custom2' ...
(comp.databases.ms-sqlserver)
bcp has primary key contraint error
... I would put an output on the bcp, ... Violation of PRIMARY KEY constraint 'table_name'. ... insert duplicate key in object 'table_name'. ...
(microsoft.public.sqlserver.server)
Re: Too many args when running a stored procedure
... > ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, ... >> What's the exact error message text you're receiving? ... >>> the primary key only and work up from there but the primary key insert ... >>> didnt work either. ...
(microsoft.public.dotnet.languages.vb)
Re: normalization review
... Having one phone have a number of lines has no impact on the normalization ... violation. ... The location column does not depend on the ENTIRE primary key! ...
(comp.databases.theory)