Re: More PDF IFilter problems

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
    ... PDF problem remains, however... ... 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: Can I install SQL Server Enterprise on Windows 2000 SBS
    ... I don't think you can create indexes on views via Enterprise Manager, ... topic "Creating an indexed view" in SQL Server Books Online. ... > I create a view in SQL Server (Standard edition in my SBS) ... >>> Enterprise edition says requires Windows 2000 Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Microsoft Forefront Client Security on SBS 2003 R2
    ... purchase the SQL 2005 standard edition as well as the CALs just as Cris ... we can install SQL Server 2005 Standard Edition on Windows Small ... SQL Newsgroup: microsoft.public.sqlserver.server ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Personal Edition
    ... Does the MS SQL Server 2000 Standard Edition that is included on ... the Small Business Server 2000 Premium edition include MS SQL Server Personal ... it would have also included Personal Edition. ... > purchased it bundles with Small Business Server (because I told hime that SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch. ... instances of SQL Server services are both Standard Editions or Enterprise ... > different edition of Notification Services. ...
    (microsoft.public.sqlserver.setup)