UA: Error 457: "This key is already associated with an element in this collection" Importing Log File (156690)
The information in this article applies to:
- Microsoft Site Server 2.0, when used with:
- Microsoft Usage Analyst for Access 2.0
- Microsoft Usage Analyst for SQL Server 2.0
- Microsoft Site Server, Enterprise Edition 2.0, when used with:
- Microsoft Usage Analyst for Access 2.0
- Microsoft Usage Analyst for SQL Server 2.0
This article was previously published under Q156690 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.
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.
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:
For Usage Analyst Developer package for SQL:
For Usage Analyst Standard package for Access:
For Usage Analyst Standard package for SQL:
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):
| Modification Type: | Major | Last Reviewed: | 11/26/2003 |
|---|
| Keywords: | kbbug kberrmsg kbfix KB156690 |
|---|
|