Re: Violation of PRIMARY KEY constraint - seems to occur with replication??

can you post the problem table's schema here and your publication script?

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



<claudioillanes@xxxxxxxxx> wrote in message
news:1169059327.466679.64500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

Yes, I debugged my web application to the point before it calls the
update or insert statement. At that point, I took this statement and
ran it through query analyser but the same error message occured.


Hilary Cotter wrote:
can you reproduce these errors if you manually enter data through Query
Analyzer?

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



<claudioillanes@xxxxxxxxx> wrote in message
news:1169057911.075911.311890@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi everyone,

I've got a major issue on a state production system that I need to
resolve in 24 hours. I have two servers running with Merge Replication,
and when editing web gui data, only one of them saves correctly
(performs a valid INSERT). The other server gives the following
exception anytime I try and do an INSERT:

sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint
'PK__VARIABLE__164452B1'. Cannot insert duplicate key in object
'VARIABLES_LOG'.

I am stumped. This only happens on one server, and both servers have
exhibited this behaviour in the last 2 weeks. I am using SQL Server
2000 with the Microsoft SQL Server 2005 JDBC drivers v. 1.1. These
drivers state that they can be used with SQL Server 2000. I'm not sure
if the merge replication that I have setup might be causing this. Does
anyone have any insight on this??

Any help is greatly appreciated!!!

Claudio




.

Relevant Pages

  • Re: Single point of failure
    ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Single point of failure
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... publisher and subscriber to each other and to the other publishers ...
    (microsoft.public.sqlserver.replication)
  • Re: Article Defaults --> cant change
    ... >> Hilary Cotter ... >> Looking for a SQL Server replication book? ... >>> We don't want data deleted on the subscribers when data is deleted on ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication is Broken
    ... Hilary Cotter ... Looking for a SQL Server replication book? ... > tablenick the name of that table or is it something else? ...
    (microsoft.public.sqlserver.replication)
  • Re: UPDATE Statements May be Replicated as DELETE/INSERT Pairs
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.replication)