Transactional Replication Issue

• tapaskumardm

  SSC Eights!

  Points: 812

  More actions

  November 15, 2012 at 11:22 pm

  #264851

  Hi,

  I am using sql server 2008. and a Transactional replication is running between Oracle to SQL.

  Publisher: Oracle

  Distributor: SQL Server 2008

  Subscriber : SQL Server 2005.

  And my Replication was running fine. But last week SP3 patches has been installed to SQL Server 2008. Replication is running , but the agent status is 'between entries' with the below message.

  Can somebody have the proper solution to resolve the issue.(High Priority)

  Thanks in advance.....

  Message

  Error: 14151, Severity: 18, State: 1.

  Message:

  Replication-Replication Transaction-Log Reader Subsystem: agent 'XXX-XXX' failed.

  The version of SQL Server used to download the Oracle package code does not match the version

  of SQL Server running at the distributor. The replication support code at the Oracle publisher

  needs to be refreshed.

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  November 16, 2012 at 9:40 am

  #1559858

  Please go through this article--

  http://msdn.microsoft.com/en-us/library/ms152516.aspx