Full-Text cannot fetch a row error

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Full-Text cannot fetch a row error

Author

Topic

maximus_vj
Yak Posting Veteran

88 Posts

Posted - 2007-12-17 : 12:06:16

Hello,

I have a SQL Server 2000 database server and I have enabled Full-Text Search on one of its databases. Once in a while I see this error message: Could not fetch a row from OLE DB provider 'Full-text Search Engine'

How to fix this?

My select @@version on my SQL server is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Thanks
maximus_vj

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-17 : 13:24:37

Is mssearch service running all the time?

maximus_vj
Yak Posting Veteran

88 Posts

Posted - 2007-12-17 : 14:34:07

Yes. mssearch is running all the time. After I receive this error, if I do a search it works. And this error occurs twice or thrice a day randomly.

Thanks
maximus_vj

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-17 : 17:03:34

Any error in sql server log and windows event log?

maximus_vj
Yak Posting Veteran

88 Posts

Posted - 2007-12-17 : 17:54:15

No errors in sql server log or windows application log.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-17 : 20:04:30

Checked system event log? If no related error either, may need set profiler trace.