FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016

Gælder for: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise Flere

Symptoms

When you add a subscription to an Oracle transactional publication or an Oracle snapshot publication in SQL Server 2014 or 2016, you receive the following error message:

A publication must have at least one article before a subscription to it can be created.
The subscription could not be found.
Changed database context to 'distribution'. (Microsoft SQL Server, Error: 14124)

Resolution

This issue is fixed in the following cumulative update for SQL Server:

Cumulative Update 5 for SQL Server 2016 RTM

Cumulative Update 2 for SQL Server 2016 SP1

Cumulative Update 3 for SQL Server 2014 Service Pack 2

About cumulative updates for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology Microsoft uses to describe software updates.

Third-party information disclaimer

Senest opdateret: 20. mar. 2017

Løste dette dit problem?