Preventing Errors While Doing a Free Text Search

  • Article

To prevent the "The query contained only ignored words" error while doing a free text search for some search phrases, use the UpdateFullTextCatalogs.vbs script in the Program Files\Microsoft Commerce Server 2002\Support folder.

Use the following command:

UpdateFullTextCatalogs.vbs –I

You need to run this script every time you create a catalog.

If you add a product to your catalog and find that when you do a free text search the product is not returned in the recordset, you must enable change tracking.

For performance reasons, by default the FullText catalogs are not enabled for change tracking. Therefore, every time you make changes to the catalog you must call the RegenerateFreeTextSearchIndex method of the ProductCatalog object to update the FullText catalogs. You can also enable change tracking by using SQL Server Enterprise Manager. By enabling change tracking, the contents of the FullText catalog are updated in response to changes made in the catalog. The CatalogGlobal table in the catalog database stores the FullText catalog that is created for each catalog.

Copyright © 2005 Microsoft Corporation.
All rights reserved.