Post reply

Merge replication conflicts on Identity Colums

  • July 18, 2007 at 8:17 am

    #174511

    Hi all,

    I'm calling on your services yet again ! Hopefully one of you good people will be able to help.

    I've set up a merge replication using sql server 2005.

    All settings for "Copy Use Triggers" were set to false

    All Identity ranges were set to be handled automatically.

    There is a table - "Stock" - which has an ident field. An insert trigger on this table inserts a new record into another table - "barcodes" - which itself has its own ident field.

    When a new "stock" record is inserted on the subscriber I get a merge conflict which says:

    "A row insert at 'xxx.YYYYYYYYY' could not be propagated to 'zzz.YYYYYYYYY'. This failure can be caused by a constraint violation. Explicit value must be specified for identity column in table 'barcodes' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column."

    It suggested I use sp_adjustpublisheridentityrange, which I did on both tables, but still the conflict won't resolve.

    Any suggestions will be most gratefully received

    Thanks

    Ken

  • July 18, 2007 at 12:54 pm

    #720504

    you need to mark all user triggers as "not for replication" just in case you did copy triggers (or someone put one) on the subscriber !


    * Noel

  • July 19, 2007 at 6:52 am

    #720729

    Thanks for your response Noel, but the only triggers on the subscriber database are those put on by the replication agent.

    Any more ideas?

    Thanks

    Ken

  • July 23, 2007 at 2:58 am

    #721463

    Can you post the insert trigger script ?

     

    -- rob

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply