Microsoft KB Archive/324804

= &quot;Commerce Server: Invalid column name 'Freetex'&quot; Error Message When You Remove One Catalog from the Catalog Search Class =

Article ID: 324804

Article Last Modified on 9/27/2005

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



This article was previously published under Q324804



SYMPTOMS
When you try to remove one catalog from the Catalog Search, you receive exception error messages. When the following line is modified to remove Catalogue B searchResults.CatalogNames = &quot;Catalogue A, Catalogue B&quot; the following error is logged in the application event log:

Commerce Server: Invalid column name 'Freetex'.

Event Type: Error

Event Source: Commerce Server 2002

Event Category: None

Event ID: 4101

Computer: SERVERNAME

Description:

Commerce Server: Invalid column name 'Freetex'.



CAUSE
The data lengths of three temporary variables are not enough to store the data.



RESOLUTION
To resolve this problem, obtain the latest service pack for Commerce Server 2002. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

328814 INF: How to Obtain the Latest Commerce Server 2002 Service Pack

The English version of this fix has the file attributes (or later) 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   Size  File name          Platform -  20-Jun-2002               CatalogCreate.sql  x86 20-Jun-2002 20:58  289   Q324804.sql



STATUS
Microsoft has confirmed that this is a problem in Commerce Server 2002. This problem was first corrected in Commerce Server 2002 Service Pack 1 (SP1).



MORE INFORMATION
Changes Implemented in Catalogcreate.sql: In the ctlg_GetResults_for_AllColumns_ procedure Change the following declarations DECLARE @PropertiesToGet_Tmp nvarchar(100) DECLARE @PropertiesToGet2_Tmp nvarchar(100) DECLARE @PropertiesToInsert_Tmp nvarchar(100)

TO

DECLARE @PropertiesToGet_Tmp nvarchar(4000) DECLARE @PropertiesToGet2_Tmp nvarchar(4000) DECLARE @PropertiesToInsert_Tmp nvarchar(4000)

To correct an existing site configuration:
 * 1) Open SQL Query Analyzer.
 * 2) Run the Q324804.sql SQL script on each site database (where the site catalog resides). The hotfix installer replaces Catalogcreate.sql in your \Program Files\Microsoft Commerce Server 2002 directory.

NOTE: Do not run Catalogcreate.sql on an existing site database.

Keywords: kbbug kbfix kbcommserv2002presp1fix kbqfe kbcommserv2002sp1fix kbhotfixserver KB324804

-

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

© Microsoft Corporation. All rights reserved.