KBA-01037: Full-text Catalog has been lost

Problem:

A ‘Full-text catalog File Catalog (or sfDocCatalog) has been lost‘ message is displayed in my Log file. What do I do?

Solution:

The catalog may have been lost because of a recent SQL restore.  When a database is restored the synchronization between the full text catalog and the database is broken.You will need to rebuild your File Catalog full-text indices.

1. In SQL Enterprise Manager, expand your Database folder.
2. Locate your sfPMS database and expand it.
3. Click on Full-Text Catalogs.
4. Right-click on the File Catalog.
5. Select Rebuild Catalog.

Repeat the same steps for the sfDocCatalog if that catalog requires rebuilding too.

Additional Comments:

Text from Log File:

• Full-text catalog ‘FileCatalog‘ has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.
• Full-text catalog ‘sfDocCatalog‘ has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.

KBA-01037; Last updated: October 13, 2016 at 9:18 am;
Keywords:  full-text catalog index