Unable to do Text Search in different projects, results in "No Records found"

  • KM00794359
  • 17-Mar-2014
  • 17-Mar-2014

Summary

Unable to do Text Search in different projects, results in "No Records found"

Question

The Text Search results in "No Records found" even though the words being searched are included in the requirements for those projects. Text Search is enabled in the SQL database. Also the option Enable/Rebuild Text Search was used without success.
 

Answer

In case the option to Enable/Rebuild Text Search does not work, you can go through the following steps:
1- Backup the Data Base of the project,
2- Access the DB of the project through SQL Management Studio
3- Expand the DB of the project and follow this path:
Storage --> Full Text Catalog
4- Delete the catalog as shown in the image below.
 

image text
5- From Site Admin Rebuild the Text search with the option Enable/Rebuild Text Search
6- Check if it works now.