"Commerce Server: Invalid column name 'Freetex'" Error Message When You Remove One Catalog from the Catalog Search Class (324804)

The information in this article applies to:

Microsoft Commerce Server 2002

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 = "Catalogue A, Catalogue B"

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_<CatalogName> 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:

Open SQL Query Analyzer.
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.

Modification Type:	Minor	Last Reviewed:	9/27/2005
Keywords:	kbHotfixServer kbQFE kbbug kbCommServ2002preSP1fix kbCommServ2002SP1fix kbfix KB324804