MSSQL_REPL027183

Message Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

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.

Explanation

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.

User Action

To resolve the issue:

See Also

Concepts

Cause and Resolution of Replication Errors

Help and Information

Getting SQL Server 2005 Assistance