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

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: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
    ... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
    (microsoft.public.sqlserver.replication)
  • Re: High Availability
    ... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
    (microsoft.public.sqlserver.clustering)
  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)
  • Re: QUEUE READER - A FREQUENT PROBLEM!
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... queue table and the same transaction coldn't be inserted at the ...
    (microsoft.public.sqlserver.replication)
  • Re: QUEUE READER - A FREQUENT PROBLEM!
    ... opinion what is the best choice: instal sp on sql server 2000 or install sql ... We are experimenting sql server 2005 replication making crash ... queue table and the same transaction coldn't be inserted at the ...
    (microsoft.public.sqlserver.replication)
Loading