Monday, March 26, 2012
MSSearch Gatherer Error: c0000005 on SQL2K SP3
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
MSRT - Error with Exporting the Reports to Excel Format.
Server Error in '/Reports' Application.
Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Exception: Index was outside the bounds of the array.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[Exception: Index was outside the bounds of the array.][Exception: An error occurred during rendering of the report.]
[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +924
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Santhosh
Santosh,
Do you get this for all reports or just for one particular report. If it is for one particular report next thing is do you know if it is for a particular field?
|||Im getting just this particular report and in the pre prod the same report is working fine only in production Im having this issue. That too it works fine on one day and breaks on the next day