Level*Dir Contains Query Strings with "Save Query Strings with URI"

• Microsoft Site Server version 3.0

SYMPTOMS

When you import with the Save query strings with URI import option enabled, Level*Dir tables contain query strings. Reports containing level directories contain extraneous entries for every URI query string that contains a forward slash ( / ).

CAUSE

A coding error in SQL Server stored procedure parses the entire URI when parsing for level directories. Only the URI prior to the question mark (?) should be parsed for level directories.

WORKAROUND

Disable the Save query strings with URI import option.

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

This fix updates the SQLWizard component and the stored procedures that parse for level directories. After you apply fix, create a new database and then import the appropriate log files.

Additional query words:

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