 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / November 2006Unique key count = 1
We recently upgraded our sql server to 2005 and now all the Full-Text indexes return zero results. I have created a new fulltext catalog and a done a full population. After the population the catalog props read Unique Key Count : 1, Catalog Size : 0 MB. The event viewer and sql logs show no errors. If I run a select against the table with contains I get 0 results back. The funny thing is there was an existing database with full-text indexing on it and that one still works, but any new catalogs won't populate. Please Help! We have been troubleshooting this for a week now. Mike McCarthy Right click on your database, select full-text index and make sure you have enabled full text. If it has been make sure your population is in progress. If it is can you post your gatherer log here. You can find it in c:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Log where x is your instance name. Your gatherer log will look like this: SQLFT0013000005.LOG.6 or SQLFT0013000005.LOG  SignatureHilary 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 > We recently upgraded our sql server to 2005 and now all the Full-Text > indexes return zero results. [quoted text clipped - 11 lines] > > Mike McCarthy Hi Hilary, thanks for the response. Using SQL Server Management Studio I do not find a selection to enable full text when I click on the database. It is there if I click on the table and choose Full-Text Indexing and I have selected it. I did a full-population on the table (fltProduct with 157080 rows). Here is the log SQLFT0003200006.LOG: 2006-11-14 07:42:56.49 spid24s Informational: Full-text Full population initialized for table or indexed view '[Model_pbs].[dbo].[fltProduct]' (table or indexed view ID '1821249543', database ID '32'). Population sub-tasks: 1. 2006-11-14 07:44:06.50 spid24s Informational: Full-text Full population completed for table or indexed view '[Model_pbs].[dbo].[fltProduct]' (table or indexed view ID '1821249543', database ID '32'). Number of documents processed: 157080. Number of documents failed: 0. Number of documents need retry: 0. 2006-11-14 07:44:06.50 spid24s Changing the status to MERGE for full-text catalog "Model_pbs_Product_Text" (6) in database "Model_pbs" (32). This is an informational message only. No user action is required. > Right click on your database, select full-text index and make sure you have > enabled full text. If it has been make sure your population is in progress. [quoted text clipped - 31 lines] > > > > Mike McCarthy This indicates that you successfully indexed 157080 rows in [Model_pbs].[dbo].[fltProduct] What is the content of these rows you are trying to index? SignatureHilary 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 > Hi Hilary, thanks for the response. > [quoted text clipped - 57 lines] >> > >> > Mike McCarthy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.