RE: Violation of PRIMARY KEY - Transactional Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JN - 06 Aug 2007 09:02 GMT

Hi All,

I have setup a transactional replication between 2 SQL 2005 servers.

Unfortunately, I am getting the error listed below:

Replication-Replication Distribution Subsystem: agent
JFCIS3TRM02-JFJDAT-JFJDAT_PUBLICATION-JFCIS3TRM01-13 failed.

Violation of PRIMARY KEY constraint 'ARSTRUN_KEY_0'. Cannot insert duplicate
key in object 'dbo.ARSTRUN'.

Is this error being raised because I haven't enabled automatic range
management? If so, how would I fix this error?

Regards,

JN

Reply to this Message

JN - 06 Aug 2007 09:05 GMT

Sorry wrong forum.

"JN" <jnsimex@hotmail.com> wrote in message news:...

> Hi All,
>
[quoted text clipped - 14 lines]
>
> JN

Reply to this Message

David W. Fenton - 06 Aug 2007 22:59 GMT

> I have setup a transactional replication between 2 SQL 2005
> servers

This newsgroup is for Jet Replication, not SQL Server. I would
repost my question in a SQL Server forum.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message