Text search unavailable for Testing -> Test Plan -> Tests

Question ID: 110142

The message “Text search is unavailable for this project. Contact the site administrator” appears when trying to use the Text Search function in the Testing -> Test Plan tab. However, this only happens when the search setting are set to “Search for ____ In Tests” as it works fine for “Search for ____ in Design Steps” as well as other parts of the project. This function also works without issue in other projects.

Marked as spam
Posted by (Questions: 113, Answers: 8)
Asked on April 30, 2021 2:54 pm
Answers (1)
Private answer

I have seen this behavior before and there was a field in the SYSTEM_FIELD table that was referencing a column in the test table that was not there. This column may have been added then removed when it caused issues with an upgrade.

If this is the case you will see an error in the SA logs similar to this...


[Mercury][SQLServer JDBC Driver][SQLServer]Column name 'TS_TREE_PATH' does not exist in the target table or view. Failed SQL: /* ~~QC */ CREATE FULLTEXT INDEX ON TEST(TS_DESCRIPTION LANGUAGE 1033,TS_NAME LANGUAGE 1033,TS_DEV_COMMENTS LANGUAGE 1033,TS_TREE_PATH LANGUAGE 1033) KEY INDEX TS_PRIMARYKEY;

To fix this issue you can set the SF_IS_SEARCHABLE value for this entity to N, rebuild the project index in the site admin, and text search will begin working.

Marked as spam
Posted by (Questions: 0, Answers: 307)
Answered on April 30, 2021 2:55 pm