FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016
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)
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 5 for SQL Server 2016 RTM
Cumulative Update 2 for SQL Server 2016 SP1
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
Egenskaber
Artikel-id: 3208243 – Seneste udgave 20. mar. 2017 – Udgave 3
Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2016 Service Pack 1, Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard
