Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Replication error after SP3

4 views
Skip to first unread message

Daniel

unread,
Nov 6, 2003, 6:46:15 PM11/6/03
to
any idea why i'm getting this error on replication

All old subscription created on SP2 are working properly.
We install SP3 to solve problem with overload of CPU (100% - sqlserver continuosly).

After installing SP3 I've encoutered next problem trying to create new transactional subscription.
Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__2813BD1E'.
Cannot insert duplicate key in object '#271F98E5'.

After looking thru the microsoft site I found a reference that seemed
close so I tried next:
add the param @loopback_detection = 'true'
to
sp_addsubscription

but it didin't work.

We need to solve this problem till sunday - new location are starting !
Thks.

Hilary Cotter

unread,
Nov 6, 2003, 8:23:29 PM11/6/03
to
can you script out your publication, tables and post them here?
"Daniel" <anon...@discussions.microsoft.com> wrote in message
news:D70CD02F-043D-471C...@microsoft.com...

Daniel Barbalic

unread,
Nov 8, 2003, 7:12:15 AM11/8/03
to
Solution:

Change of store procedure in distibution: sp_MSget_repl_commands

from:
declare @snapshot_seqnos table (subscription_seqno varchar(16) primary key)
in:
declare @snapshot_seqnos table (subscription_seqno varbinary(16) primary
key)

Regards,
Daniel


0 new messages