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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


"AndrewJens" <andrewjens@xxxxxxxxxxx> wrote in message
news:1113882924.684496.232480@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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.
>


.

Relevant Pages

  • Re: catalog is empty after populating
    ... SQL Server is installed as the "Microsoft Search" service cannot write it's ... Tools -> Event Viewer and review the Application event log. ... >is only 1 MB and the catalog doesn't contain any items. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Volltextsuche Katalog anlegen geht nicht - Search Dienst und Benutzerkonto
    ... "How to manually reinstall the Microsoft Search service for an instance of SQL Server 2000" ... denn ob der Standard-Setup es richtet, wenn da was kaputt ist, ...
    (microsoft.public.de.sqlserver)
  • Re: fulltext verry attached to moved instance
    ... the event log filled with Error 823 messages. ... stop the microsoft search service on node-2. ... searched the Microsoft search registry on node-2, ...
    (microsoft.public.sqlserver.clustering)
  • fulltext verry attached to moved instance
    ... After this the event log filled with Error 823 messages. ... Both stop when I stop the microsoft search service on node-2. ... My conclusion is that the search service on node-2 is still trying to update the the full text index on instance-1. ... I have searched the Microsoft search registry on node-2, but can not find any regkey that still points toward instance-1. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Fulltext Stops (Deadlocks Occurs)
    ... Cluster resource 'SQL Server Fulltext ' failed. ... The Microsoft Search service terminated unexpectedly. ... >> The Microsoft Search service terminated unexpectedly. ...
    (microsoft.public.sqlserver.fulltext)