The merge process was unable to create a new generation at the ‘Subscriber’
Merge replication fails with below error
Error:
The merge process was unable to create a new generation at the ‘Publisher’
Unable to decide if MakeGeneration is needed
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 which to write.
Verbose Error log:
The merge process was unable to create a new generation at the ‘Subscriber’. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200994)Get help: http://help/MSSQL_REPL-2147200994
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200994)Get help: http://help/MSSQL_REPL-2147200994
Resolution:
Change the generation_leveling_threshold to 0 in sysmergepublications table in publisher and in subscriber. Do not update the system tables directly.
Follow the steps mentioned in workaround section of http://support.microsoft.com/kb/953568
SQLServerScribbles.COM 