Microsoft KB Archive/938314

= Error message when you try to open the Settings Summary report in Windows Server Update Services 2.0: &quot;The element already exists in the collection&quot; =

Article ID: 938314

Article Last Modified on 6/29/2007

-

APPLIES TO


 * Microsoft Windows Server Update Services 2.0

-



SYMPTOMS
When you try to open the Settings Summary report in Microsoft Windows Server Update Services 2.0, the report may not open. Additionally, you may receive an error message that resembles the following:

Windows Server Update Services encountered an error. The element already exists in the collection. Parameter name: value



CAUSE
This problem occurs because of duplicate records in the tbDownstreamServerTarget table in the SUSDB database. For example, this problem occurs if the same AccountServerID record appears multiple times.



WORKAROUND
To work around this problem, remove the duplicate records. To do this, follow these steps:  Open Microsoft SQL Server Management Studio.  Locate the duplicate record by running the following query. Use SUSDB Select TargetID, AccountName, AccountServerID, LastSyncTime From tbDownstreamServerTarget Order by AccountServerID -- Note the TargetID that appears multiple times.   Use queries that resemble the following to remove duplicate records. Use SUSDB Delete From tbTargetInTargetGroup Where TargetID =  go

Delete From tbDownstreamServerTarget Where TargetID =  go

Delete From tbTarget Where TargetID =  go 



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

Keywords: kbtshoot kbprb KB938314

-

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

© Microsoft Corporation. All rights reserved.