Skip to content
Category: SQL Server
2012-02-08

The merge process was unable to create a new generation at the ‘Publisher’

Yesterday we did an massive update of 1 million of registers in a table of the replication DB, after the update , we started the replication of one computer, and we saw a failure in the first publication after 2000 seconds, showing the next error: “The merge process was unable to create a new generation at the ‘Publisher’. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write.” Checking the replication log, it shows error about Time Out that occurs when the time exceed 300 seconds, but after 6 or 7 attempts when the time exceed 1800 seconds the publications fail showing the error. This error was because the -QueryTimeOut value of Merge Agent profile was 300 seconds and in the Distribution Agents profile was 1800 seconds, then we decide to increase temporally both values to 3600 seconds and the error disappeared, the steps that we realized to modify the value were the next: 1. Right Click over “Replication” and select “Distributor Properties”

2. Click on the “Profile Defaults” button

3. In Distribution Agents , click on “New” to create a new profile, because the system profiles cannot be modified, and select the Default Agent like model

4. Write a name for the profile and change the -QueryTimeOut value, in our case 3600

5. Select the created profile and click “Change Existing Agents”, with this we apply the changes on all the Distributions Agents already created.

6. Now select Merge Agents and repeat all the steps, the first, create a new profile

7. Write a name for the profile and change the -QueryTimeOut value, in our case 3600

8. Select the created profile and click “Change Existing Agents” to apply the changes in all the Merge Agents already created.

9. Click OK in the next two windows and the -QueryTimeOut value will be changed.

10. If this is a temporal value, don’t forget to change it back when finish

Complete este formulario para recibir la guía de Windows Server en Azure
*Obligatorio
Complete este formulario para recibir la guía de Windows Server en Azure
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir 4 best practices to implement a comprehensive Zero Trust security approach
*Obligatorio
Complete este formulario para recibir 4 best practices to implement a comprehensive Zero Trust security approach
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Cloud Migration Essentials
*Obligatorio
Complete este formulario para recibir Cloud Migration Essentials
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
*Obligatorio
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Prevent data leaks with Microsoft 365 Business Premium
*Obligatorio
Complete este formulario para recibir Prevent data leaks with Microsoft 365 Business Premium
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete this form to recieve the guide of Windows Server on Azure
*Required
Complete this form to recieve the guide of Windows Server on Azure
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve 4 best practices to implement a comprehensive Zero Trust security approach
*Required
Complete this form to recieve 4 best practices to implement a comprehensive Zero Trust security approach
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud Migration Essentials
*Required
Complete this form to recieve Cloud Migration Essentials
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud security Advice for Nonprofit Leaders
*Required
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
*Obligatorio
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
Thank you for filling out the form [name]. Here's your Free eBook!