2012年3月26日星期一

Full Text Search know which row has error in indexing

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!

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

没有评论:

发表评论