Error: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'CMS_Attachment' because

Alistair DeJonge asked on February 8, 2017 20:23

So I have 2 Smart Search indices. Both of them are based on page types. Both have a search results page with filters (multiple drop-downs and a keyword). One is called Collections and one is called Projects.

So when I do a keyword search on the Projects, I get this error message:

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'CMS_Attachment' because it is not full-text indexed

If I do a keyword search on Collections, it works fine. Using the drop-down filters on both works fine as well, it's just a keyword search on Projects that breaks.

I have compared settings between the web part configurations and smart search index settings; both are virtually identical, except the drop-down filters are specific for each index. Both use the same DB. I have run the site locally and found where it breaks:

Line 1479 - DataSet results = SearchHelper.Search(parameters);

I have compared the parameters argument between the two searches and other than the index, page types, and path, there isn't anything apparently wrong with the Projects one.

Please help, because I have run out ideas.

Correct Answer

Brenden Kehren answered on February 8, 2017 20:42

This is specifically related to the database and having full text search turned on. Can you confirm this is turned on? If so, this column or view may not allow it so you'd have to configure that to allow it in SSMS. See the post on SO for more info and references.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Alistair DeJonge answered on February 8, 2017 22:13

Full text search is enabled on the DB. If it was not, then the keyword search for Collections would not work either. The problem is, I don't know what this CMS_Attachment is. It's not a column in the custom_Projects table. I'm not aware if it is a view... how do I find this CMS_Attachment?

0 votesVote for this answer Mark as a Correct answer

Roman Hutnyk answered on February 9, 2017 08:19

This is a table in database where Kentico stores information about document attachments. The question is why does it cause issue during search? Do you have "Include attachment content" checked in your index?

1 votesVote for this answer Mark as a Correct answer

Alistair DeJonge answered on February 9, 2017 17:44 (last edited on February 9, 2017 18:19)

Roman,

No, I do not. I have confirmed this for both search indices. I have made sure that no file fields are made searchable in the page types.

0 votesVote for this answer Mark as a Correct answer