Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQL_REPL027183

Product Name

SQL Server

Product Version

10.0

Product Build Number

 

Event ID

27183

Event Source

MSSQLSERVER

Component

SQL Server Database Engine

Symbolic Name

Message Text

The merge process failed to enumerate changes in articles with parameterized row filters. If this failure continues, increase the query timeout for this process, reduce the retention period for the publication, and improve indexes on published tables.

This error is raised if a Merge Agent timeout occurs while processing changes in a filtered publication. The timeout might be caused by one of the following issues:

  • Not using the precomputed partitions optimization.

  • Index fragmentation on columns used for filtering.

  • Large merge metadata tables, such as MSmerge_tombstone, MSmerge_contents, and MSmerge_genhistory.

  • Filtered tables that are not joined on a unique key and join filters that involve a large number of tables.

To resolve the issue:

  • Increase the value of the -QueryTimeOut parameter for the Merge Agent to allow processing to continue while you address the underlying issues causing the error. Agent parameters can be specified in agent profiles and on the command line. For more information, see:

  • Use the precomputed partitions optimization if possible. This optimization is used by default if a number of publication requirements are met. For more information about these requirements, see Optimize Parameterized Filter Performance with Precomputed Partitions. If the publication does not meet these requirements, consider redesigning the publication.

  • Specify the lowest setting possible for the publication retention period, because replication cannot clean up metadata in the publication and subscription databases until the retention period is reached. For more information, see Subscription Expiration and Deactivation.

  • As part of maintenance for merge replication, occasionally check the growth of the system tables associated with merge replication: MSmerge_contents, MSmerge_genhistory, and MSmerge_tombstone, MSmerge_current_partition_mappings, and MSmerge_past_partition_mappings. Periodically re-index these tables. For more information, see Reorganize and Rebuild Indexes.

  • Ensure that columns used for filtering are properly indexed and rebuild such indexes if necessary. For more information, see Reorganize and Rebuild Indexes.

  • Set the join_unique_key property for join filters that are based on unique columns. For more information, see Join Filters.

  • Limit the number of tables in the join filter hierarchy. If you are generating join filters of five or more tables, consider other solutions: do not filter tables that are small, not subject to change, or are primarily lookup tables. Use join filters only between tables that must be partitioned among subscriptions.

  • Make a smaller number of changes on filtered tables between synchronizations, or run the Merge Agent more frequently. For more information about setting synchronization schedules, see Specify Synchronization Schedules.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.