Full-text seacrh not worked

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 29 May 2006 06:07 GMT

I cannot make the catalog active.
I tried both using T-SQL and inside EM in SQL 2000 but the status is still
idle.
Any rules I need to stick to? eg. what user login, authentication mode..etc

Reply to this Message

Hilary Cotter - 29 May 2006 15:33 GMT

Are there any messages in the event log from MSSCI or MSSearch or is there
anything in the gatherer logs?

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

>I cannot make the catalog active.
> I tried both using T-SQL and inside EM in SQL 2000 but the status is still
> idle.
> Any rules I need to stick to? eg. what user login, authentication
> mode..etc

Reply to this Message

Alan - 30 May 2006 00:17 GMT

Hi Hilary,

I think you have suggested me to find out the event log but can you tell me
how to look at the event log please?

> Are there any messages in the event log from MSSCI or MSSearch or is there
> anything in the gatherer logs?
[quoted text clipped - 12 lines]
> > Any rules I need to stick to? eg. what user login, authentication
> > mode..etc

Reply to this Message

Alan - 31 May 2006 01:43 GMT

Hi Hilary,

these are the code I used:
Use Pubs
EXEC sp_fulltext_catalog 'Demo', 'create'

EXEC sp_fulltext_table 'employee', 'create', 'Demo', 'pk_emp_id'

EXEC sp_fulltext_column 'employee','fname','add', 0
EXEC sp_fulltext_column 'employee','lname','add', 0

EXEC sp_fulltext_table 'employee','activate'

EXEC sp_fulltext_catalog 'Demo', 'start_full'

EXEC sp_fulltext_table 'employee','start_change_tracking'
EXEC sp_fulltext_table 'employee','start_background_updateindex'

I got the gatherlog pop up box:
31/5/2006 10:29:24 am Add The gatherer has started.

What does that mean ?

Go to the EM to see my catalog property:
Status tab -
Status: Idle
Item count: 0
Catalog size: 1 MB
Unique key count: 1
Last population date: 31/05/2006 10:29:24 am

Tables tab -
Table: employee
Fulll-text indexing enabled: Yes

So it seems the catalog did not get populated as I think because the item
count is 0.

> Hi Hilary,
>
[quoted text clipped - 18 lines]
> > > Any rules I need to stick to? eg. what user login, authentication
> > > mode..etc

Reply to this Message

Alan - 31 May 2006 02:26 GMT

Ah yes, there are more pop up boxes:

One box said: Error fetching URL (, 800700e9 - No process is on the other
end of the pipe)
The last box said: Complete full crawl.

> Hi Hilary,
>
[quoted text clipped - 58 lines]
> > > > Any rules I need to stick to? eg. what user login, authentication
> > > > mode..etc

Reply to this Message

Hilary Cotter - 31 May 2006 03:38 GMT

Do you know which iFilter you are using?

Signature

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

> Ah yes, there are more pop up boxes:
>
[quoted text clipped - 66 lines]
>> > > > Any rules I need to stick to? eg. what user login, authentication
>> > > > mode..etc

Reply to this Message

Alan - 31 May 2006 04:17 GMT

Hi Hilary,

I have not installed any additional filter.

> Do you know which iFilter you are using?
>
[quoted text clipped - 82 lines]
> >> > > > Any rules I need to stick to? eg. what user login, authentication
> >> > > > mode..etc

Reply to this Message