Additionally, SQL Server may restart the FDHOST.exe process. When this issue occurs, an error message that resembles the following is displayed in the SQL Server error log:
Exec sp_fulltext_service ‘ft_timeout’, 1200000
Important Restart your SQL Server for the new setting to take effect.
For large XML documents, the XML Filter that is hosted by the FDHOST.exe process reads in all the data from SQL Server and stores the data in a temporary file. Then FDHOST.exe processes the XML content for filtering and word-breaking. If this process takes more than 60 seconds, SQL Server stops the batch and retries the operation by using a smaller batch size. If an XML document is large, and the FDHOST.exe process takes more than 60 seconds to filter and break the words, then you can experience error that is mentioned in the "Symptoms" section.
Note The issue can occur with any iFilter that writes data to a temporary file.
Error 0x80040e97 can also be raised for other reasons. For example, you may see the same error code when SQL Server experiences issues loading an iFilter. Increasing the time-out value in these cases may mask the error and prevent effective troubleshooting. Therefore, we recommend that you verify the size of the document and confirm that the size of the failing document is exceptionally large before you increase the time-out value.
Id. de artículo: 2270849 - Última revisión: 14-08-2012 - Revisión: 1