SQL Server Performance

Identity Range error

Discussion in 'Performance Tuning for SQL Server Replication' started by brianswestra, Nov 15, 2005.

  1. brianswestra New Member

    Hello all,

    I have received a new error #548 that states:

    "The identity range managed by replication is full and must be updated by a replication agent. The %ls conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls. Sp_adjustpublisheridentityrange can be called to get a new identity range."

    I was under the impression that by setting up the Identity field "not for replication" and using the built-in method for handling identity ranges in merge replication, SQL Server would automatically implement this for new identity ranges.

    This may be my problem; the identity range was set to 100 with a 80% fill rate. The error occurred when my application tried to insert 10,000 records at one time at the publisher.

    Any thoughts?
    Thanks again in advance,
    Brian
  2. dineshasanka Moderator

  3. satya Moderator

    Dinesh
    The first link you referred is for SQL 2005 and in SQL 2000 it is bit different as specified in other article. (I don't think problem is with SQL 2005 replication)

    Brian
    Check these KBAshttp://support.microsoft.com/kb/321879 &http://support.microsoft.com/default.aspx?scid=kb;en-us;830210 also for further information.

    This linkhttp://www.simple-talk.com/2005/07/05/replication/ explains the scenario with details.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. brianswestra New Member

    Excellent! After some research the problem was indeed setting a range much lower than needed for one and only one application call to create over 10,000 records at a time...

    Thanks again!!!
    Brian

Share This Page