Logreader failed after upgrade. - by MSSales Dev

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 339520 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 4/23/2008 12:00:27 AM
Access Restriction Public


encountered an issue with replication on JANA after upgrade. The replication log reader agent for database PANSALES is failing with these error:

2008-04-17 06:28:42.53 spid86      Error: 5243, Severity: 22, State: 4.
2008-04-17 06:28:42.53 spid86      An inconsistency was detected during an internal operation. Please contact technical support.
2008-04-17 06:28:42.55 spid85      Error: 14151, Severity: 18, State: 1.
2008-04-17 06:28:42.55 spid85      Replication-Replication Transaction-Log Reader Subsystem: agent JANA-PanSales-1 failed. The process could not execute 'sp_replcmds' on 'JANA'.

A note from Maria Balsamo 
Ensure customer knows run logreader until it processes all pending logs before upgrade – or do it for them
Sign in to post a comment.
Posted by Microsoft on 11/4/2008 at 3:41 PM
Will add documentation for this in next release.
Posted by Qun [MSFT] on 4/24/2008 at 3:01 PM
Thanks for letting us know, we will make sure this requirement (drain log before upgrade) is reflected in BOL.
Posted by Microsoft on 4/24/2008 at 11:06 AM
It is required to drain the log before upgrade, We are trying to make this a rule in the upgrade advisor to mitigate chances of other customers running into the issue.