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.


0
0
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

Description

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.