December 17, 2007 at 9:28 am
I am trying to rebuild full text catalog and its giving me this error. This full text catalog consists of 13 table and out of which one table is having problem and log file shows error that 46 documents were password protected and hence could not be rebuild. Is there a easy way to rebuild this full text as right now its very urgent and my application just hang when send to full text search.
Error:
2007-12-14 15:28:40.18 spid22s Warning: No appropriate filter was found during full-text index population for table or indexed view '[TR_DEV].[sysadm].[PR_data]' (table or indexed view ID '5', database ID '2005582183'), full-text key value 0x00067748. Some columns of the row were not indexed.
2007-12-14 15:28:40.18 spid22s Informational: Full-text Full population completed for table or indexed view '[TR_DEV].[sysadm].[PR_data]' (table or indexed view ID '2005582183', database ID '5'). Number of documents processed: 524695. Number of documents failed: 6. Number of documents need retry: 46.
2007-12-14 15:28:42.18 spid22s Error '0x8004170b: File was not filtered due to password protection.' occurred during full-text index population for table or indexed view '[TR_DEV].[sysadm].[PR_data]' (table or indexed view ID '2005582183', database ID '5'), full-text key value 0x0000A048. Attempt will be made to reindex it.
2007-12-14 15:28:42.18 spid22s The component 'offfilt.dll' reported error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'.
SQL DBA.
December 18, 2007 at 2:43 am
The FT catalog has been built as much as it can ever be built. The messages are just saying that certain documents could not be included in the catalog.
Can you give sample code for your select statement, including any joins with non-FT data. It will then be possible for us to understand your problem better.
Also, how busy is the CPU? If it is on 100% then FT searches can take a long long time to complete.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply