SQL 64bit SP4 - Server: Msg 7342 - Unexpected NULL value returned

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tran.hai@gmail.com - 09 Jun 2005 17:02 GMT

Hi,

I've been googled and haven't found any soloution yet. I'm getting the
following error while doing a CONTAINS query on a fulltext catalog.

Server: Msg 7342, Level 16, State 1, Line 1
Unexpected NULL value returned for column '[TextData].KEY' from the OLE
DB provider 'Full-text Search Engine'. This column cannot be NULL.
OLE DB error trace [Non-interface error: Unexpected NULL value
returned for the column: ProviderName='Full-text Search Engine',
TableName='[TextData]', ColumnName='KEY'].

sample query:
select columnName from tableName where contains (*,'France')

@@version:
Microsoft SQL Server 2000 - 8.00.2039 (Intel IA-64)
    May 3 2005 23:34:52
    Copyright (c) 1988-2003 Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service
Pack 1)

No error in even logs, few common error in gather logs (... Error
fetching URL ...).

It's bizarre that I only got the error on some of the search keyword
but not all, and on the trouble keyword if I did select top 3000 then
it ran fine but errored out for larger number of row.
None of the row has NULL value on the "key" column, and the indexed
column.

I have tried to rebuild the catalog, replaced ..\config\schema.txt (5K)
with the schema.txt (tried both of the 5k and 24k files) from SP4 then
rebuild the catalog. Nothing helps so far. I'm planning to uninstall
then reinstall the MS Search - not sure if this will do any help. It's
an 8 million rows table, and it takes 3-4 days to build the catalog.

I'd appreciate for any suggestion.

thanks,
Hai

Reply to this Message

Hilary Cotter - 09 Jun 2005 19:20 GMT

Can you post your gatherer log here? Please attach it or send it to me
offline.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 37 lines]
> thanks,
> Hai

Reply to this Message

tran.hai@gmail.com - 10 Jun 2005 19:17 GMT

Hilary,

Thanks for your help. I will email you the gatherer log offline. I've
decideded to uninstall and reinstal the SQL without applying SP4. The
catalog is populating now, and so far so good but can't tell for sure
'til it finish in another day or two.

I'm very interesting in obtaining a copy of your book on SQL FullText.
How soon will you have it available?

Thanks,
Hai

> Can you post your gatherer log here? Please attach it or send it to me
> offline.
[quoted text clipped - 47 lines]
> > thanks,
> > Hai

Reply to this Message

tran.hai@gmail.com - 13 Jun 2005 15:14 GMT

I have reinstalled SQL (without applying SP4 this time), and rebuilt
the catalog. The first few couple hours, I can query it fine. It's
still populating, but now my query failed with the same error of
"Unexpected NULL value returned for column....".

Here is my latest gatherer log:

Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

6/13/2005 2:42:42
AM    MSSQL75://SQLServer/7e77b618/A81CB90C7DD92A8523E1D15FEB3B5AD11E133489    Add    Error
fetching URL, (80004001 - Not implemented
)
6/13/2005 3:11:34
AM    MSSQL75://SQLServer/7e77b618/AADE2BD506118D7878F727F3DD9C747112FBE943    Add    Error
fetching URL, (80040d54 - The filtering has been aborted because of a
user action, such as stopping the crawl. )
6/13/2005 3:19:16
AM    MSSQL75://SQLServer/7e77b618/AB77F22AA2731DCE8302E74601AF49D19ACDE146    Add    Error
fetching URL, (80004001 - Not implemented
)
6/13/2005 3:58:56
AM    MSSQL75://SQLServer/7e77b618/ADEE5843DB404EC419ADB18A3BAF41A8514EEAB5    Add    Error
fetching URL, (80004001 - Not implemented
)
6/13/2005 4:14:54
AM    MSSQL75://SQLServer/7e77b618/AEC47897B346722A2E9120ABD26CF270B2DD1994    Add    Error
fetching URL, (80041201 - The object was not found. )
6/13/2005 4:28:30
AM    MSSQL75://SQLServer/7e77b618/AF6A64048B44D50F4DE316F8F56D9BD6F8E8D3F0    Add    Error
fetching URL, (80040d54 - The filtering has been aborted because of a
user action, such as stopping the crawl. )
6/13/2005 5:15:34
AM    MSSQL75://SQLServer/7e77b618/B185B6D2A1335A5DF57BB1BE1830AA0A88CB8539    Add    Error
fetching URL, (80004001 - Not implemented
)
6/13/2005 5:27:10
AM    MSSQL75://SQLServer/7e77b618/B1F66BD3B24ABA409176AC2325F07C7FF66B41BF    Add    Error
fetching URL, (80040d54 - The filtering has been aborted because of a
user action, such as stopping the crawl. )
6/13/2005 5:29:18
AM    MSSQL75://SQLServer/7e77b618/B210BF1E3B2D0A8EC921E7E7076A687290F9E3C8    Add    Error
fetching URL, (80004001 - Not implemented
)
6/13/2005 6:40:46
AM    MSSQL75://SQLServer/7e77b618/B4A72C0E4680BAEBAA35C94DF0D7059A31501F9B    Add    Error
fetching URL, (80040d54 - The filtering has been aborted because of a
user action, such as stopping the crawl. )

thanks,
Hai

Reply to this Message

Hilary Cotter - 13 Jun 2005 16:15 GMT

The not implemented error normally means search dll corruption. Try to
reregister them as follows and start it up again.

Copy the below commands into a batch file and run them from a command
prompt.

