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

• Microsoft Site Server version 2.0, used with:
  • Microsoft Usage Analyst

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

Additional query words:

Keywords :
Version : winnt:2.0
Platform : winnt
Issue type : kbbug