After Installing Adobe filters 9 64 bit Full Text search is not returning any pdf results

Posted on 2012-08-23
Medium Priority
Last Modified: 2012-08-24

Operating System: Windows Server 2008 R2 Standard 64 bit.
Software: Microsoft SQL Server 2008R2

I am having trouble retrieving any results from a full text search on pdf documents. I installed Adobe IFilters 9 for 64 bit machine. I did the following

1. Installed IFilters
2. Ran the following SQL
     EXEC sp_fulltext_service 'load_os_resources', 1;
     EXEC sp_fulltext_service 'verify_signature', 0;
3. Appended C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin\" to the PATH environment
4. Restarted the SQL Full-text Filter Daemon Launcher service
5. Restarted the SQL Server
6. Rebuilt Full Text Catalog and Index
7. Tried deleting and recreating the index and full text catalog
8. I ran this SQL to check the PDF type was in the results which it was with the path to the dll
    select * from sys.fulltext_document_types

So, I have unistalled the IfIlters and done the same over and over again, only once did I retrieve some results but nowhere near the number of results expected. After I rebuilt the indexes that time though it stopped retrieving any pdf results. I dont actually think the pdfs are being indexed in the first place rather than there being a problem retrieving the data.

I am totally at a loss as to what is wrong, I have trawled the internet and tried everything I have found so far but no luck.

If anyone has any suggestions please let me know.

Thanks very much
Question by:Matt_Jsy
  • 2

Accepted Solution

Matt_Jsy earned 0 total points
ID: 38324125
Ok I might have fixed this. I uninstalled SQL Server Compact edition and now the filters seem to be indexing correctly. It has been running for over 30 minutes rebuilding the indexes, it is a 10GB database conatining only documents and running a search on a word in a pdf document is returning more and more rows as the indexes are being built.

I will wait till these indexes have finished being built then re do it a few times and make sure I continue to get rows returned.

It is still working and building indexes on PDFS so I am thinking the solution was to remove the compact edition of sql server. This has worked on two machines now.

Author Closing Comment

ID: 38328630
As i answered it myself I think a Good is the safest grade!

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question