Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sql Server Full-Text catalog/index is empty


Sql Server Full-Text catalog/index is empty

Author
Message
solidroots
solidroots
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 70
Hi

I am working on SQL Express 2005 with advanced services which includes full text search. I am using Full-Text catalogs and indexes. Yesterday I created full text catalog and indexes and I was able to perform various full text search queries on the table which had full text index.

But the requirements changed and I had to remove the existing full-text index and catalogs, I recreated the catalog and index on a text column, but I am not getting any results for full-text queries even though they have the keywords for which i am making a full-text search. The query "SELECT fulltextcatalogproperty('catalogname', 'ItemCount');" shows 0 as it's output which means that the full text catalog and index are not getting populated.

Please help in case anyone know on how I can resolve this issue. I even tried using the following commands:
ALTER FULLTEXT INDEX ON START FULL POPULATION;

But it says that the full population is active. Your reply will be greatly appreciated.

Regards

Best Regards
solidroots
Gift Peddie
Gift Peddie
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3456 Visits: 14456
I hope you actually installed it because this feature is not automatic but you said you have used it so the service maybe off in configuration manager turn it on because in the Express and Developer edition most features are turned off by default.

Kind regards,
Gift Peddie
solidroots
solidroots
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 70
The Full text service associated with the sql server is on. I even restrated it in my attemts. Also since I was able to use full text services yesterday there is no point that it is not installed. I know that this service does not come included with the basic express edition, but I had installed this service and had used it and it was working fine.

I checked one of the log files and one of the recent entries in it said:
health monitor reported a failure for full text catalog that is associated with the database.

Thanks for your reply:
Regards
solidroots

Best Regards
solidroots
Gift Peddie
Gift Peddie
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3456 Visits: 14456
Then drop it and create a new one this time make sure auto populating option is used. This will show if something is wrong with your install. I have found the blog post which covers known issues with installs and some configuration you need.

http://rpsetzer.wordpress.com/2007/01/24/configuring-and-using-full-text-search-in-sql-server-2005-express-edition/

Kind regards,
Gift Peddie
solidroots
solidroots
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 70
Gift Peddie (4/16/2009)
Then drop it and create a new one this time make sure auto populating option is used. This will show if something is wrong with your install. I have found the blog post which covers known issues with installs and some configuration you need.

http://rpsetzer.wordpress.com/2007/01/24/configuring-and-using-full-text-search-in-sql-server-2005-express-edition/



Hi Peddie,

Thanks for your reply. I have dropped the existing full text index and catalog, and recreated it. This time I changed the data type of the column on which I need full-text indexing feature to varchar instead of text. And it worked fine by populating the index properly. However when i make a change to any data of this column, then the index is not re populated with new values. Of course I used "WITH CHANGE_TRACKING AUTO" while creating the full-text index. But once I manually repopulate the index by using the command "ALTER FULLTEXT INDEX ON tablename START UPDATE POPULATION;" . The index is updated.

When I check the error log of sql after using the update command it says:

Error '0x80004005' occurred during full-text index population for table or indexed view '[databasename].[dbo].[tablename]' (table or indexed view ID '1268199568', database ID '5'), full-text key value 0x00000053. Attempt will be made to reindex it.

The component 'sqlfth90.dll' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\90\COM\sqlfth90.dll'.


This is a very frustrating issue. I hope I will be able to come up with the solution by help from you guys.

Thanks
Best Regards
solidroots

Best Regards
solidroots
Gift Peddie
Gift Peddie
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3456 Visits: 14456
If you don't have SP3 you need to install it and if you are using PDF column that maybe the issue because Full Text have problems with PDF from 2000. Here is some information about this error. You should know in Express Advanced SP3 is new install with SP3.

http://milambda.blogspot.com/2005_12_01_archive.html

Kind regards,
Gift Peddie
solidroots
solidroots
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 70
I was able to correct this behavior by allowing Remote connections on sql server. But I am not sure on why and how these things are connected.

Best Regards
solidroots
Gift Peddie
Gift Peddie
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3456 Visits: 14456
That could be related to the fact that most features in SQL Server Express and Developer edition are disabled by default. And the SQL Server team removed full text but a developer added the dll and was able to use it so the developer division which uses Express added full text back in the Advanced features. Good to know it is running now.

Kind regards,
Gift Peddie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search