Microsoft KB Archive/156690

= UA: Error 457: "This key is already associated with an element in this collection" Importing Log File =

Article ID: 156690

Article Last Modified on 11/26/2003

-

APPLIES TO

 Microsoft Site Server 2.0 Standard Edition, when used with:  Microsoft Usage Analyst for Access 2.0

 Microsoft Usage Analyst for SQL Server 2.0  Microsoft Site Server 2.0 Enterprise Edition, when used with:  Microsoft Usage Analyst for Access 2.0

 Microsoft Usage Analyst for SQL Server 2.0</li></ul> </li></ul>

-

<div class="notice_section">

This article was previously published under Q156690

<div class="symptoms_section">

SYMPTOMS
When you try to import the log file, you may get the following error 457 message:

This key is already associated with an element in this collection.

For example, you configure a Microsoft Internet Information Server (IIS) standard log data source, two servers with unique IP addresses, and set up two sites in the Server Manager. You then configure the query strings tab for each to use the exact same query string values at Metadata. After you start to import the log file, the error occurs.

<div class="cause_section">

CAUSE
The database does not allow two different sites to have the exact same Metadata values. Each value that is used on the Query String tab must be unique to the database.

<div class="workaround_section">

WORKAROUND
To avoid the problem, use either of the following methods:


 * Modify the Query String tab for each site so that the information used as Metadata is not identical for the two sites. -or-


 * Use the Metadata module to manually edit the query string values that are imported.

A fix is available at the following locations:

For Usage Analyst Developer package for Access:

ftp://ftp.microsoft.com/bussys/sitesrv/sitesrv-public/fixes/usa/usage/import-fix/uadeva

For Usage Analyst Developer package for SQL:

ftp://ftp.microsoft.com/bussys/sitesrv/sitesrv-public/fixes/usa/usage/import-fix/uadevs

For Usage Analyst Standard package for Access:

ftp://ftp.microsoft.com/bussys/sitesrv/sitesrv-public/fixes/usa/usage/import-fix/uastda

For Usage Analyst Standard package for SQL:

ftp://ftp.microsoft.com/bussys/sitesrv/sitesrv-public/fixes/usa/usage/import-fix/uastds

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in Microsoft Site Server version 2.0.

This problem has been corrected in the latest U.S. Service Pack for Microsoft Site Server version 2.0. For information on obtaining the Service Pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K

Additional query words: duplicate query

Keywords: kberrmsg kbbug kbfix KB156690

-

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

© Microsoft Corporation. All rights reserved.