Re: More PDF IFilter problems
- From: "LiveCycle" <livecycle@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 27 Sep 2007 14:45:30 -0700
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
.
- Follow-Ups:
- Re: More PDF IFilter problems
- From: LiveCycle
- Re: More PDF IFilter problems
- References:
- More PDF IFilter problems
- From: LiveCycle
- More PDF IFilter problems
- Prev by Date: More PDF IFilter problems
- Next by Date: CONTAINS not returning anything
- Previous by thread: More PDF IFilter problems
- Next by thread: Re: More PDF IFilter problems
- Index(es):
Relevant Pages
|