Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DTMark
Starting Member
2 Posts |
 Posted - 2004-06-29 : 16:35:50
|
| Hi,About a week ago the scheduled job to build a full text catalog on one of our Sql 2000 databases began failing.Trying to build the Catalog by right clicking in Enterprise Manager and choosing "Start Full Population" or "Rebuild Catalog" (or even "Delete") returns "error 7619 Execution of a full-text operation failed. An unexpected error occured". I can view the Properties OK which confirm the file is empty.The Microsoft Search service is running. Both that and Sql Server both run in the Local System account. No permissions or passwords have been changed; this has been running fine for months. The disk drive isn't out of space (I'm getting desperate!). The only co-incidence is a reboot after the installation of some recent Win2k hotfixes from Windows Update.I can't delete the Catalog (from Enterprise Manager anyway), I can't repopulate it either. I could try backing out the hotfixes and/or reinstalling the Search service, has anyone got any ideas; are any recent hotfixes known to break the Search Service?Thanks,Mark |
|
|
DTMark
Starting Member
2 Posts |
Posted - 2004-07-20 : 10:42:19
|
| HiI've been working on this problem for some weeks now, but haven't managed to get anywhere - my next step is to completely rebuild the server and reinstall SQL Server to see if it might have been one or more hotfixes that were responsible; has anyone got any ideas what might be causing this before I do so? The basic problem is that Full Text Indexing cannot be enabled on any database - running: sp_fulltext_database 'enable' returns (1 row(s) affected)Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database, Line 46Execution of a full-text operation failed. An unexpected error occurred. I can't help thinking it has something to do with language settings, but just can't track this down. A rebuild will probably solve it for now, but if you have seen this before, please help :-) |
 |
|
|
|
|
|
|
|
Full Text Indexing Error 7619