Microsoft KB Archive/918914

= The ddm.box inbox folder is backlogged with many DDRs, and the SMS database is not updated with newly created objects in Systems Management Server 2003 =

Article ID: 918914

Article Last Modified on 10/18/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-



SYMPTOMS
You may experience the following symptoms on a Microsoft Systems Management Server (SMS) 2003 site server:  The SMS database is not updated with newly created objects after a discovery interval has passed. Discovery data records (DDRs) are queued in the ddm.box inbox folder.

Note By default, this folder has the following path:

C:\SMS\inboxes\auth\ddm.box

 The ddm.log file contains many error entries that resemble the following:

*** insert into System_SMS_Assign_ARR (ItemKey, SMS_Assigned_Sites0) values (8851, &quot;SMS:S01&quot;) SMS_DISCOVERY_DATA_MANAGER 6436 (0x1924) SMS_DISCOVERY_DATA_MANAGER 6436 (0x1924) &quot;SMS:S01&quot;) SMS_DISCOVERY_DATA_MANAGER 6436 (0x1924) data would be truncated. SMS_DISCOVERY_DATA_MANAGER  6436 (0x1924) &quot;SMS:S01&quot;)  SMS_DISCOVERY_DATA_MANAGER     6436 (0x1924) been terminated. SMS_DISCOVERY_DATA_MANAGER    6436 (0x1924) CDiscoverySource_SQL::UpdateItem - could not execute sql- insert into System_SMS_Assign_ARR (ItemKey, SMS_Assigned_Sites0) values (8851, &quot;SMS:S01&quot;) SMS_DISCOVERY_DATA_MANAGER     6436 (0x1924) CDiscoverDataManager::ProcessDDRs_PS - Unable to update data source SMS_DISCOVERY_DATA_MANAGER     6436 (0x1924) STATMSG: ID=2636 SEV=E LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_DISCOVERY_DATA_MANAGER&quot; SYS=SMS SITE=S01 PID= TID= GMTDATE= ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_DISCOVERY_DATA_MANAGER    6436 (0x1924) CDiscoverDataManager::ProcessDDRs_PS - SQL problem detected. Will retry later. SMS_DISCOVERY_DATA_MANAGER    6436 (0x1924) CDiscoverDataManager::Process - Failed to manage files in inbox. Will retry in at least 60 seconds   SMS_DISCOVERY_DATA_MANAGER     6436 (0x1924)
 * [22001][8152][Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
 * insert into System_SMS_Assign_ARR (ItemKey, SMS_Assigned_Sites0) values (8851,
 * [22001][8152][Microsoft][ODBC SQL Server Driver][SQL Server]String or binary
 * insert into System_SMS_Assign_ARR (ItemKey, SMS_Assigned_Sites0) values (8851,
 * [01000][3621][Microsoft][ODBC SQL Server Driver][SQL Server]The statement has

Note By default, the ddm.log file is located in the C:\SMS\Logs folder. In the contents of the affected DDRs, two SMS_AUTHORITY instances, such as SMS:S01 and SMS:S02, are displayed. For example, XML that resembles the following appears in the affected DDRs:

BEGIN_PROPERTY <17><11> BEGIN_ARRAY_VALUES  END_ARRAY_VALUES END_PROPERTY

BEGIN_PROPERTY <17><11> BEGIN_ARRAY_VALUES <SMS:S02> END_ARRAY_VALUES END_PROPERTY

</li></ul>

<div class="cause_section">

CAUSE
This problem occurs if the Windows Management Instrumentation (WMI) property on the SMS client contains two or more site codes. In this situation, the following process occurs: <ol>  An SQL statement that resembles the following runs to insert the three-character site code into the SMS_Assigned_Sites0 column of the SMS database: insert into System_SMS_Assign_ARR (ItemKey, SMS_Assigned_Sites0) values (25912, &quot;SMS:XXX&quot;) The SMS_Assigned_Sites0 field is four characters wide. In this scenario, the DDR processing operation removes the SMS part from the site code. Therefore, site code information such as  is truncated to. </li> If the DDR XML contains two SMS_AUTHORITY instances, the SMS part of the second SMS_AUTHORITY instance is incorrectly concatenated to the site code during DDR processing. Therefore, the site code becomes seven characters. For example, site code information such as  becomes the site code  .</li> The SQL INSERT statement fails when it tries to insert the seven-character site code into the four-character field.</li></ol>

To determine whether the WMI property on the SMS client contains two site codes, follow these steps: <ol> Locate the DDR of the computer that is blocking the ddm.box queue. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Open the :\SMS\Logs\ddm.log file.</li> Locate the DDR entry that contains the error entry that is described in the &quot;Symptoms&quot; section.

Note A typical DDR processing entry starts with information that resembles the following:

<pre class="fixed_text">file <fileName>.DDR         SMS_DISCOVERY_DATA_MANAGER Processing NEW <System>... SMS_DISCOVERY_DATA_MANAGER Name = <ComputerName>       SMS_DISCOVERY_DATA_MANAGER

Note the name of the DDR file together with the computer name that is associated with the DDR file.</li></ol> </li> In the drive:\SMS\ddm.box folder, open the .DDR file to verify the NetBIOS name of the computer. In the following example, the NetBIOS name of the computer is Computer-1:

<pre class="fixed_text">BEGIN_PROPERTY <8><NetBIOS Name><11><64><Computer-1> END_PROPERTY

</li> On the particular client computer, start the Windows Management Instrumentation Tester program. This program is also known as WBEMTest. To do this, click Start, click Run, type wbemtest, and then click OK.</li> Examine the content in the SMS_AUTHORITY class. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> In Windows Management Instrumentation Tester, click Connect.</li> In the Connect dialog box, type root\ccm, and then click Connect.</li> In the Windows Management Instrumentation Tester, click Open Class.</li> In the Enter Target Class Name box, type sms_authority, and then click OK.</li></ol> </li></ol>

If two or more SMS_AUTHORITY instances are displayed, you may experience the problem that is described in the &quot;Symptoms&quot; section.

<div class="resolution_section">

RESOLUTION
To resolve this problem, follow these steps: <ol> Apply the hotfix that is mentioned in the &quot;Hotfix information&quot; section to the SMS site server.</li> Remove the SMS agent from the affected client computer, and then reinstall the SMS agent on the client computer. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

826842 How to remove a Systems Management Server 2003 client

</li></ol>

Hotfix information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Prerequisites
You must have Systems Management Server 2003 Service Pack 2 installed to apply this hotfix. For more information about how to obtain the latest Systems Management Server 2003 service pack, 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

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 hotfixes.

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 item in Control Panel.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
In some environments, the Active Directory directory service discovery process may cause the generation of incorrect DDRs. You may experience this problem even when the hotfix from this article is applied. Therefore, if you enable Active Directory discovery, you may receive the same error entries that are mentioned in the &quot;Symptoms&quot; section.

To resolve this problem, contact Microsoft Product Support Services to help you remove the incorrect record from the SMS database. For more information about how to contact Product Support Services, visit the following Web site:

http://support.microsoft.com/

For more information about the terms that are used in this article, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

How to manually resolve problems with incorrect DDRs
To manually resolve problems with incorrect DDRs if SMS 2003 Active Directory System Discovery is used, follow these steps: <ol> Remove the client computer that is identified by the ddm.log entry from any Organizational Units (OU) that are scanned by SMS 2003 Active Directory System Discovery.</li> <li>Stop the SMS Executive service on the site server.</li> <li>Copy the backlogged DDRs that are located in the following folder to a different folder location:

C:\SMS\inboxes\auth\ddm.box folder

Note By default, the backlogged DDRs are located in this folder.

</li> <li>Restart the SMS Executive service.</li> <li>Open the SMS 2003 Administrator console on the site server.</li> <li>Find the SMS client that is identified by the ddm.log entry from the All Systems collection within the SMS Administrator console, and then delete the SMS client.

Note The client record cannot be directly deleted from the System_SMS_Assign_ARR table in the site server database because of foreign key (FK) constraints. Therefore, you must use the SMS Administrator console to delete the client record.</li> <li>Run the &quot;Advanced Client and Management Point Cleaner&quot; (Ccmclean.exe) utility from the SMS 2003 Toolkit 2 on the client computer. For more information about Systems Management Server 2003 Toolkit 2, visit the following Microsoft Web site:

http://www.microsoft.com/technet/prodtechnol/sms/sms2003/downloads/tools/toolkit.mspx

</li> <li>Check the site server database for other duplicate GUIDs by using SMS Administrator console\Reporting\Reports. The specific report to use is named &quot;Computers that share the same SMS Unique ID, Report number 73.&quot;

Note For more information about how to correct a situation in which you find that multiple SMS clients share the same unique identifier, click the following article number to view the article in the Microsoft Knowledge Base:

837374 How to locate and clean Advanced Client Duplicate GUIDs in SMS 2003

</li> <li>Use SQL Server Enterprise Manager or SQL Server Management Studio to verify that the ddm.log file has no references to entries for the client ID in the System_SMS_Assign_ARR table.</li> <li>Add the client workstation back to the OU that is being scanned.</li> <li>Run the discovery again, and verify that the client has been added correctly.</li> <li>Verify that there is only one entry for the client ID in the System_SMS_Assign_ARR table.

Note The computer will probably obtain a new machineID so that you must search the Name0 column of the System_Disc table for the NetBIOS name. Then, use the MachineID value from this table when you search the System_SMS_Assign_ARR table.</li> <li>Redeploy the SMS client to the workstation.</li></ol>

Keywords: kbbug kbfix kbhotfixserver kbqfe kbpubtypekc KB918914

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.