I have a replication for many databases on one server to one SQL Server database and to Oracle. Replication for one database is not working while the other four databases are working. For SQL Server to SQL Server, there is one publication. For SQL Server to Oracle, there are 6 publications.

Also CDC is enabled on those databases.

The error messages are:

Process could not execute 'sp_replcmds' on 'DBname'
Failed to insert rows into Change Data Capture ....
The statement has been terminated.

When I look on the replication monitor tabs, Publisher to Distributor history is failing but Distributor to Subscriber history is working. The agent is failing.

  • Can you rebuild the replication? – Krismorte Feb 1 '18 at 14:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.