SQL Agent Is Timing Out Due To High Latency

You might see the followng error message in the Replication Monitor or Error Logs during replication.

 

 

"Unable to decide if MakeGeneration is needed. (Source: MSSQL_REPL. Error number: MSSQL_REPL-2147199360) Get Help: http://help/MSSQL_REPL-2147199360

Query timeout expired (Source: MSSQLServer, Error Number 0) Get help://help/0

The merge process failed to execute a query because the query timed out. If this failure continues, increase the query timeout for the process. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to whichto write (Source: MSSQLServer, Error number: 0)"

 

OR

"Replication-Replication Merge Subsystem: agent NOV-DEPOT\AUTODESKVAU-Project_Mayhem-ADMS_Project_Mayhem-ACRD-DEPOT\AUTODESKVA-25 failed. The process failed to get information about the Custom Resolver Component for article 'SchemePattern' from the registry."

 

This indicates that either the -LoginTimeOut or -QueryTimeOut values need to be increased.

These values can be specified on the merge agent command line, but it would need to be done per-subscriber, per-database
    http://msdn.microsoft.com/en-us/library/ms151326.aspx
    http://msdn.microsoft.com/en-us/library/ms147839.aspx