Share via

Troubleshooting SQL Server Replication Error During Version Upgrade

Vanitha Dodla (MINDTREE LIMITED) 40 Reputation points Microsoft Vendor
2024-05-22T03:50:56.0266667+00:00

How can we resolve a Replication error that occurs when trying to include certain tables in a Publication after migrating from SQL Server 2012 to SQL Server 2019? Removing the affected articles is a temporary solution, but the issue persists for 10 tables. The error logs show "error 14151 Replication-Replication Transaction-Log Reader Subsystem: agent failed" when we reproduced the issue. What are the steps to identify and implement a permanent solution to this problem?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LucyChenMSFT-4874 2,090 Reputation points
    2024-05-22T05:55:34.5866667+00:00

    Hi @Vanitha Dodla (MINDTREE LIMITED) ,

    Thanks for your information.

    This error can occur in a number of situations; here are some suggestions you can follow:

    • Restart the failed agent to see if it will now run without failures.
    • Check the agent history and job history for other errors that occurred around the same time.
    • Verify that basic connectivity is working between the computers accessed by the agent.
    • If the error occurs while creating or applying a snapshot, check the files in the snapshot directory for errors.
    • If the error continues to occur, increase the logging of the agent and specify an output file for the log.

    In addition, depending on the context of the error, you can check this known issue and follow the steps it provides.

    Feel free to share with us if you have any confused.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications