Export (0) Print
Expand All

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:

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft