Enable full-text search

This procedure is only required if the Full-text search feature is added after the system installation.

Enabling full-text search installs components required for this feature by running FTS SQL scripts on each computer that runs an SQL Server instance and hosts the Contact OLTP Database and Contact Database Server role in the Data Center that includes long-term interactions. The Contact Database is optimized for searching operations, and interactions are inserted and updated in bulk operations. roles.

These components include:

• Full-text catalog

• Stop list

• FTS index Repository of transcribed interactions, which are used for analysis in Speech Analytics.

Before you begin 

1. Download the FTS Scripts as follows:

   1. From VerintConnect home page, go to Tools & Resources > WFO Patches, Desktop Apps, Tools. (Internal or Partner. Not available for Customer)

   2. In the upper left corner, from the Select version stream and press View Report: list, select 15.2.

   3. Click View Report.

   4. Click Tools Page: 15.2 link.

   5. Download the FTS Scripts package. It contains the following SQL scripts:

      • Enable_FTS_on_Contact_OLTP_Database

      • Enable_FTS_on_Contact_Database

Procedure 

1. Open SQL Server Management Studio.

2. Connect to the SQL Server instance hosting the Contact OLTP Database Server role in the Data Center that is used to upload (known as marking) recorded interactions and interaction metadata for short-term storage management. role using a Login account with sysadmin credentials. Do the following:

   1. Execute the Enable_FTS_on_Contact_OLTP_Database script.

   2. Verify that the message: 'FTS enablement is successful' is displayed.

3. Connect to the SQL Server instance hosting the Contact Database role using a Login account with sysadmin credentials. Do the following:

   1. Execute the Enable_FTS_on_Contact_Database script.

   2. Verify that the message: 'FTS enablement is successful' is displayed.