Operational Defect Database

BugZero found this defect 67 days ago.

Microsoft SQL Server | 2693175

Fixes the following errors that you encounter when using sp_addsubscription to create the Subscriber on secondary replicas if the distribution database is in an availability group: Msg 20032, Level 16, State 1, Procedure distribution.dbo.sp_MSadd_subscription, Line <LineNumber> [Batch Start Line 33] <SubscriberName> is not defined as a Subscriber for <PublisherName>. Msg 14070, Level 16, State 1, Procedure sys.sp_MSrepl_changesubstatus, Line <LineNumber> [Batch Start Line 33] Could not update the distribution database subscription table. The subscription status could not be changed. Msg 14057, Level 16, State 1, Procedure sys.sp_MSrepl_addsubscription_article, Line <LineNumber> [Batch Start Line 33] The subscription could not be created.

Last update date:

3/14/2024

Affected products:

SQL Server 2022 on Linux

SQL Server 2022 on Windows

Affected releases:

build lower than 16.0.4115.5

Fixed releases:

16.0.4115.5

Description:

Fixes the following errors that you encounter when using sp_addsubscription to create the Subscriber on secondary replicas if the distribution database is in an availability group: Msg 20032, Level 16, State 1, Procedure distribution.dbo.sp_MSadd_subscription, Line <LineNumber> [Batch Start Line 33] <SubscriberName> is not defined as a Subscriber for <PublisherName>. Msg 14070, Level 16, State 1, Procedure sys.sp_MSrepl_changesubstatus, Line <LineNumber> [Batch Start Line 33] Could not update the distribution database subscription table. The subscription status could not be changed. Msg 14057, Level 16, State 1, Procedure sys.sp_MSrepl_addsubscription_article, Line <LineNumber> [Batch Start Line 33] The subscription could not be created.

Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Unavailable

Learn More

Search:

...