BUG: Subscriptions are incorrectly marked as inactive even if the subscriptions are synchronized within the maximum transaction retention period in SQL Server 7.0 (834670)



The information in this article applies to:

  • Microsoft SQL Server 7.0

BUG #: 200053 (SQL Server 7.0)

SQL Server 7.0:200053

SYMPTOMS

In Microsoft SQL Server 7.0, although the subscriptions are synchronized within the maximum transaction retention period of the distribution database, the Distribution Cleanup Agent that is running on the distributor may incorrectly mark the subscriptions as inactive. Therefore, the Distribution Agent may fail, and you may notice the following error message in the Error message pane of the Distribution Agent Error Details dialog box.

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section of this article.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

823649 FIX: Subscriptions are incorrectly marked inactive although the subscriptions are synchronized in the retention period


Modification Type:MajorLast Reviewed:2/13/2004
Keywords:kbnofix kbReplication kberrmsg kbBug KB834670 kbAudDeveloper