- Help center
- Installation
- On-premise FAQs
How to restore Full-Text Search functionality in FocalScope
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]
- 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]