Level*Dir Contains Query Strings with "Save Query Strings with URI" (240906)
The information in this article applies to:
- Microsoft Site Server 3.0
This article was previously published under Q240906 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.
RESOLUTIONTo 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
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.
| Modification Type: | Minor | Last Reviewed: | 9/22/2005 |
|---|
| Keywords: | kbHotfixServer kbQFE kbbug kbfix kbQFE KB240906 |
|---|
|