jason davis

Hilary, John, SOS!

I had a major crisis with my sql server today.
After applying Hilary's great advice from here: http://tinyurl.com/inyn I
was able to get things in order.

I'm getting this new error now. It disappers after I try to re-build, but as
soon as I populate (full/incremenet) - I get it again:

ODBC Error Code = 01000 (General warning
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace
[Non-interface error: Unexpected NULL value returned for the column:
ProviderName='Full-text Search Engine', TableName='[FULLTEXT:FT]',
ColumnName='KEY'].

Hilary, I tried your suggestion from here:

=======================
here is a radical idea. Try to determine the row where you are getting this
problem and then update it.
For instance if you find it occurs on a row where the PK is 234523, do
update tablename set textcol=textcol
where pk=234523, do a full population to see if this fixes the problem.
==============

It doesn't help, it happens on all of my tables and catalogs, and they are
not null.

Any help?

hilary cotter

can you post any messages you are getting in your event log - preferably
mssci, or mssearch related errors.

Also post your gatherer log here.

This sounds like something wrong with your environment. Can you give us any
details about your system - ie it was working, but I installed ....... Was
it ever working?

Did you change the SQL Server service account using control panel? Is the
builtin\admin account in the server administrator role?

Did you apply an sp recently? Does sharepoint run on this machine? Office
XP search (this is only significant if you are running NT 4).