Reference Architecture (B2CRef) search may fail when you install Commerce Server 2000 Service Pack 2 (SP2) or Commerce Server 2002 (317306)

SYMPTOMS

If you install Commerce Server 2000 Service Pack 2 (SP2) or Commerce Server 2002, and then you try to execute a search on the Reference Architecture application home page, the search fails and the following error message is generated:

HTTP 500 - Internal server error
Microsoft OLE DB Provider for SQL Server error '80040e14'
Invalid column name 'CatalogName'. /__Searchresults.asp, line 2993

However, you can execute the same search in an individual catalog.

CAUSE

This problem occurs because of the space that exists in front of CatalogName in the following section of code:

"i_ClassType, CatalogName"

RESOLUTION

To resolve this problem, remove the space in front of CatalogName. To do so, locate the following code in SearchResults.pasp

Set rsProducts = Application("MSCSCatalogManager").FreeTextSearch(strSearchPhase, strCatalogsToSearch, iClassType, "CatalogName, CategoryName, DefinitionName, OriginalPrice, cy_list_price, i_ClassType, ProductID, Description, image_filename, image_width, image_height, Name", 
"i_ClassType, CatalogName", True, lngSearchStartPos, 
lngSearchRowToReturn, lngTotalRecordsInQuery)

and replace it with the following code:

Set rsProducts = Application("MSCSCatalogManager").FreeTextSearch(strSearchPhase, strCatalogsToSearch, iClassType, "CatalogName, CategoryName, DefinitionName, OriginalPrice, cy_list_price, i_ClassType, ProductID, Description, image_filename, image_width, image_height, Name",
"i_ClassType,CatalogName", True, lngSearchStartPos, 
lngSearchRowToReturn, lngTotalRecordsInQuery)