Monday, March 26, 2012

MSSearch Gatherer Error: c0000005 on SQL2K SP3

Please, help me to troubleshoot MSSearch Gatherer error.
I am running SQL2k SP3 on Windows 2k DC and trying to setup full-text index using Enterprise Manager Console, everything goes fine until I am trying to start full population.

In the eventlog I got the following errors:

Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3035
Description:
One or more warnings or errors for Gatherer project <SQLServer SQL0000900005> were logged to file <d:\sqldata\FTData\SQLServer\GatherLogs\SQL00009000 05.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).

Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3036
Description:
The crawl seed <MSSQL75://SQLServer/78bedcc2> in project <SQLServer SQL0000900005> cannot be accessed. Error: c0000005 - A description for this error could not be found.

After that process I got ItemCount -2
using SELECT fulltextcatalogproperty('TestCatalog', 'ItemCount')

Services (SQL and MSSearch) running under LocalSystem Account and have correct BUILTIN\Administrators with all privileges.

Any idea?did u recently change the account on which mssqlserver runs?
check the following thread:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
http://www.dbforums.com/archives/t141995.html|||I tried to change and re-change SQL Server account using EM Console, also I reinstall sp3, but i got the same error message. Nothing helped. I checked
Gatherer Log and got the same errors.

10.03.2004 14:52:06 Add The gatherer has started
10.03.2004 14:52:06 Add The initialization has completed
10.03.2004 14:52:16 Add Started Full crawl
10.03.2004 14:52:16 Add Started Full crawl
10.03.2004 14:52:20 MSSQL75://SQLServer/267aba7a Add Error fetching URL, (c0000005 - A description for this error could not be found)
10.03.2004 14:52:20 MSSQL75://SQLServer/25869641 Add Error fetching URL, (c0000005 - A description for this error could not be found)
10.03.2004 14:52:20 Add Completed Full crawl
10.03.2004 14:52:20 Add Completed Full crawl

c0000005 - seem to be access_violation ?sql

No comments:

Post a Comment