Unknown full-text failure (8007007e) occurred in function EnumCatalogs on full-text catalog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AndrewJens - 19 Apr 2005 04:55 GMT

Hi,
I get the error message: "Unknown full-text failure (8007007e) occurred
in function EnumCatalogs on full-text catalog" when trying to create a
new full-text catalog in SQL Server 2000 Developer SP3 (on XP Pro SP2).
The same database under SQL Server Personal (on Windows 2000) works
without a problem.

I have checked the following:
- Microsoft Search service, and SQL Agent service have started (with no
errors found in the event logs)
- the Search service and SQL Server Service log on as Local System (is
that OK?)

I found the following three lines in the sqlsp.log file:
12:42:13 Setup is installing the Microsoft Full-Text Search Engine ...
12:42:13 "C:\temp\sql2ksp3\x86\FullText\MSSearch\Search\SearchStp.exe"
/s /a:SQLServer
12:42:34 Process Exit Code: (0)
But the very last line in the same file is the following:
12:42:58 Installation Completed with Errors (number of nonfatal errors:
1)
Looking through the log file, I can't find anything that appears like a
failure - all Process Exit Codes are (0).

I just can't find anything through Google that would suggest an answer.
Any help would be appreciated. Thanks in advance.

Reply to this Message

John Kane - 19 Apr 2005 06:15 GMT

Andrew,
The below hex value (8007007e) in your error message indicates that the
specified module could not be found. However, without further information
from your server's Application event log (always the first place to look for
FT population errors), it is difficult to troubleshoot this error. What is
the exact version of SQL Server (SELECT @@version) and is it a clustered
server?

Yes, it is ok for both the MSSQLServer and "Microsoft Search" be running
under LocalSystem. In fact, it is required that the 'Microsoft Search" be
running under LocalSystem. This is most likely an missing or incorrect
registry key or value or possible a dll did not get properly registered. If
the latter, you may want to try re-registering the following dll's (assumes
the c:\ drive, if not change it):

regsvr32 c:\winnt\System32\athprxy.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\Common\mssitlb.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\ftsqlpar.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\mssadmin.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\msscntrs.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\mssmmcsi.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\mssmsg.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\mssmulpi.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\mssph.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\mssrch.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\msstools.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\nlhtml.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\objcreat.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\offfilt.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\propdefs.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\srchadm.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\srchidx.dll
regsvr32 c:\PROGRA~1\COMMON~1\System\MSSearch\bin\tquery.dll

After registring the above dll's, re-try creating a new full-text catalog.
If you still get the error (same hex code), then you may want manually
remove and re-install the FTS components via the procuedures in KB article
827449 "How to manually reinstall the Microsoft Search service for an
instance of SQL 2000" at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449

Hope that helps!
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Hi,
> I get the error message: "Unknown full-text failure (8007007e) occurred
[quoted text clipped - 22 lines]
> I just can't find anything through Google that would suggest an answer.
> Any help would be appreciated. Thanks in advance.

Reply to this Message

AndrewJens - 20 Apr 2005 01:33 GMT

Thanks for these suggestions.

I have regsvr32ed the dlls you suggested. All worked except
srchadm.dll. No matter how I try, I simply get the message:
LoadLibrary(...) failed - The specified module could not be found
I'm logged on as administrator. The dll is sitting in the
'...MSSearch\bin\' directory (as you indicated), and has the following
details: '30/01/2004 12:36 AM 229,376 SRCHADM.DLL".

The SELECT @@version command gives the following:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05
    Copyright (c) 1988-2003 Microsoft Corporation
    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

It is not a clustered server. There are no Errors in the server's
application event log to do with SQLServer.

Anyhow, so far no luck, as the full-text catalog still can't be
created. I will give the "How to manually reinstall the Microsoft
Search service for an instance of SQL 2000" a go when I get a chance.
Thanks once again.

Reply to this Message

John Kane - 20 Apr 2005 05:07 GMT

Andrew,
Don't worry about srchadm.dll as its really not one of the key dll's.
However, I'm not surprised that the even with re-registering the dll's that
a full-text catalog still can't be created. So, it is best that you remove
and manually reinstall the FTS components. If the procedures in the KB
article fail to resolve this issue for you (and they have in past
situations), please repost and I can provide you with other solutions.

Thanks,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> Thanks for these suggestions.
>
[quoted text clipped - 18 lines]
> Search service for an instance of SQL 2000" a go when I get a chance.
> Thanks once again.

Reply to this Message

AndrewJens - 26 Apr 2005 01:40 GMT

I followed the instructions in the "How to manually reinstall the
Microsoft Search service for an instance of SQL Server 2000", and I can
now create a full text catalog.
Thanks once again.

Reply to this Message