none
Replication Error after in-place upgrade to SQL Server 2019 RRS feed

  • Question

  • Hello All,

    Good Day!

    I have a transactional replication with pull subscriber configured between 2 Always node.  Below is my topology

    Publisher:

    Server A, Server B, Server C in a AlwaysON cluster and version SQL Server 2016

    Distributor:

    Server D Standalone server in SQL Server 2019

    Subscriber:

    Server E, Server F in another AlwaysON Cluster and version SQL Server 2016.

    I had upgraded the Subscriber AlwaysON cluster to SQL Server 2019 CU4 through in-place upgrade approach. 

    • Upgrade was successful and AlwaysON is in sync.
    • Logreader is working fine and the replication monitor is also good from publisher to distributor.
    • But the distributor job is between retries and below is the error observed.

                   2020-05-21 18:37:25.208 Startup Delay: 1841 (msecs)
                   2020-05-21 18:37:27.067 Connecting to Subscriber ''
                   2020-05-21 18:37:27.114 Agent message code 207. Invalid column name 'job_login'.

    This error is not specific to any user tables as it is appearing across all the distributor job.  And in my observation there are new two column addition in the "MSdistribution_agents" system table, "job_login" and "job_password" either in 2017 or 2019 and causing this problem.

    Anyone experienced similar problems?

    Friday, May 22, 2020 6:19 AM

Answers

All replies