August 27, 2002 at 6:29 pm
Have you checked to see if the population is done? You can do this by running the following code:
SELECT fulltextcatalogproperty(catalog_name, 'ItemCount')
replace catalog_name with the name of your catalog. This code will return 1 if the population isn't finished yet and 0 if it is done. You can get more information on this by searching in BOL for 'FULLTEXTCATALOGPROPERTY'. Don't try to do any searches until the population is done.
Diane
August 27, 2002 at 8:21 pm
Disk permissions are ok where the catalog is created?
Andy
August 29, 2002 at 9:32 am
I had reviewed the status of the population via exec sp_help_fulltext_catalogs 'VLArchiveFTI' and it showed a status of 0 (idle).
Disk permissions were not a problem.
The following steps have resolved the problem, although I'm not sure why or which of the steps is actually necesary:
1. exec sp_fulltext_table 'tablename', 'drop'
2. rebuild all standard table indexes.
3. sp_fulltext_catalog 'catalog', 'drop'
4. sp_fulltext_service 'Clean_Up' (this might be key here)
5. rebuilt the fulltext indexing environment via Enterprise Manager(EM) Full Text Wizard.
6. manually started population via EM. This time the status changed to 'Population in Progress' in the EM display. Population completed successfully.
August 29, 2002 at 10:16 am
Thanks for posting the follow up!
Andy
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply