versaSRS Knowledge Base

 

 


Error Full-Text Search missing index 'tbl_CallAuditAttachText'

Article ID: Q731518

Category: FAQ - Knowledge Base

The information in this article applies to:

  • versaSRS
  • Case Searching
Full-Text Searching in versaSRS doesn't work and error details show that it is missing a full text index called tbl_CallAuditAttachText.
1. In SQL Management Studio locate the versaSRS database table, tbl_CallAuditAttachText. 

2. Right-click on the table and select 'Full-Text Index Table' then 'Define Full-Text Indexing on a Table...' to display the Full-Text Indexing Wizard. 

3. Click Next and select the default Unique index PK_tbl_CallAudit then click Next. 

4. Check the available columns then click Next. 

5. Select how to track updates and view changes (Automatically is default) and click Next. 

6. Click on the 'Create a new catalog' box, set the Name to Call Attach Text, click Next, then Finish to complete the setup. 

NOTE: VersaDev takes no responsibility for any data corruption or loss incurred, be sure to take extra care not to remove or change any data by mistake when operating directly on the database, we recommend performing a backup and implementing on a test environment before performing on production.

Did the information in this article help answer your question?

Yes
No
Did not apply


Last Reviewed: 01/07/2022
Powered By VersaDev Pty Ltd Copyright 2022
Last Reviewed 01/07/2022

Print this page  Print this page
Click link to send to a friend  Send to a friend
Add to Favorites  Add to Favorites

Provided by
VersaDev Support Services