Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / May 2007

Tip: Looking for answers? Try searching our database.

Full Text Search know which row has error in indexing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NicolaZap - 15 May 2007 14:31 GMT
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 - 15 May 2007 15:10 GMT
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

> Hello everybody,
>
[quoted text clipped - 32 lines]
>
> Thanks!
Hilary Cotter - 17 May 2007 02:23 GMT
Is this the 64 bit version of SQL server? If so you should be using Foxit.
> OK resolved !!!
>
[quoted text clipped - 45 lines]
>>
>> Thanks!
NicolaZap - 18 May 2007 09:34 GMT
NO, it is the 32 bit versione of SQLServer2005.

> Is this the 64 bit version of SQL server? If so you should be using Foxit.
> > OK resolved !!!
[quoted text clipped - 46 lines]
> >>
> >> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.