2012年2月26日星期日

Full population just hangs...unique count and item count don't move

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?
Also...the status just shows paused after I start the repopulation.
I don't see anything in the gather logs either.
mchi55@.hotmail.com wrote:
> 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?
|||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?
mchi55@.hotmail.com wrote:[vbcol=seagreen]
> Also...the status just shows paused after I start the repopulation.
> I don't see anything in the gather logs either.
> mchi55@.hotmail.com wrote:
|||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
<mchi55@.hotmail.com> wrote in message
news:1162875462.965441.327440@.e3g2000cwe.googlegro ups.com...
>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?
>

没有评论:

发表评论