PDF iFilter problems (again!)..

  • Jeff ingham

    SSChasing Mays

    Points: 627

    Using adobe ifilters on filtables..

    This is really a continuation of an earlier topic ( http://www.sqlservercentral.com/Forums/Topic1464679-2799-1.aspx#bm1465104 )

    After getting the adobe iFilter 9 working on the development site on my laptop it was time to deploy to the server..

    I was confident, having spent days fiddling around trying to get the ifilter to index the documents, that deploying to the production server should be a breeze but I'm now getting the error: 'Error '0x8004fd02: The filter daemon MSFTEFD failed to load an IFilter interface for document' whenever I try and index a pdf document..

    So..

    adobe ifilter 9 is installed

    EXEC sp_help_fulltext_system_components 'filter' shows filter the filter for pdf is installed at 'C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin\PDFFilter.dll'

    PATH environment is set to the above directory

    Permissions to the above folder is set to 'EVERYONE' has full control (temporary until I can get it working!)

    ft_index dropped and recreated several times, numerous restarts both of sql services and the complete server but still can't index pdf files!

    All other file types (docX etc) seem to index fine..

    In serious need of some ideas so any help really appreciated.

    Thanks in advance..

  • Jeff ingham

    SSChasing Mays

    Points: 627

    Update and solution...

    The problem in this case proved to be the PATH variable..

    Setting the PATH through Control Panel > System > Advanced System Settings apparently only changes the path for the currently logged on user?

    Running this command:

    DECLARE @RegistryValue NVARCHAR(4000)

    ,@RC INT

    ,@Hive NVARCHAR(128) = N'HKEY_LOCAL_MACHINE'

    ,@Key NVARCHAR(255) = N'SYSTEM\CurrentControlSet\Control\Session Manager\Environment'

    ,@Item NVARCHAR(128) = N'Path';

    EXEC @RC = master.dbo.xp_regread @Hive

    ,@Key

    ,@Item

    ,@RegistryValue OUTPUT

    ,N'Not Used'

    SELECT @RegistryValue RegistryValue;

    Shows the PATH variable actually used, which did NOT contain the path to the iFilter.

    Altered the corresponding key HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > Session Manager > Environment >PATH using regedit to include the path, re-registered the iFilter, dropped and recreated the full text index and everything works fine!

    Not sure whether this is me being slow or whether the documentation is just poor but hopefully this might save someone from premature hair loss!

  • manfred.dusold

    SSC Journeyman

    Points: 79

    I have had the same problem!

    I saerched so long for a solution...

    Thank you very much...with this advice the index of pdf files now works...:-)

  • Jeff Moden

    SSC Guru

    Points: 994560

    Jeff ingham (3/12/2014)


    ...hopefully this might save someone from premature hair loss!

    Apparently, it DID! Well done!

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • EveningStar

    SSC Enthusiast

    Points: 109

    Thank you ever so much for reporting back, Jeff - brilliant and worked like a charm.

    Who would have guessed that installing PDF iFilter doesn't work out of the box without path additions, when iFilter for Office 2010 does? :ermm:

  • Tom Belliotti

    Grasshopper

    Points: 24

    Thanks for figuring this out Jeff. I had the same problem and editing the PATH in the registry as you described fixed it.

  • Lynn Pettis

    SSC Guru

    Points: 442139

    Been a while but I thought there was a way to update the PATH without directly editing the registry.  I will have to do some research over the weekend.

  • Sue_H

    SSC Guru

    Points: 90195

    Lynn Pettis - Friday, October 20, 2017 3:11 PM

    Been a while but I thought there was a way to update the PATH without directly editing the registry.  I will have to do some research over the weekend.

    Maybe you were thinking of setx from the command line?
    You can update the machine environment variables with setx. Will update HKLM instead of HKCU when using the /m switch.

    Sue

  • Lynn Pettis

    SSC Guru

    Points: 442139

    Sue_H - Friday, October 20, 2017 5:05 PM

    Lynn Pettis - Friday, October 20, 2017 3:11 PM

    Been a while but I thought there was a way to update the PATH without directly editing the registry.  I will have to do some research over the weekend.

    Maybe you were thinking of setx from the command line?
    You can update the machine environment variables with setx. Will update HKLM instead of HKCU when using the /m switch.

    Sue

    Actually I seem to remember a GUI interface for doing this.  Of course the last time I had to worry about this I was working with NT 4.0.

  • jasona.work

    SSC-Forever

    Points: 49870

    Lynn Pettis - Friday, October 20, 2017 5:27 PM

    Sue_H - Friday, October 20, 2017 5:05 PM

    Lynn Pettis - Friday, October 20, 2017 3:11 PM

    Been a while but I thought there was a way to update the PATH without directly editing the registry.  I will have to do some research over the weekend.

    Maybe you were thinking of setx from the command line?
    You can update the machine environment variables with setx. Will update HKLM instead of HKCU when using the /m switch.

    Sue

    Actually I seem to remember a GUI interface for doing this.  Of course the last time I had to worry about this I was working with NT 4.0.

    You can, quite easily.
    Right click on Computer-> Properties-> Advanced system settings-> Environment Variables-> then find Path in the System variables section and change away.

  • Lynn Pettis

    SSC Guru

    Points: 442139

    jasona.work - Monday, October 23, 2017 6:29 AM

    Lynn Pettis - Friday, October 20, 2017 5:27 PM

    Sue_H - Friday, October 20, 2017 5:05 PM

    Lynn Pettis - Friday, October 20, 2017 3:11 PM

    Been a while but I thought there was a way to update the PATH without directly editing the registry.  I will have to do some research over the weekend.

    Maybe you were thinking of setx from the command line?
    You can update the machine environment variables with setx. Will update HKLM instead of HKCU when using the /m switch.

    Sue

    Actually I seem to remember a GUI interface for doing this.  Of course the last time I had to worry about this I was working with NT 4.0.

    You can, quite easily.
    Right click on Computer-> Properties-> Advanced system settings-> Environment Variables-> then find Path in the System variables section and change away.

    Thank you, I knew there was an easier way than editing the registry.

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply