Groups | Blog | Home
all groups > sql server full text search > november 2006 >

sql server full text search : Full population just hangs...unique count and item count don't move


mchi55 NO[at]SPAM hotmail.com
11/6/2006 8:57:43 PM
I create a catalog. The exact same database tables work in another
environment for the full population.

But this server when I do a full population...it just hangs and says
population in progress.
However the item count, unique key count and catalog size does not
grow.
There's nothing in the application logs.

Where else can I look?

I'll also notice on the server where the population works...under the
properties for the catalog...it says the location of the catalog is on
the C:\program files\microsoft sql server\mssql\ftdata.
But there's nothing in the folder. The catalog files are actually on
D:\mssql\FtDATA.

Is that normal?
mchi55 NO[at]SPAM hotmail.com
11/6/2006 9:12:01 PM

Also...the status just shows paused after I start the repopulation.

I don't see anything in the gather logs either.

[quoted text, click to view]
mchi55 NO[at]SPAM hotmail.com
11/6/2006 9:19:02 PM
One more piece of info...
I tried creating a full text index in the Northwind database...and that
won't populate either with the same issues.

Perhaps there's something wrong with the MSSearch?
Is there something to reinstall it? Any more ideas on how to
troubleshoot?


[quoted text, click to view]
Hilary Cotter
11/7/2006 12:00:00 AM
When you say there is nothing in C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA, there should be a folder within this directory called
SQLServer.

It sounds like there is something badly wrong here. Check again to verify
that there is nothing in the application log from MSSCI or MSSearch. If not
I suggest you re-install.

Follow the below for more info on how to do this.

http://support.microsoft.com/kb/827449/en-us

--
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



[quoted text, click to view]

AddThis Social Bookmark Button