August 28, 2009 at 1:32 pm
Has anyone been able to full-text index PDF documents on 64-bit SQL Server 2008 using the Adobe 64-bit PDF iFilter?
Anyone having 3rd party iFilter problems?
We're getting the following error in the log for any row that has a PDF document:
[font="Courier New"]Warning: No appropriate filter was found during full-text index population for table or indexed view '[TestDB1].[dbo].[Documents]' (table or indexed view ID '277576027', database ID '10'), full-text key value 'D448F8EC-EB6E-4658-B9D4-CE44E7DE6552'. Some columns of the row were not indexed.[/font]
Configuration:
OS: 64-bit Windows 2008 Server R2
SQL Server: 64-bit 2008 Developer Edition SP1 + Cumulative Update 3 (Build 10.0.2723)
PDF iFilter: Adobe PDF iFilter 9 for 64-bit platforms http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
Note that this does work correctly on 32-bit platforms (e.g. Windows XP Pro) using SQL Server 2008 at the same maintenance level (Build 10.0.2723) using the iFilter provided with the Adobe Reader 9.1. So the problem is purely related to 64-bit.
The 64-bit PDF iFilter is properly installed and shows properly in sys.fulltext_document_types. The path shown in sys.fulltext_document_types is also correct.
There is a KB article (http://support.microsoft.com/kb/972650) that deals with an issue related to iFilters. However,
1. the KB doesn't mention Windows Server 2008 nor 32-bit/64-bit
2. The fix is in CU6 (pre-SP1) but not in CU3 (post-SP1)
3. The path that SQL Server shows to the iFilter is correct on both 32-bit and 64-bit version of my SQL Server 2008
4. I've confirmed that the problem doesn't exist on 32-bit OSs at CU3.
August 31, 2009 at 12:13 pm
Found the fix! I.e., RTFM
After installing the PDF iFilter, it is recommended that you set your system PATH environment variable to the "bin" folder of the "Ifilter" installation.
For 64-bit SQL Server 2008, it is REQUIRED.
Related documents:
Adobe Installation Instructions:
http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
(blog) Adobe PDF iFilter 9 for 64-bit Platforms now available
http://blogs.adobe.com/acrobat/2008/12/adobe_pdf_ifilter_9_for_64bit.html
See Erik's posting February 9, 2009 5:05 AM and answer.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply