Cannot View Subcollections on Child Sites

When you view subcollections on child sites, some subcollections may be shown in the Systems Management Server (SMS) Administrator console, and others may not appear. For example, one child site may have a specific subcollection, while another child site does not. Note that the missing subcollections are the subcollections that are created from a parent site, not those that are created locally to the child site.

The SMS Administrator console only presents collections that are defined both in the Collections and Collection_SubCollections SQL tables. Because of timing issues, SMS Collection Evaluator and SQL Monitor may not correctly update both tables.

Service Pack Information

To resolve this problem, obtain the latest service pack for Microsoft Systems Management Server 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Hotfix Information

To resolve this problem, obtain the latest service pack for Systems Management Server version 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: The hotfix that was originally provided for the problem described in this Microsoft Knowledge Base article is no longer available. The hotfix that is described in the following Knowledge Base article now supercedes it: To resolve the problem described in this article, install the hotfix that is described in this Microsoft Knowledge Base article (Q324204).

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Systems Management Server 2.0 Service Pack 5.

One method you can use to recover from a situation where subcollections are missing at a child site is to manually update the collection from the site in which it was created. This sends the collection-to-subcollection information back down the hierarchy.