Violation of PRIMARY KEY constraint - seems to occur with replication??
- From: claudioillanes@xxxxxxxxx
- Date: 17 Jan 2007 10:18:31 -0800
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
.
- Follow-Ups:
- Re: Violation of PRIMARY KEY constraint - seems to occur with replication??
- From: Paul Ibison
- Re: Violation of PRIMARY KEY constraint - seems to occur with replication??
- From: Hilary Cotter
- Re: Violation of PRIMARY KEY constraint - seems to occur with replication??
- Prev by Date: RE: How to obtain 'Last Database Backup' time from within VB
- Next by Date: Re: Violation of PRIMARY KEY constraint - seems to occur with replication??
- Previous by thread: RE: How to obtain 'Last Database Backup' time from within VB
- Next by thread: Re: Violation of PRIMARY KEY constraint - seems to occur with replication??
- Index(es):
Relevant Pages
|
