Few days back, during my routine check on the main Production Server came across the following.
Event Type: Warning Event Source: Microsoft SearchEvent Category: Gatherer Event ID: 3035
Date: 4/24/2012
Time: 6:02:37 PM
User: N/A
Computer: XXXXXXXX
Description: One or more warnings or errors for Gatherer project <SQLServer SQL0000800008> were logged to file <Z:\MSSQL\GatherLogs\SQL0000800008.13.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).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
|
When I noticed this warning for the first time, it was something to ignore... yes, it was! But, before making decision any warnings or errors on critical servers need to be checked thorougly. so, did I...
I started looking in for more and more details... asking myself!
First of all, Is this really an ERROR to worry or just warning information?
Referring to Event Type these are just informational messages. In our case these are related to the deletes of rows that are not in the SQL table, but are in the FT(Full Text) Catalog during the Incremental Population. There can be instances of these occurring with respect to OS, Sharepoint also.
BTW, how did I come to know that the information was something to do with Full text Population... :O
This is something we HAVE to know!
Ok, I just presented the reason for the message first and then thought of explaining how did I get to know? ;) Continue reading...
Once we know that these are just information; how do we read the errors? Microsoft has provided a utility called Gthrlog.vbs Utility to view Gather Logs.
For more information on the usage of utility one can infer to the below link.
From the utility, I inferred the following: Please note this is only with respect to the error presented above. This clearly shows that there are some objects missing :O but nothing to worry as such :) all is well in the Database.
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.7/7/2009 2:01:48 PM MSSQL75://SQLServer/693a71d5/006CC558 Modify Error fetching URL, (80041201 - The object was not found. )7/7/2009 6:46:40 PM MSSQL75://SQLServer/693a71d5/006046FF Modify Error fetching URL, (80041201 - The object was not found. )7/7/2009 8:12:38 PM MSSQL75://SQLServer/693a71d5/006999C4 Modify Error fetching URL, (80041201 - The object was not found. )
|
Finally, What is"Gatherer" ?
Gatherer component is responsible for scheduling and driving full text index population. Its basically a component provided with SQL Server. It retrieves textual and binary data from database tables, streaming the content to filters for indexing. Now, we may need to understand full text indexing.
So, here we go... One of the best sites I have come across to understand the "Full Text Indexing" in SQL Server. Please do read this.
That is all for now... Please leave your comments and suggestions!
3 comments:
Raj thanks for sharing- suresh
A IEEE project Domain is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project DOmains Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project domains for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities in their respective domains.
Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế
vé máy bay đi Mỹ Vietnam Airline
vé máy bay từ seattle về việt nam
có vé máy bay từ nhật về việt nam không
ve may bay tư duc ve viet nam
đăng ký bay từ canada về Việt Nam
vé máy bay hàn quốc hà nội
danh sách khách sạn cách ly ở tphcm
Chuyến bay cho chuyên gia nước ngoài
Post a Comment