Microsoft KB Archive/898459

= FIX: You receive an &quot;Invalid column name 'FREETEXTSEARCH_Rank'&quot; error message when you perform a search in Commerce Server 2002 =

Article ID: 898459

Article Last Modified on 11/15/2007

-

APPLIES TO


 * Microsoft Commerce Server 2002 Service Pack 1

-





SYMPTOMS
When you perform a free text search in Microsoft Commerce Server 2002, you may receive the following error message:

Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid column name 'FREETEXTSEARCH_Rank'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid column name 'FREETEXTSEARCH_Rank'.



CAUSE
This problem occurs if you set the CategoryName option on the CatalogSearch object when you run the free text search.



Hotfix information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Prerequisites
Because of file dependencies, you must have Commerce Server 2002 Feature Pack 1 (FP1) installed to apply this hotfix. For more information about Commerce Server 2002 FP1, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/commerceserver/bb643849.aspx

Restart requirement
You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information
This hotfix does not replace any other hotfixes.

File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.   Date         Time   Version     Size     File name 04-May-2005 20:58               13,029  1635 (accumulative).sql 01-Jun-2005 23:23  4.6.5237.0  667,920  Catalog.dll 28-Jun-2005 00:27              831,354  Catalogcreate.sql

Hotfix installation information
To apply this hotfix, follow these steps:
 * 1) Delete the ctlg_GetCategoryResults stored procedure.
 * 2) Re-create the ctlg_GetCategoryResults stored procedure by using the 1621.sql file that is included with this hotfix.

For more information about how to create a stored procedure, visit the following Microsoft Developer Network (MSDN) Web sites:  To create a stored procedure by using the Enterprise Manager tool, visit the following MSDN Web site:

http://msdn2.microsoft.com/en-us/library/aa176798(SQL.80).aspx

 To create a stored procedure by using Transact-SQL statements, visit the following MSDN Web site:

http://msdn2.microsoft.com/en-us/library/aa258259(SQL.80).aspx





STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

For more information about the same fix for Commerce Server 2002 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:

902073 FIX: You receive an &quot;Invalid column name 'FREETEXTSEARCH_Rank'&quot; error message when you perform a free text search in Commerce Server 2002

Keywords: kberrmsg kbfix kbbug kbqfe kbhotfixserver KB898459

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.