SMS: Failed Child Site Attachment May Cause Duplicate Datakeys in COMM and SPEC Tables (226897)
The information in this article applies to:
- Microsoft Systems Management Server 1.2
This article was previously published under Q226897 SYMPTOMS
When you use Microsoft SQL Server administration tools to directly view the contents of the Systems Management Server (SMS) database, there may be duplicate values in the COMM and SPEC tables. You may also notice tables that start with underscores, such as the following:
CAUSE
When a child site sends its inventory to a parent site on the initial attachment or after running PREINST /SYNCPARENT, the *.UPD directory may not be processed at the parent site. This behavior leaves many of the NextCommonKey and NextSpecificKey values in the GroupMap table set incorrectly. Normal Management Information Format (MIF) processing that occurs afterwards results in the creation of duplicate datakeys in the COMM and SPEC tables.
When the *.UPD directory is not processed completely, there may be tables in the SMS database that begin with an underscore, as in the example in the "Symptoms" section.
STATUSMicrosoft has confirmed that this is a problem in Systems Management Server version 1.2.
| Modification Type: | Minor | Last Reviewed: | 6/14/2005 |
|---|
| Keywords: | kbBug kbConfig kbDatabase kbDataLoader kbinterop kbInventory kbServer KB226897 |
|---|
|