The information in this article applies to:
BUG# NT: 11493 (6.00) SYMPTOMS
If the last subscription to an article is removed while there are still
outstanding unreplicated transactions in the published database log, the
LogReader task for replication can fail with the following error:
where xxx = the value of xactid_page and yyy = the value of xactid_row in the MSjobs table in the distribution database. The LogReader task will fail and be shutdown in this situation. No replication transactions for the published database will be processed until the error is corrected. Since the log cannot be truncated past the oldest unreplicated transaction, the log may fill to a point where Msg 1105 will be encountered. WORKAROUND
Find the row in MSjob in the distribution database whose xactid_page
and xactid_row match the values listed in the error message above. This
row should contain the maximum job_id value for the table.
STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider. MORE INFORMATION
This problem has been observed only when the transaction reported in
the error above has been truncated from the log and the LogReader
task is restarted. If the LogReader task is never restarted, then the
error may not occur. The problem can only occur if the all subscriptions
have been removed for all articles in the publication.
Additional query words: sql6 windows nt
Keywords : kbprg SSrvProg kbbug6.00 kbfix6.00.sp2 |
Last Reviewed: April 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |