Problem with SQL2005 and pdf Filter 6.0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin Lavigne - 17 Aug 2006 18:51 GMT

Hi,
I have a DB where I use to store file (.doc , .ppt, etc) everythings
working fine still I add .pdf file. I've Download the 6.0 IFilter from Adobe
and execute the
"exec sp_fulltext_service 'load_os_resources', 1
exec sp_fulltext_service 'verify_signature', 0"
command on my SQL2005 DB.
I can see the .pdf extension in the table sys.fulltext_document_types
(
".pdf" "4C904448-74A9-11D0-AF6E-00C04FD8DC02" "C:\Program Files\Adobe\PDF
IFilter 6.0\PDFFILT.dll" "6.0.0.0" "Adobe Systems Incorporated"
)
I've try the FiltDump.exe with my pdf files and it's seem to return good
result.

My problem is when I try to laugh a full index scan on my table, I receive
errors in Log :
2006-08-17 11:34:44.02 spid22s Error '0x80004005' occurred during
full-text index population for table or indexed view '[dbo].[TablePDF]'
(table or indexed view ID '1325403941', database ID '7'), full-text key value
0x16804DA4A8628F4C93B98F18CB6BF58B. Attempt will be made to reindex it.
2006-08-17 11:34:44.02 spid22s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.3\MSSQL\Binn\MSFTE.DLL'.

I really don't know why I still receive errors because the pdf extension
seems to be recognized.
The filter seems to work cuz I didn't receive error I had before :

" Warning: No appropriate filter was found during full-text index
population for table or indexed view '[dbo].[OfficeDocument]' (table or
indexed view ID '7', database ID '1037402915'), full-text key value
0x22E3A126C07B31478FF1A90843E9E054. Some columns of the row were not indexed."

Need Help Please

Signature

Thanks

Reply to this Message

Hilary Cotter - 17 Aug 2006 20:03 GMT

What is the value of your document type column for the pdfs?

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
> I have a DB where I use to store file (.doc , .ppt, etc) everythings
[quoted text clipped - 35 lines]
>
> Need Help Please

Reply to this Message

Martin Lavigne - 18 Aug 2006 01:40 GMT

Varchar(3) : "PDF"
I tried with Varchar(4) : ".pdf" too, same results

Signature

Thanks

> What is the value of your document type column for the pdfs?
>
[quoted text clipped - 37 lines]
> >
> > Need Help Please

Reply to this Message

Dave Wilson - 09 Aug 2007 17:41 GMT

I had exact the same problem with a mapifilter today.
Your thread was helpful - I think I have the answer.
I had a catalog showing 1117 documents - don't have a filter for most
but wanted to add a mapi ifilter.
I registered it then told sql server to load os resources then rebuilt
the catalog to find errors you mentioned and only 142 document in the FT
catalog.

I only get the problem if 'load_os_resources' is set to 0 at the point
the dll is registered.
If you run :

use master
go
EXEC sp_fulltext_service 'load_os_resources',1
go
EXEC sp_fulltext_service 'verify_signature', 0
go
reconfigure with override

prior to registering the ifilter when you rebuild the FT catalog you get
the full documents in the list.

Have a play - I hope this helps someone else as this has taken ages to
figure out.

Reply to this Message

Martin Lavigne - 19 Aug 2006 18:46 GMT

It's seems the problem come from the computer I used. I tried with another
computer using Microsoft Server 2003 with the same command and everything was
working fine...

Signature

Thanks

> Hi,
> I have a DB where I use to store file (.doc , .ppt, etc) everythings
[quoted text clipped - 31 lines]
>
> Need Help Please

Reply to this Message