Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2000 Full Text Population problem, need better resolution than the

Status
Not open for further replies.

cburns70

IS-IT--Management
Sep 12, 2006
19
US
All,
Forgive me for the length of this post, but I need a help resolving the root cause of a Full Text Catalog problem I recently had and hopefully finding an easier solution than the one I came up with. Here’s some background on the problem.

Our database as about 70 tables that are full text enabled. Our catalog stopped populating some time ago. Data that existed in the catalog could still be searched, but new records added to the DB were not searchable.

I tried numerous times to start full population but it simply refused to populate. I found this error in the Event Viewer: “Error: 80041201- The object was not found”.

I googled this error and found several suggestions, none of them resolved my problem though.

I tired rebuilding the catalog, but this made the problem worse. The rebuild drop the existing catalog, but still would not populate the new one. So now there was no search functionality at all.

I decide to rebuild the catalog this time using only one of the 70 tables. Each table I tried would not populate, and it would get the same error in the Event Viewer.

This went on until I finally came across a table that would populate without any errors. This particular table had been recently modified using the Enterprise Manager. I had increased the character length of one of the columns. This incidentally, was not an indexed column.

Once I realized this I decided to modify one of the other tables to see what would happen. After modification, the full text catalog was able to populate on that table.

I looked at the script for a table modification in EM. I thought maybe it was the index being dropped and recreated that was fixing the problem. I tried that on another table, but it didn’t fix the problem.

So the solution seems to be; to use EM to modify the tables. So I went through and did this for all 70 tables. After that I started full population on the catalog and it was able to populate (took 8 hours).

Our full text searching is working, and is better than ever now.

My question is, what caused this and why does using EM to modify the table fix the problem? Is there something else I could have done to fix this? Modifying the tables took about an hour and half. I have test databases that still have same problem; I need to fix those as well.

Any help or suggestions would be greatly appreciated.
Thanks in advance
Charles.
 
It's a mystery.

What you may want to try is....

Enable Profiler. This will allow you to see all the commands that are sent to the SQL server. Do not allow profiler to run for an extended time because it can slow down the performance of your server (because it logs everything).

After starting profiler, repeat the steps you used with EM.

Stop profiler and examine the commands it displays.

Hopefully there will be enough information in the logs to help you solve this problem. Good luck.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top