Importing Proxy Log File in an Access Database May Fail if Log File Contains a Pipe Character (249222)

The information in this article applies to:

Microsoft Site Server 3.0

This article was previously published under Q249222

SYMPTOMS

When you import a log file with log entries that contain query strings with a Pipe Character ("|"), Usage Import quits and displays the following error message:

Error Querying the Import Job.
Error 3077: DAO.Recordset Syntax error in string in expression.

This problem only occurs when using the Usage Analysis Version for use with an Access Databases.

CAUSE

The presence of the Pipe character in a query string causes Uas.exe to quit because the Jet Engine uses this character as a field delimiter in SQL statements.

RESOLUTION

To resolve this problem, obtain the latest service pack for Site Server version 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

Microsoft has confirmed that this is a problem in Site Server 3.0. This problem was first corrected in Site Server 3.0 Service Pack 4.

MORE INFORMATION

For additional information, see the following article or articles in the Microsoft Knowledge Base:

147687 HOWTO: Query for Literal Special Characters in a Where Clause

178070 HOWTO: Handle Quotes and Pipes in Concatenated SQL Literals

Modification Type:	Minor	Last Reviewed:	9/23/2005
Keywords:	kbHotfixServer kbQFE kbbug kbfix kbQFE kbSiteServ300sp4fix KB249222