cd "C:\Program Files\Common Files\System\MSSearch\Bin\"
%windir%\system32\Regsvr32 lcdetect.dll
%windir%\system32\Regsvr32 mssadmin.dll
%windir%\system32\Regsvr32 mssmmcsi.dll
%windir%\system32\Regsvr32 mssws.dll
%windir%\system32\Regsvr32 offfilt.dll
%windir%\system32\Regsvr32
%WINDIR%\System32\athprxy.dll
%windir%\system32\Regsvr32 ftsqlpar.dll
%windir%\system32\Regsvr32 msscntrs.dll
%windir%\system32\Regsvr32 mssmsg.dll
%windir%\system32\Regsvr32 mssmulpi.dll
%windir%\system32\Regsvr32 mssph.dll
%windir%\system32\Regsvr32 mssrch.dll
%windir%\system32\Regsvr32 msstools.dll
%windir%\system32\Regsvr32 objcreat.dll
%windir%\system32\Regsvr32 propdefs.dll
%windir%\system32\Regsvr32 srchadm.dll
%windir%\system32\Regsvr32 srchidx.dll
%windir%\system32\Regsvr32 tquery.dll
%windir%\system32\Regsvr32 query.dll
%windir%\system32\Regsvr32 %WINDIR%\Cluster\gathercl.dll
%windir%\system32\Regsvr32 nlhtml.dll
cd "C:\Program Files\Common Files\System\MSSearch\common\"
%windir%\system32\Regsvr32 mssitlb.dll
%windir%\system32\Regsvr32 %windir%\System32\athprxy.dll

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> I have reinstalled SQL (without applying SP4 this time), and rebuilt
> the catalog. The first few couple hours, I can query it fine. It's
[quoted text clipped - 8 lines]
> 6/13/2005 2:42:42
> AM MSSQL75://SQLServer/7e77b618/A81CB90C7DD92A8523E1D15FEB3B5AD11E133489

Add Error

> fetching URL, (80004001 - Not implemented
> )
> 6/13/2005 3:11:34
> AM MSSQL75://SQLServer/7e77b618/AADE2BD506118D7878F727F3DD9C747112FBE943

Add Error

> fetching URL, (80040d54 - The filtering has been aborted because of a
> user action, such as stopping the crawl. )
> 6/13/2005 3:19:16
> AM MSSQL75://SQLServer/7e77b618/AB77F22AA2731DCE8302E74601AF49D19ACDE146

Add Error

> fetching URL, (80004001 - Not implemented
> )
> 6/13/2005 3:58:56
> AM MSSQL75://SQLServer/7e77b618/ADEE5843DB404EC419ADB18A3BAF41A8514EEAB5

Add Error

> fetching URL, (80004001 - Not implemented
> )
> 6/13/2005 4:14:54
> AM MSSQL75://SQLServer/7e77b618/AEC47897B346722A2E9120ABD26CF270B2DD1994

Add Error

> fetching URL, (80041201 - The object was not found. )
> 6/13/2005 4:28:30
> AM MSSQL75://SQLServer/7e77b618/AF6A64048B44D50F4DE316F8F56D9BD6F8E8D3F0

Add Error

> fetching URL, (80040d54 - The filtering has been aborted because of a
> user action, such as stopping the crawl. )
> 6/13/2005 5:15:34
> AM MSSQL75://SQLServer/7e77b618/B185B6D2A1335A5DF57BB1BE1830AA0A88CB8539

Add Error

> fetching URL, (80004001 - Not implemented
> )
> 6/13/2005 5:27:10
> AM MSSQL75://SQLServer/7e77b618/B1F66BD3B24ABA409176AC2325F07C7FF66B41BF

Add Error

> fetching URL, (80040d54 - The filtering has been aborted because of a
> user action, such as stopping the crawl. )
> 6/13/2005 5:29:18
> AM MSSQL75://SQLServer/7e77b618/B210BF1E3B2D0A8EC921E7E7076A687290F9E3C8

Add Error

> fetching URL, (80004001 - Not implemented
> )
> 6/13/2005 6:40:46
> AM MSSQL75://SQLServer/7e77b618/B4A72C0E4680BAEBAA35C94DF0D7059A31501F9B

Add Error

> fetching URL, (80040d54 - The filtering has been aborted because of a
> user action, such as stopping the crawl. )
>
> thanks,
> Hai

Reply to this Message

tran.hai@gmail.com - 14 Jun 2005 21:59 GMT

I've got error on these two files LCDETECT.DLL and MSSWS.DLL while both
trying to register or unregister them. This is the error message:
dllname was loaded, but DLLRegisterServer/DLLUnregisterServer entry
point was not found. This file cannot be registered. I've tried to
run Regsvr32 under both window\system32 and window\syswow64 with the
same error result.

Per MS PSS advice (i've opened an incident case), I've now replace
schema.txt at
c:\program files\common
files\system\mssearch\data\applications\sqlserver\config
c:\program files\common files\system\mssearch\data\data\config
with the schema.txt file in:
c:\program files\microsoft sql server\mssql$<instance_name>\binn

also manually reinstall MS Search. I'm populating the catalog now and
anxiously waiting for it to finish :)

Do you think those two LCDETECT.DLL and MSSWS.DLL are crucial for the
fulltext to work? i didn't get a clear answer from MS, they think it
either corrupted or not support 64bit.

Thanks,
Hai

Reply to this Message

Hilary Cotter - 16 Jun 2005 14:42 GMT

While they are crucial they might not be COM components and this might be
why you got this error message.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> I've got error on these two files LCDETECT.DLL and MSSWS.DLL while both
> trying to register or unregister them. This is the error message:
[quoted text clipped - 20 lines]
> Thanks,
> Hai

Reply to this Message