Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171400

From BetaArchive Wiki
Knowledge Base

Article ID: 171400

Article Last Modified on 6/12/2001


  • Microsoft Site Server 2.0 Standard Edition

This article was previously published under Q171400


The IP Resolution feature of Usage Analyst SQL may fail to resolve all IP addresses to host names. Resolution failure is more likely to occur when a small number of IP addresses have been imported from a log file.


The problem is in the method used to identify resolved host names from the IP addresses in the SQL database.

Usage Analyst writes IP addresses to the SQL database table when a log file is imported. Usage Analyst then parses this table for unresolved IP addresses when IP Resolution is performed. After parsing out unresolved IP addresses, Usage Analyst attempts to resolve all the IP addresses and writes the host names to another SQL database table.

In this case, Usage Analyst IP Resolution is failing because it does not update the SQL database with host names if all the attempts to resolve IP addresses succeed. The only time the SQL database is correctly updated with host names is if at least one of the IP addresses fails resolution.

The problem is less likely to occur after a large log file import because it improves the chance that one of the IP addresses from the log file will fail to resolve.


To work around this problem, obtain the hotfix mentioned below. With the hotfix, Import.exe was modified to update the SQL database with host names when IP Resolution succeeds for all IP addresses.


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

A supported fix is now available, but has not been fully regression- tested and should be applied only to systems experiencing this specific problem. Unless you are severely impacted by this specific problem, Microsoft recommends that you wait for the next Service Pack that contains this fix. Contact Microsoft Technical Support for more information.

Additional query words: prodnt hostname hostnames

Keywords: kbbug kbfix kbusage KB171400