How do I identify the pdf file that the fulltext index is stalled

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

telaan - 22 Dec 2006 02:03 GMT

Hello,
We just installed the Adobe iFilter and have rebuilt the fulltext catalog to
pickup the old filters. The catalog is able to add new items and picked up
most of the old ones, but it is stuck on 'Population in progress'. I found a
post that indicates that one or more files (specifically pdf's) might be the
problem. How do identify the files so that I can delete them from the
database?
Any and all help is greatly appreciated!

Thanks

Running:
SharePoint 2003 (different server)
SQL Server 2000 sp3a - clustered
Windows 2003 SP1

Reply to this Message

Hilary Cotter - 24 Dec 2006 02:18 GMT

With SQL 2000 it is rather hard. Basically look in the gatherer logs and it
will tell you the hex value for the primary key value. If you have an
integer data type column for your pk you convert the hex number to an
integer. If it is an ascii value convert the hex value to integer and then
convert it to char. For example if you get a hex value of 0x40, this is 64,
this corresponds to an ascii value of @

Signature

Hilary Cotter

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

> Hello,
> We just installed the Adobe iFilter and have rebuilt the fulltext catalog
[quoted text clipped - 15 lines]
> SQL Server 2000 sp3a - clustered
> Windows 2003 SP1

Reply to this Message

telaan - 28 Dec 2006 23:33 GMT

Thank you!

> With SQL 2000 it is rather hard. Basically look in the gatherer logs and it
> will tell you the hex value for the primary key value. If you have an
[quoted text clipped - 22 lines]
> > SQL Server 2000 sp3a - clustered
> > Windows 2003 SP1

Reply to this Message