FIX: Adding a subscription to an Oracle transactional publication or an Oracle snapshot publication fails in SQL Server 2014 or 2016
Content provided by Microsoft
Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 EnterpriseSQL Server 2014 Enterprise CoreSQL Server 2014 Enterprise CoreMicrosoft SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise CoreSQL Server 2016 StandardMore
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)
This issue is fixed in the following cumulative update for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.