none
复制问题 RRS feed

  • 问题

  • 发布服务器无法为订阅分配一组新的标识范围。这可能会在以下两种情况下发生: 当发布服务器或重新发布的订阅服务器已用尽了标识范围,无法为自己的订阅服务器分配标识范围时;或者标识列的数据类型不支持分配更多的标识范围时。如果重新发布的订阅服务器已用尽标识范围,请同步重新发布的订阅服务器以获取更多的标识范围,然后才重新启动同步。如果发布服务器已用尽标识范围,请验证数据类型的大小是否支持所需的标识范围。  (源: MSSQL_REPL,错误号: MSSQL_REPL-2147199417)

    请问这个问题,怎么解决?

    2010年8月1日 2:30

全部回复

  • MSSQL_REPL-2147199417

     Message Details

    Product Name

    SQL Server

    Product Version

    10.50

    Product Build Number

     

    Event ID

    -2147199417

    Event Source

    MSSQLServer

    Symbolic Name

     

    Message Text

    The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identity ranges, verify that the size of the data type supports the needed identity ranges.

     Explanation

    The merge process failed. This could have occurred because either the top-level Publisher or republisher could not allocate a new range. In the Publisher case, the Publisher's identity range allocation could not be increased. This is because the range needed to allocate exceeds the maximum or minimum value allowed for the data type. In the republisher case, the republisher has run out of the republishing range for allocation.

     User Action

    To allocate a new republishing range, run the merge between the republisher and the top-level Publisher to allocate more range to the republisher. If the Publisher runs out of range, evaluate the data type used for the identity column.


    Mark as Answer if it helps. This posting is provided "AS IS" with no warranties, confers no rights.
    2010年8月4日 2:26
  • 按提示的方法,我也重新做过。总是做过以后一、两天能好,过几天还是提示相同的问题。
    2010年8月12日 2:42