Error in FTS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allan Ebdrup - 17 Jun 2005 14:05 GMT

I have a query
SELECT DISTINCT Top 400 PFSchemaInstance_ID, 0 Rank, 0 CriteriaCount,
FromDate, pfSchemaInstance_ID FROM
PFLightningSearch_PersonProfileImpulse_Publish L WHERE CONTAINS (Text,
'"s*"') Order by FromDate desc, pfSchemaInstance_ID desc

And I know the Text column contains strings with words that begin with s,
but it returns no records.

I've checked that the entry for the FTS index in sysfulltextcatalogs is
correct and I've run:
sp_fulltext_catalog 'FTSindexName', 'rebuild'

What can be wrong with my FTSIndex ?

It has worked at one point.

Reply to this Message

Hilary Cotter - 17 Jun 2005 15:19 GMT

can you issue this query in your database you are full text indexing?

SELECT fulltextcatalogproperty('Cat_Desc', 'ItemCount')

Where Cat_desc is the name of your full text catalog?

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 have a query
> SELECT DISTINCT Top 400 PFSchemaInstance_ID, 0 Rank, 0 CriteriaCount,
[quoted text clipped - 12 lines]
>
> It has worked at one point.

Reply to this Message

Allan Ebdrup - 20 Jun 2005 11:31 GMT

> can you issue this query in your database you are full text indexing?
>
> SELECT fulltextcatalogproperty('Cat_Desc', 'ItemCount')
>
> Where Cat_desc is the name of your full text catalog?

SELECT fulltextcatalogproperty('PFLightningSearch_Publish', 'ItemCount')

Returns 0

Reply to this Message

John Kane - 17 Jun 2005 20:10 GMT

Allan,
What error did you get when you executed the below query? A clause of the
query contained only ignored words? or no results from your query? If the
latter, have you removed all single letters from your language-specific
noise word file? Note, noise.enu = US English.

Additionally, have you run a Full Population after you did the rebuild?
"Rebuild" - Rebuilds fulltext_catalog_name by deleting the existing
full-text catalog from the file system, re-creating the full-text catalog,
and reassociating the full-text catalog with all the tables that have
full-text indexing references. Note, rebuild does not re-populate the FT
Catalog, so you will also need to run a Full Population.

Thanks,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> I have a query
> SELECT DISTINCT Top 400 PFSchemaInstance_ID, 0 Rank, 0 CriteriaCount,
[quoted text clipped - 12 lines]
>
> It has worked at one point.

Reply to this Message

Allan Ebdrup - 20 Jun 2005 11:39 GMT

> Allan,
> What error did you get when you executed the below query? A clause of the
> query contained only ignored words? or no results from your query? If the
> latter, have you removed all single letters from your language-specific
> noise word file? Note, noise.enu = US English.

No results werer returned from the query, actually there is nothing returned
nomatter what I search for, even longer words that I know exist in the text
(ie. "jobtype*").

> Additionally, have you run a Full Population after you did the rebuild?
> "Rebuild" - Rebuilds fulltext_catalog_name by deleting the existing
> full-text catalog from the file system, re-creating the full-text catalog,
> and reassociating the full-text catalog with all the tables that have
> full-text indexing references. Note, rebuild does not re-populate the FT
> Catalog, so you will also need to run a Full Population.

I've done a "Start Full Population" on the Index and now it works!!
Can I put the "start full population" into a SQL script?

Kind Regards,
Allan Ebdrup

Reply to this Message