UA: Error Importing Log Files with Character Strings >255 Characters (179261)


The information in this article applies to:

  • Microsoft Site Server 2.0, when used with:
    • Microsoft Usage Analyst
This article was previously published under Q179261

SYMPTOMS

When you are importing NCSA combined log format files, the following error message may appear and the import of subsequent records stops:
Error 50002 3700 Microsoft [ODBC SQL Server][SQL Server] Implicit conversion from datatype text to char is not allowed. Use the CONVERT function to run this query.

CAUSE

SQL Server calls anything > 255 chars as type text and not char. This causes the error above, because text type is handed differently than char types.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Site Server version 2.0.

This problem has been corrected in the latest U.S. Service Pack for Microsoft Site Server version 2.0. For information on obtaining the Service Pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K

Modification Type:MajorLast Reviewed:2/20/2004
Keywords:kbbug kbfix kbQFE KB179261
©2004 Microsoft Corporation. All rights reserved.