PDF refuses to be found in a FT-idx on a filetable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

PDF refuses to be found in a FT-idx on a filetable

Author

Topic

e.heijmans@12move.nl
Starting Member

10 Posts

Posted - 2014-12-15 : 11:09:38

I've worked my way through several forums, and tried suggestions, but to no avail.

I have a filetable and use a statement like

SELECT [name],file_stream
FROM dbo.Inkoopfacturen
WHERE FREETEXT(file_stream, 'Factuur');

It will return the text found in a .pptx but not in a pdf. There are no errors in the FT-log. It tells me that the FT-index is succesfully build.

I have downloaded the iFilter for Adobe (installed it in a folder with a short name), set the temp variable to the bin folder of the installation.

I've executed the following queries:
EXEC sp_fulltext_service 'update_languages';
EXEC sp_fulltext_service 'load_os_resources', 1;
EXEC sp_fulltext_service 'restart_all_fdhosts';
Exec sp_fulltext_service 'verify_signature', 0

When I run the following statement, it'll show pdf in the resultset.

SELECT * FROM sys.fulltext_document_types order by document_type

Still, content is not found.

HELP!

e.heijmans@12move.nl
Starting Member

10 Posts

Posted - 2014-12-16 : 09:13:12

Anyone?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources