Usage Analysis Imports Multiple Truncated Directories for a Single-Level2 Directory Using SQL Server 6.5 (235127)


The information in this article applies to:

  • Microsoft Site Server 3.0
This article was previously published under Q235127

SYMPTOMS

Incorrect entries are imported into TblImportLevel2Dir during import. This problem occurs with SQL Server 6.5. Imports to Microsoft Access work correctly.

CAUSE

The import-stored procedure allocates a temp buffer of 100 characters. If dataset contains URL entries that exceed 100 characters, the temp buffer truncates the entry, causing incorrect entries to be posted to the Level2Dir table.

WORKAROUND

Use a Microsoft Access database or reduce the size of the URLs being analyzed.

RESOLUTION

To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

219292 How to Obtain the Latest Site Server 3.0 Service Pack


STATUS

This problem was first corrected in Site Server 3.0 Service Pack 3.

MORE INFORMATION

All databases created after the installation of the fix will contain the fixed stored procedures.

After you install the fix, to install the fixed stored procedures on existing databases, use the following steps:
  1. Run Database Setup - SQL Server from the Start menu.
  2. Click Next.
  3. Select Update an existing database.
  4. Enter the connection string information for the database you want to update.
  5. Select Connect.
  6. Uncheck all check boxes except for Create stored procedures.
  7. Select Update DB.
  8. Click OK on the database updated dialog.
  9. Click Finish.
Modification Type:MinorLast Reviewed:9/22/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE KB235127
©2004 Microsoft Corporation. All rights reserved.