Catalog Not populating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 21 Jul 2004 19:54 GMT

I can not get the full text catalog to populate.

I have tried it on the most basic datababase and table.

The catalog creates, and it says it successfully
populates, but yet the item count is 0.

I have restored the same DB on a different server, and it
works fine. I have tried so many KB articles with no
luck. Has anyone every seen this?

Any help is appreciated.

Reply to this Message

Hilary Cotter - 21 Jul 2004 20:11 GMT

The most obvious causes of this problem is:

http://support.microsoft.com/default.aspx?scid=kb;en-us;317746&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;295772&Product=sql2k

Have you already followed the advice in these kb's?

Also please post the any messages you are getting in the application log
from MSSearch or MSSCI.

Signature

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

> I can not get the full text catalog to populate.
>
[quoted text clipped - 8 lines]
>
> Any help is appreciated.

Reply to this Message

- 21 Jul 2004 21:17 GMT

Here are the warnings

-------------------------------------
The crawl on project <SQLServer SQL0015500005> cannot be
started. All of the crawl seeds have been ignored because
of host, extension, or other URL restrictions. Error:
80040d07 - The specified URL is excluded and will not be
cataloged. The URL restriction rules may have to be
modified to include this URL.
--------------------------------------
The crawl seed <MSSQL75://SQLServer/6497e884> in project
<SQLServer SQL0015500005> cannot be accessed. Error:
80040d07 - The specified URL is excluded and will not be
cataloged. The URL restriction rules may have to be
modified to include this URL
-----------------------------------------
One or more warnings or errors for Gatherer project
<SQLServer SQL0015500005> were logged to file
<e:\MSSQL\FTDATA\SQLServer\GatherLogs\SQL0015500005.1.gthr>
. If you are interested in these messages, please, look at
the file using the gatherer log query object (gthrlog.vbs,
log viewer web page).
---------------------------------------------

I also ran thhrlog.vbs and got the following.

7/21/2004 4:10:56 PM Add The gatherer has
started
7/21/2004 4:10:56 PM Add The initialization
has completed
7/21/2004 4:11:10 PM Add Started Full
crawl
7/21/2004 4:11:10 PM MSSQL75://SQLServer/6497e884
Add URL is excluded
because the URL protocol is not recognized or restricted
7/21/2004 4:11:10 PM Add Completed Full
crawl

Anything anyone can do, would be amazing. I have been
trying for days!

Thanks

>-----Original Message-----
>The most obvious causes of this problem is:
>
>http://support.microsoft.com/default.aspx?scid=kb;en-us;317746&Product=sql2k
>
>http://support.microsoft.com/default.aspx?scid=kb;en-

us;295772&Product=sql2k

>Have you already followed the advice in these kb's?
>
[quoted text clipped - 15 lines]
>
>.

Reply to this Message

John Kane - 22 Jul 2004 01:54 GMT

Steve,
The primary error is "URL is excluded because the URL protocol is not
recognized or restricted", and a quick search on Google turned up:

"Troubleshooting and Checking Protocol Handler Performance" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spssdk/html/_tr
oubleshooting_and_checking_protocol_handler_performance.asp

Problem:
Gatherer log error "URL is excluded because the URL protocol is not
recognized or restricted"

Solution:
Protocol handler registration may have failed. Run regedit to look at
HKLM\Software\Microsoft\Search\1.0\ProtocolHandlers or the DllRegisterServer
function.

Does this server have both SQL Server and SharePoint installed on it? Is
this an upgrade from SPPS to SQL Server from WSS?

Regards,
John

> Here are the warnings
>
[quoted text clipped - 69 lines]
> >
> >.

Reply to this Message

Hilary Cotter - 25 Jul 2004 22:27 GMT

can you try to regregister the various SQL FTS components?

Here is a script to do this:

save this to a batch file and run it from a command window:

cd "C:\Program Files\Common Files\System\MSSearch\Bin\"
%windir%\system32\Regsvr32 mssadmin.dll
%windir%\system32\Regsvr32 mssmmcsi.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 %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 book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> Steve,
> The primary error is "URL is excluded because the URL protocol is not
> recognized or restricted", and a quick search on Google turned up:
>
> "Troubleshooting and Checking Protocol Handler Performance" at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spssdk/html/_tr
oubleshooting_and_checking_protocol_handler_performance.asp

> Problem:
> Gatherer log error "URL is excluded because the URL protocol is not
[quoted text clipped - 84 lines]
> > >
> > >.

Reply to this Message