Search in Track-It! is slow or returns inconsistent results

Taken from article TIA02958

Found In: Track-It! 8.0, 9.0, 10.0, 10.5 Search

 

Description

When using the Search feature in Track-It!, results may be inconsistent or the search may find no results. In addition, the search process may be slow or worsen over time. This is usually caused by corrupt index files that are out of date or damaged.

 

Resolution

If you are running Track-It! 8 (8.0.30.10 or earlier), the first thing to check is the Track-It! Search service to make sure that service is running on the Track-It! server. If it is already running, the issue may be resolved by simply restarting the service. In Track-It! 8.x, 9, and 10.x the search functionality is included in the Track-It! Service Management service. If you are able to access Track-It!, the Search service is running.

 

NOTE on searching: The text that is entered is used in a "Starts with" context. Therefore, the data must be located in a field where the search string starts with that text. In order to search the data where the search string is contained anywhere in the fields, use the asterisk (*) before the search string as a wildcard. For example, to locate the word "printer" anywhere in the fields of the module being searched, search for "*printer".

 

The search process uses index files to locate data, and normally will maintain the indexes on its own. In some cases however, the index files can become corrupt or very large, and must be rebuilt manually to have the search consistently return the expected results and to ensure that the search returns results as quickly as possible.

 

Instructions:

  1. On the Track-It! server, open Control Panel -> Administrative Tools -> Services.
  2. Stop the Track-It! Search service (builds 8.0.30.10 and earlier) or the Track-It! Service Management service (builds 9.x and 10.x).
  3. Open the following directory (default):
    1. C:\Program Files\Numara Software\Numara Track-It!\Track-It! Services\SearchData
  4. Delete all files and folders in the directory if any exist.
  5. Restart the Track-It! Search or Track-It! Service Management service.
  6. When the indexing starts you should see a "CurrentlyFullIndexing.lock" file in the directory.
  7. Once this entire process completes, all of the search indexes will be recreated.

 

Keep in mind that while the indexes are being recreated, search results in Track-It! may be inconsistent. Once the index files are recreated, the search should work as expected. The amount of time that it takes to recreate the files will depend on the amount of data in the database but could take an hour or more if the database is very large. When the indexing is complete, there will be a file named "LastDBChangeLogId.txt" and one named "LastFullIndexStamp.txt" in the SearchData folder.