How to restore Full-Text Search functionality in FocalScope
Monday, December 5, 2016 3:04 AM

FocalScope's search feature relies on the Full-Text Search SQL Server component to be installed and working. If the Full-Text Search component is not installed or has become out of sync with the FocalScope database, FocalScope search will be unable to locate specific text in emails. This article will detail the steps needed to verify if Full-Text Search is installed and how to install / re-synchronize it if necessary.

Symptoms

  • Searches in FocalScope give empty results
  • Searches in FocalScope give results that are mismatched with the specified search criteria
  • You cannot find a message you are sure is in FocalScope


Cause

  • The Full-Text Search component is missing or out of sync with the FocalScope database
  • The Full-Text Search service has stopped
  • The Full-Text Search catalogs are not tracking changes or have become damaged, usually do to:
    • Performance problems
    • Maintenance activity on the SQL server
    • Database migration (backup / restore)



Troubleshooting & Resolution

Step 1 - Checking if the Full-Text Search feature is installed

  • In the Windows Start menu, run [Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Installation Center]Please note, if you are prompted to locate the installation media, it may be necessary to download the SQL Server installer from Microsoft - http://www.microsoft.com/en-us/download/details.aspx?id=26729


Figure 1 - Launching SQL Server Installation Center


  • At the opening screen select [Installation] in the left-hand list, and in the right-hand list click [New installation or add features to an existing installation]Please note, it may take a minute for the installation program to prepare itself


Figure 2 - Installing new features to SQL Server


  • When the [SQL Server 2008R2 Setup] screen loads, select the [Add features to an existing instance of SQL server 2008 R2] option
  • Click [Next] to continue


Figure 3 - Specifying your existing SQL instance


  • If the [Full-Text Search] checkbox is grayed out with a check through it, it means Full-Text Search is already installed for the instance (proceed to Step 2 directly). If the checkbox is blank, tick it to elect Full-Text Search for installation
  • Click [Next] and complete the rest of setup process, leaving all parameters at their defaults


Figure 4 - Installing Full-Text Search


Step 2 - Checking that the Full-Text Search service is running

  • In the Windows Start menu, run [Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager]


Figure 5 - Launching the SQL Server Installation Center



  • Note the state of the [SQL Full-text Filter Daemon Launched] service. If the status is Stopped or Paused, right click the service and select [Start] or [Resume]



Figure 6 - Launching SQL Server Installation Center


Step 3 - Rebuilding FocalScope Full-Text Search catalogs

  • In the Windows Start menu, run [Microsoft SQL Server 2008 R2 > SQL Server Management Studio]



Figure 7 - Launching SQL Server Management Studio


  • At the login screen, log into your SQL Server instance. Please note, you in case of a named SQL server instance specify the [Server name] as ServerName\SQLInstanceName


Figure 8 - Logging into your SQL Server instance



  • Expand the [Server Name > Databases > focalscope_emm > Storage > Full Text Catalogs] folder
  • Right click the catalog that you wish to rebuild and select [Rebuild]



Figure 9 - Rebuilding the FocalScope Full-Text Catalogs

Additional Information