ReplTip - Troubleshooting sp_msmakegeneration

by Holger Linke, Microsoft SQL Escalation Engineer Symptoms: The merge agent may get stuck without apparent progress, or even fail with a timeout error. If several merge agents are trying to synchronize at the same time, they would block each other, until the agent which is running sp_msmakegeneration finishes the call. If the execution of…


MSSQL_REPL-2147199360 Unable to decide if MakeGeneration is needed.

MSSQL_REPL-2147199360 Unable to decide if MakeGeneration is needed. Chris Skorlinski Microsoft SQL Server Escalation Services Error messages: 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: http://help/0 The merge process failed to execute a query because the query timed…

1