Reset the content index (FAST Search database connector)

  • Article

 

Applies to: FAST Search Server 2010

This topic explains how to completely remove previously crawled database content from the index. First you must clear the change detection database, and then you should decide whether or not you want to delete the FAST Search database connector configuration file, and lastly you must clear the content collection that the database content was fed to.

Clear the change detection database

  1. Open the FAST Search database connector configuration file. You can find this file in the etc folder of the FAST Search Server 2010 for SharePoint installation folder.

    1. Set the parameter ChangeDetection/ChangeDBPurge to true.

      Note

      Setting the parameter ChangeDBPurge to true is only relevant if you used checksum based change detection.

    2. Set the parameter Input/JDBCSQL to SELECT 1 WHERE 1 > 2. This will cause the connector to not find any content to crawl.

    3. Save the file.

  2. Run the FAST Search database connector. This will clear all the change detection database tables and free space in the SQL Server database.

    1. Verify that you meet the following minimum requirements: You are a member of the FASTSearchAdministrators local group on the computer where FAST Search Server 2010 for SharePoint is installed.

    2. On the Start menu, click All Programs.

    3. Click Microsoft FAST Search Server 2010 for SharePoint.

    4. Click the Microsoft FAST Search Server 2010 for SharePoint shell.

    5. At the Microsoft FAST Search Server 2010 for SharePoint shell command prompt, type the following command:

      jdbcconnector.bat start –f ..\etc\<connector configuration filename>

      Where:

      • <connector configuration filename> is the name of the FAST Search database connector configuration file.

  3. Wait for the connector to clear its change detection database tables and to stop running. Since you provided a non-existent result set in step 1b, the connector will fail with an error message that you can ignore. The change detection database is now cleared.

If you want to delete the FAST Search database connector configuration file, continue with Remove the configuration (optional). If you want to keep the configuration file for later use, continue with Clear the content collection.

Remove the configuration (optional)

Skip these steps if you want to reuse the FAST Search database connector configuration file later.

  1. Navigate to the FAST Search database connector configuration file that you want to remove. You can find this file in the etc folder of the FAST Search Server 2010 for SharePoint installation folder.

  2. Open it to take note of the content collection that is specified in the parameter FASTSearchSubmit/Collection if you have not already done this.

  3. Delete the file.

The FAST Search database connector configuration file is now removed. Continue with Clear the content collection.

Clear the content collection

You are now ready to reset the content index by clearing the contents of the content collection that you were feeding to.

Warning

This procedure will delete all items in the content collection. Any other content from other content sources that was fed to the same content collection is also cleared.

  1. Verify that you meet the following minimum requirements: You are a member of the FASTSearchAdministrators local group on the computer where FAST Search Server 2010 for SharePoint is installed.

  2. On the Start menu, click All Programs.

  3. Click Microsoft FAST Search Server 2010 for SharePoint.

  4. Click the Microsoft FAST Search Server 2010 for SharePoint shell.

  5. At the Microsoft FAST Search Server 2010 for SharePoint shell command prompt, type the following command:

    Clear-FASTSearchContentCollection -Name <collection name>

    Where:

    • <collection name> is the content collection you are about to clear.

  6. Wait for the command to finish. This may take some time.

    Important

    After clearing the content collection, all the relevant content will have been removed from the search engine. It will not be searchable until the FAST Search database connector is rerun.

See Also

Reference

Clear-FASTSearchContentCollection

Concepts

Configure the FAST Search database connector
Test, start or stop a crawl (FAST Search database connector)
jdbctemplate.xml reference