Microsoft KB Archive/235127

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

Article ID: 235127

Article Last Modified on 9/22/2005

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



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.

Keywords: kbbug kbfix kbqfe kbhotfixserver KB235127

-

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

© Microsoft Corporation. All rights reserved.