Groups | Blog | Home
all groups > sql server full text search > may 2007 >

sql server full text search : Full Text Search know which row has error in indexing


NicolaZap
5/15/2007 6:31:00 AM
Hello everybody,

I have installed SQLServer 2005 for take advantage of full text seach
features.

When I start full population, there are some rows that cause error and not
are indexed.

I see the log in C:\Programmi\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\SQLFT0000700005.LOG. In this file there are seven
rows that have error and for everyone a line that say:

"Error '0x8004fd01: The IFilter::Init() function call failed.' ...
full-text key value 0x495532303045594154504B55. Attempt will be made to
reindex it. The component 'pdffilt.dll' reported error while indexing.
Component path 'C:\Programmi\Foxit Software\Foxit PDF IFilter\pdffilt.dll'."

With different full-text key value for every line.



My question is:

1) Start from a full-text key (ie. 0x495532303045594154504B55), how I arrive
to the record in the source table for understand which is the
problem?Otherwise how can I examine the problem if I don't know the row that
cause the error?

2) What is the error 0x8004fd01?

3) Could be that the PDF filter of Foxit is better than Adobe? With Adobe
filter (version 6) my full pupulation is endless!



Thanks!

NicolaZap
5/15/2007 7:10:03 AM
OK resolved !!!

1)The hexadecimal value must to be converted to decimal and then to ASCII
(http://www.vortex.prodigynet.co.uk/misc/ascii_conv.html)

2) Probably due to the incorrect format because changing the type column
value from ".pdf" to ".txt" the problem has been resolved!!!

3) Wait your opinions :-)



NicolaZap


[quoted text, click to view]
Hilary Cotter
5/16/2007 9:23:24 PM
Is this the 64 bit version of SQL server? If so you should be using Foxit.
[quoted text, click to view]

NicolaZap
5/18/2007 1:34:00 AM
NO, it is the 32 bit versione of SQLServer2005.

[quoted text, click to view]
AddThis Social Bookmark Button