IP Resolution May Fail in Usage Analyst SQLID: 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 : kbusage kbbug2.00
Version : WINNT:2.0
Platform : winnt
Issue type : kbbug Last Reviewed: July 20, 1999