Cenario:
=========================================================
Server: Clustered Windows 2000 Advanced Server SP4
DB : MSSQL Server Enterprise Edition, SP 3, version 8.0.0.760
Instaled services: MSSearch, SQL Server, Agent, T-Transaction

- All services instaled, and online in cluster management.
SP_fulltext_database, and others are returning values as supposed
(enabled=1, resourceusage=3).

- SQLServer and MSSearch are running on a domain account.
This account has full permitions on both project and master database

Problem:
=========================================================

I'm trying to create (and populate) a Full Text Catalog containing a
single
table index. The Catalog is sucessfully created but when I start
a Full Population the problem occurs.

First the Gatherer shows the following Event in Application Log:
Crawl on projecto <...> has started
Gatherer logs show the same as Event Viewers.

SQL server (and server itself) does not hang, but processors remain
calm.
No memory usage is detected, and Performance monitor on process
MSSearch.exe keeps stable while catalog is supposed to be populating.

Setting Audit type = full still shows no errors in any log (cluster
log,
SQLserver log, event viewer or gatherer log).

Catalog status show "Populating" but it takes very long time
(aproximatly 1 hour in a non clustered SQL Server) with no effect on
catalog.
The Properties menu always shows item count=0

Tried Catalog population thru 6 hours on dual PIII 800 MHz processors
,
1GB RAM, on a 310000 entries table, at the end, still 0 item count.

Any help would be kindly appreciated,

Ricardo Simões

Hi Ricardo,

How many rows do we need to full-text index. If we are in the order of
millions of rows then the population can take days. Can you post the
Windows application and system event logs from the node that the SQL Server
is running on? Are there any other messages from MSSEARCH other than the
one mentioned in your email? I am not sure if the ItemCount is updated
dynamically or only when the population is finished.

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

[quoted text, click to view]

Hi, there are aprox. 3 thousand rows and in our development server it takes
about an hour to populate. The problem only happens in the cluster.

[quoted text, click to view]

Sorry, but there aren't any events or log messages.

[quoted text, click to view]

In our development server we can track ItemCount because it is updated
as it goes, only the TotalItems column is updated at the end.

Thanks,

Ricardo Simões
[quoted text, click to view]