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

• Microsoft Site Server version 3.0

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, please see the following article in the Microsoft Knowledge Base:

Q219292 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.

Additional query words:

Keywords : SS3SP3Fix
Version : winnt:3.0
Platform : winnt
Issue type : kbbug