Article ID: 903933
Article Last Modified on 10/25/2006
APPLIES TO
- Microsoft Systems Management Server 2003
SYMPTOMS
If you change the name of a Microsoft Systems Management Server (SMS) 2003 Advanced Client computer, the delta hardware inventory that is subsequently created is rejected. This behavior causes a resynchronization or a full inventory to occur.
Additionally, all inventory history for the previous computer name is removed from the SMS site database.
Note SMS retains current inventory information for the new computer name. SMS removes only the inventory history.
CAUSE
This issue occurs because SMS sends a pragma delete statement in the initial delta inventory record that follows the client computer name change. This behavior is documented in the log information that is included in the "More Information" section.
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Systems Management Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
885643 How To obtain the latest Systems Management Server 2003 service pack
The hotfix that is described in this article prevents the pragma delete statements for the system architecture group from being processed for a specific client. If a class that contains the old computer name is being updated, the delta hardware inventory may still be rejected. However, a subsequent full inventory is accepted. Inventory history for the previous computer name is retained. If inventory history for a renamed computer was removed before this hotfix was applied, the inventory history is not automatically recovered.
This hotfix should be applied to any primary SMS site, child or parent, that might process inventory data for computers that are renamed.
Download information
The following file is available for download from the Microsoft Download Center:
Download the 903933 package now.
Release Date: October 3, 2005
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
Prerequisites
You must be running SMS 2003 Service Pack 1 to install this hotfix.
Restart requirement
You do not have to restart the computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace any other hotfix. However, the following article in the Microsoft Knowledge Base also describes this hotfix:
872772 Other child sites are unexpectedly removed after you delete a child site from the parent site in Systems Management Server
File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name -------------------------------------------------------------- 25-Oct-2004 13:45 2.50.3174.1158 1,765,376 Basesvr.dll 25-Dec-2003 13:30 2.50.2726.154 40,960 Smsse.dll 28-Jul-2005 21:15 515 Smsconfig.inf
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Systems Management Server 2003 Service Pack 2.
MORE INFORMATION
The following sample output is from the Dataldr.log file on the SMS site server that processes the delta hardware inventory. This output shows the sequence of events that occurs when the delta hardware inventory is processed. This log output has been edited for brevity.
Processing Inventory for Machine: NEWMACHINENAME Generated: 08/01/2005 16:02:36 File successfully parsed. Processing item NEWMACHINENAME (GUID = GUID:12345678-1234-ABCD-1234-1234567890AB) ... Pragma delete found in architecture group. Deleting machine... ... Pragma delete found in inventory group MICROSOFT|COMPUTER_SYSTEM|1.0. Deleting group... ... ERROR - attempt to update non-existent row. Resync will be requested for commands: Remote client hardware inventory resync generated for client GUID:12345678-1234-ABCD-1234-1234567890AB; update/insert result = 2
Keywords: kbqfe kbhotfixserver kbfix kbexpertiseinter kbsms2003spfix kbsms200sp2fix KB903933