Microsoft KB Archive/317306

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

Article ID: 317306

Article Last Modified on 11/17/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q317306



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: &quot;i_ClassType, CatalogName&quot;



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(&quot;MSCSCatalogManager&quot;).FreeTextSearch(strSearchPhase, strCatalogsToSearch, iClassType, &quot;CatalogName, CategoryName, DefinitionName, OriginalPrice, cy_list_price, i_ClassType, ProductID, Description, image_filename, image_width, image_height, Name&quot;, &quot;i_ClassType, CatalogName&quot;, True, lngSearchStartPos, lngSearchRowToReturn, lngTotalRecordsInQuery) and replace it with the following code: Set rsProducts = Application(&quot;MSCSCatalogManager&quot;).FreeTextSearch(strSearchPhase, strCatalogsToSearch, iClassType, &quot;CatalogName, CategoryName, DefinitionName, OriginalPrice, cy_list_price, i_ClassType, ProductID, Description, image_filename, image_width, image_height, Name&quot;, &quot;i_ClassType,CatalogName&quot;, True, lngSearchStartPos, lngSearchRowToReturn, lngTotalRecordsInQuery)

Additional query words: CS2K

Keywords: kbnofix kbprb KB317306

-

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

© Microsoft Corporation. All rights reserved.