Re: More PDF IFilter problems

Sorry, scratch that last one, the DOC file I was looking at was corrupted.
PDF problem remains, however...
Thanks!
"LiveCycle" <livecycle@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O1Tn0fVAIHA.5184@xxxxxxxxxxxxxxxxxxxxxxx
OK, this gets stranger by the minute. I am able to successfully index
Excel files, but I am not able to index Word documents! I get this
message in my logs.

2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document format
is not recognized by the filter.' occurred during full-text index
population for table or indexed view '[RMSTest].[Template].[Content]'
(table or indexed view ID '2142018762', database ID '12'), full-text key
value 0x00000003. Attempt will be made to reindex it.
2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported
error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'.

Please, I will lose all my hair soon, any ideas are welcome.



"LiveCycle" <livecycle@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eyhiy9UAIHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
So, I have found the log, and am receiving the following error
information:

2007-09-27 14:40:23.13 spid21s Informational: Full-text Full
population initialized for table or indexed view
'[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762',
database ID '12'). Population sub-tasks: 1.
2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should
reprocess this document in an isolated fashion to confirm the error.'
occurred during full-text index population for table or indexed view
'[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762',
database ID '12'), full-text key value 0x00000001. Attempt will be made
to reindex it.
2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported
error while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for
embedded object was found during full-text index population for table or
indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID
'2142018762', database ID '12'), full-text key value 0x00000002. Some
embedded objects in the row could not be indexed.
2007-09-27 14:40:37.24 spid21s Informational: Full-text Full
population completed for table or indexed view
'[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762',
database ID '12'). Number of documents processed: 2. Number of documents
failed: 0. Number of documents need retry: 1.

Clearly, it doesn't like my IFilter. Any ideas how I can make SQL
recognize this?

Thanks, Jim

"LiveCycle" <livecycle@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23o1jMiUAIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

I'm having some frustrating issues with the PDF IFilter and making it
work. I've read the other posts here, and still haven't been able to
figure this out. I am running SQL Server 2005 Standard 32 bit edition
on Windows Server 2003 Standard Edition. I performed the following:

1 - Installed the PDF IFilter v 6.0
2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1
3 - Stopped and restarted the SQL Server service
4 - Ran sys.fulltext_document_types and verified that .pdf was indeed a
valid document type
5 - Built a new full-text catalog and added my table with PDF & other
files (stored as image data type) to the catalog
6 - Fully populated the FT index
7 - Ran my CONTAINS query against that table. I'm able to return
results against Office files, but nothing for PDF files.

So, I'm not sure what I should do at this point. I even tried
restarting the server itself. Somebody (Hilary Cotter?) mentioned that
it might be possible to look at gatherer logs somewhere, but I'm not
clear where those would be. I would appreciate any further suggestions.

Thanks, Jim







.

Relevant Pages

  • Re: More PDF IFilter problems
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... PDF problem remains, however... ... I'm having some frustrating issues with the PDF IFilter and making it ...
    (microsoft.public.sqlserver.fulltext)
  • Re: More PDF IFilter problems
    ... I did generate a new PDF file (which is ... Looking for a SQL Server replication book? ... occurred during full-text index population for table or indexed view ... I'm having some frustrating issues with the PDF IFilter and making ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Adding PDF indexing with Sql Server 2005
    ... Looking for a SQL Server replication book? ... > index pdf files. ... I have downloaded and installed the Adobe PDF iFilter ... > It does index the pdf files. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: PDF iFilter install on WSS
    ... This might have some effect on your ability to search WSS sites. ... Unfortunately I don't have SQL Server 2005 so I can't check. ... PDF iFilter works fine with WSS. ... I'm trying to get the Adobe PDF ifilter to work, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: PDF iFilter 8/9 with SQL Server?
    ... before there were instructions for Sharepoint but nothing for SQL Server. ... app (it's based on the xpdf source code) to handle PDF packages too, ... adobe site for version 9/ ifilter. ...
    (microsoft.public.sqlserver.fulltext)