Tag: MakeGeneration

ReplTip – Troubleshooting sp_msmakegeneration

Chris Skorlinski [MSFT] Troubleshooting September 20, 2015

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
Read More »

MSSQL_REPL-2147199360 Unable to decide if MakeGeneration is needed.

ReplTalk Inside Replication, Troubleshooting April 24, 2011

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 out. If this failure continues, increase the query timeout for the process. When troubleshooting, restart
Read More »