Re: More PDF IFilter problems



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
    ... 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)
  • More PDF IFilter problems
    ... I'm having some frustrating issues with the PDF IFilter and making it work. ... I am running SQL Server 2005 Standard 32 bit edition on Windows Server ... against Office files, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: More PDF IFilter problems
    ... Looking for a SQL Server replication book? ... PDF is it? ... occurred during full-text index population for table or indexed view ... I'm having some frustrating issues with the PDF IFilter and making it ...
    (microsoft.public.sqlserver.fulltext)
  • Re: More PDF IFilter problems
    ... embedded object was found during full-text index population for table or ... I'm having some frustrating issues with the PDF IFilter and making it ... I am running SQL Server 2005 Standard 32 bit edition on ... Windows Server 2003 Standard Edition. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problems with Full Text Index Population
    ... helpful info in troubleshooting FTS issue. ... you're using SQL Server 2000 based upon the below information. ... > I found a document that described some of the performance counters ... > Notification Rate' when the index population ...
    (microsoft.public.sqlserver.fulltext)