Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    11

    Question Unanswered: Transaction Replication Primary Key Error

    We had a replication running great in production, but we never had a developemental one. So we decide to create an developemental replication mimic the production servers. We have 4 merge publication and 2 transational publication. All works great except one transactional publication, and it's giving out this error.

    Last Commands: {call sp_MSget_repl_commands(31, ?, 0, 7500000)}

    Error Message: Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__0CF73DED'. Cannot insert duplicate key in object '#0C0319B4'.

    Error Detail: Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__0CF73DED'. Cannot insert duplicate key in object '#0C0319B4'.
    (Source: MASTER(Data source); Error number: 2627)
    ------------------------------------------------------------------------------------

    The wired thing is that there were no transaction available for this publication, but this error appear anyway.

    Can anyone tell me what the problem is?
    Last edited by acyu0318; 05-20-03 at 20:20.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    CHeck for any duplicates in the data, and try to drop and recreate constraints during this process. Refer to SQL error log for any other information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •