Full Text Search Language Specification

I'm using FTS on on two columns (VARCHAR) of my database. The data is exported from a MySQL database to SQL Server. When populating the database the default language was set to English (or maybe neutral?), although 90% of the records are in Dutch. Now, when I change the FTS language specification to Dutch problems occur when querying the database. When I enter typical Dutch noise words in my query like "van" or "van der" the query does not return any results. When I set it back to Neutral the queries do return results, although a drawback is that I can't query for example plural forms of words. Could this be because, when populating the database, the correct language was not set? If so, is there a way to get the Full Text Index working with Dutch in a correct manner?

Thanks in advance for your replies! Would be great to get this working in Dutch!

Rino:

When I enter typical Dutch noise words in my query like "van" or "van der" the query does not return any results

I think ignoring the noise words is the feature of FTS and we can't manipulate it.

|||

Well, It think it is not really about ignoring the noise words. The are ignored by default, am I right?

To clarify things a bit: When I use the query "Van der Vaart" and the language for the FTS column is set to Dutch it returns no results. When I set the language to Neutral it does return results. Basically all it needs to do is find results for the part of the query that says "Vaart".

ps: We are using the excellent FTS Normalizer from E. Bachtal (http://ewbi.blogs.com/develops/2007/05/normalizing_sql.html) Could that possibly cause the issue described above?

|||

Got it solved...

For some reason if I add the language code in the SQL query it works: "...WHERE CONTAINS(table, @.query, LANGUAGE 1043)..."

Full Text Indexing not Populating

When I start the population it doesn't appear to stop. I don't think it even
starts. What I mean is when I right-click on the table and choose start full
population, I go back to check and the only active choice is to stop the
population. After 24 hours it appears to still be running (or trying to
run). I'm using SQL 2000. I tried to do this on a copy of the same table on
a different server and it works fine. I tried this on a different table (and
different database) on the same server and get the same issue.
Any suggestions?
JayB
JayB,
How many rows are in the FT-enable SQL Server 2000 table? The time for the
"Microsoft Search" (mssearch.exe) service to complete a Full Population is
highly dependent upon the number of rows as well as where you have the FT
Catalog defined. Could you post the output of -- select count(*) from
<your_table> -- as that will give us some idea of how long it should take to
complete.
Also, you should review your server's Application event log for "Microsoft
Search" or MssCi source events, such as the following two events as this
will indicate that the final stage (Master Merge) of a Full Population has
completed.
Event Type: Information
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3018
Date: 9/16/2004
Time: 9:10:32 AM
User: N/A
Computer: JTKWIN2003
Description:
The end of crawl for project <SQLServer$SQL2K SQL0000500007> has been
detected. The Gatherer successfully processed 24 documents totaling 0K. It
failed to filter 0 documents. 0 URLs could not be reached or were denied
access.
and
Event Type: Information
Event Source: MssCi
Event Category: None
Event ID: 4103
Date: 9/16/2004
Time: 9:10:32 AM
User: N/A
Computer: JTKWIN2003
Description:
Master merge has completed on
f:\mssql80\mssql$sql2k\ftdata\sql0000500007\build\ indexer\cifiles.
You can also issue the following SQL metadata query to get the FT Population
status on a per FT Catalog basis:
USE Northwind
GO
SELECT fulltextcatalogproperty('<your_FT_Catalog_name>', 'PopulateStatus')
Regards,
John
"JayB" <jerry280@.yahoo.com> wrote in message
news:Mxi2d.4150$uM5.1342@.news01.roc.ny...
> When I start the population it doesn't appear to stop. I don't think it
even
> starts. What I mean is when I right-click on the table and choose start
full
> population, I go back to check and the only active choice is to stop the
> population. After 24 hours it appears to still be running (or trying to
> run). I'm using SQL 2000. I tried to do this on a copy of the same table
on
> a different server and it works fine. I tried this on a different table
(and
> different database) on the same server and get the same issue.
> Any suggestions?
> --
> JayB
>
|||The record count is 1107. It does the same thing with a table containing 4
rows.
The catalog is defined at C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA
(default).
In event viewer I have the 3018 event ID but not the 4103 event ID.
Using your SQL metadata query it produced a value of 0. I changed it to use
my database and catalog name.
I hope this information is helpful.
JayB
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OmrswgAnEHA.3988@.TK2MSFTNGP10.phx.gbl...
> JayB,
> How many rows are in the FT-enable SQL Server 2000 table? The time for the
> "Microsoft Search" (mssearch.exe) service to complete a Full Population is
> highly dependent upon the number of rows as well as where you have the FT
> Catalog defined. Could you post the output of -- select count(*) from
> <your_table> -- as that will give us some idea of how long it should take
to
> complete.
> Also, you should review your server's Application event log for "Microsoft
> Search" or MssCi source events, such as the following two events as this
> will indicate that the final stage (Master Merge) of a Full Population has
> completed.
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3018
> Date: 9/16/2004
> Time: 9:10:32 AM
> User: N/A
> Computer: JTKWIN2003
> Description:
> The end of crawl for project <SQLServer$SQL2K SQL0000500007> has been
> detected. The Gatherer successfully processed 24 documents totaling 0K. It
> failed to filter 0 documents. 0 URLs could not be reached or were denied
> access.
> and
> Event Type: Information
> Event Source: MssCi
> Event Category: None
> Event ID: 4103
> Date: 9/16/2004
> Time: 9:10:32 AM
> User: N/A
> Computer: JTKWIN2003
> Description:
> Master merge has completed on
> f:\mssql80\mssql$sql2k\ftdata\sql0000500007\build\ indexer\cifiles.
> You can also issue the following SQL metadata query to get the FT
Population
> status on a per FT Catalog basis:
> USE Northwind
> GO
> SELECT fulltextcatalogproperty('<your_FT_Catalog_name>', 'PopulateStatus')
> Regards,
> John
>
>
>
> "JayB" <jerry280@.yahoo.com> wrote in message
> news:Mxi2d.4150$uM5.1342@.news01.roc.ny...
> even
> full
> on
> (and
>
|||After stopping and restarting the population I looked at the event viewer
and have one event ID of 3019 indicating that the crawl has started. That
was at 12:06pm. It is now 12:20pm. There are no other messages related to
this population.
JayB
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OmrswgAnEHA.3988@.TK2MSFTNGP10.phx.gbl...
> JayB,
> How many rows are in the FT-enable SQL Server 2000 table? The time for the
> "Microsoft Search" (mssearch.exe) service to complete a Full Population is
> highly dependent upon the number of rows as well as where you have the FT
> Catalog defined. Could you post the output of -- select count(*) from
> <your_table> -- as that will give us some idea of how long it should take
to
> complete.
> Also, you should review your server's Application event log for "Microsoft
> Search" or MssCi source events, such as the following two events as this
> will indicate that the final stage (Master Merge) of a Full Population has
> completed.
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3018
> Date: 9/16/2004
> Time: 9:10:32 AM
> User: N/A
> Computer: JTKWIN2003
> Description:
> The end of crawl for project <SQLServer$SQL2K SQL0000500007> has been
> detected. The Gatherer successfully processed 24 documents totaling 0K. It
> failed to filter 0 documents. 0 URLs could not be reached or were denied
> access.
> and
> Event Type: Information
> Event Source: MssCi
> Event Category: None
> Event ID: 4103
> Date: 9/16/2004
> Time: 9:10:32 AM
> User: N/A
> Computer: JTKWIN2003
> Description:
> Master merge has completed on
> f:\mssql80\mssql$sql2k\ftdata\sql0000500007\build\ indexer\cifiles.
> You can also issue the following SQL metadata query to get the FT
Population
> status on a per FT Catalog basis:
> USE Northwind
> GO
> SELECT fulltextcatalogproperty('<your_FT_Catalog_name>', 'PopulateStatus')
> Regards,
> John
>
>
>
> "JayB" <jerry280@.yahoo.com> wrote in message
> news:Mxi2d.4150$uM5.1342@.news01.roc.ny...
> even
> full
> on
> (and
>
|||You're welcome, JayB,
Have you or anyone else changed the MSSQLServer service startup account &/or
password via Win2K's components service? Also, does the SQL Server login
BUILTIN\Administrator exist on this server with all of it's normal defaults:
master database, SysAdmin rights? Depending upon your answers, you should
review the following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default...b;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
If the BUILTIN\Administrator account was removed for security reasons, you
can use the following SQL code to get FTS to work without it:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Regards,
John
"JayB" <jerry280@.yahoo.com> wrote in message
news:7Yj2d.4154$wK5.3659@.news01.roc.ny...[vbcol=seagreen]
> After stopping and restarting the population I looked at the event viewer
> and have one event ID of 3019 indicating that the crawl has started. That
> was at 12:06pm. It is now 12:20pm. There are no other messages related to
> this population.
> --
> JayB
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:OmrswgAnEHA.3988@.TK2MSFTNGP10.phx.gbl...
the[vbcol=seagreen]
is[vbcol=seagreen]
FT[vbcol=seagreen]
take[vbcol=seagreen]
> to
"Microsoft[vbcol=seagreen]
this[vbcol=seagreen]
has[vbcol=seagreen]
It[vbcol=seagreen]
> Population
'PopulateStatus')[vbcol=seagreen]
it[vbcol=seagreen]
start[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
table[vbcol=seagreen]
table
>
|||Thanks John,
We haven't changed the startup account and we made sure that the
BUILTIN\Administrator exists. I'll take a look at the suggested articles you
included.
Thanks again!
JayB
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eKJ1mOBnEHA.3868@.TK2MSFTNGP11.phx.gbl...
> You're welcome, JayB,
> Have you or anyone else changed the MSSQLServer service startup account
&/or
> password via Win2K's components service? Also, does the SQL Server login
> BUILTIN\Administrator exist on this server with all of it's normal
defaults:
> master database, SysAdmin rights? Depending upon your answers, you should
> review the following KB articles:
> 317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate
Catalogs
> http://support.microsoft.com/default...b;en-us;317746
> 277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K
Component[vbcol=seagreen]
> Services]
> http://support.microsoft.com/default...B;EN-US;277549
> If the BUILTIN\Administrator account was removed for security reasons, you
> can use the following SQL code to get FTS to work without it:
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System','us_english'
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> Regards,
> John
>
> "JayB" <jerry280@.yahoo.com> wrote in message
> news:7Yj2d.4154$wK5.3659@.news01.roc.ny...
viewer[vbcol=seagreen]
That[vbcol=seagreen]
to[vbcol=seagreen]
> the
Population[vbcol=seagreen]
> is
> FT
> take
> "Microsoft
> this
> has
0K.[vbcol=seagreen]
> It
denied
> 'PopulateStatus')
> it
> start
> the
> to
> table
> table
>

Full text index not populating correctly

Hi
I have a table with 4 columns which are full-text indexed. I have noticed
that certain words are not being indexed and therefore not returned in
searches.
I have also noticed that the position on the word in the column effects
whether it is indexed.
For example:
I need to search a column called "Subtitle" which contains information on
product model numbers. If i search for "KF18W420GB" on a column that
contains "KF18W420GB stainless steel" then nothing is returned. If i change
the value in the database to "KF18W420GB" and repopulate the index then the
search works. Similarly, if i change the value in the database to "another
word KF18W420GB stainless steel" the search also works.
Does anyone know why this is? I am using SQL Server 7 on NT 4 - i am
guessing this is probably the problem and i am attempting to upgrade.
Thanks in advance.
Dan
Dan,
It would depend upon the OS platform wordbreaker, in this case the NT4.0
infosoft.dll. It also depends upon the exact SQL Server 7.0 FTS query
(contains vs. freetext) that you are using. Could you post the exact
CONTAINS* or FREETEXT* FTS query you are using as well as a sample of the
exact text you are expecting to return.
FYI, as you're using NT4.0, you can easily move in the Win2K version of
infosoft.dll as a test. If you want to do this, I have the exact methods on
how to do this.
Regards,
John
"Dan" <dan@.nospamplan9.co.uk> wrote in message
news:O4fDi9amEHA.3372@.TK2MSFTNGP15.phx.gbl...
> Hi
> I have a table with 4 columns which are full-text indexed. I have noticed
> that certain words are not being indexed and therefore not returned in
> searches.
> I have also noticed that the position on the word in the column effects
> whether it is indexed.
> For example:
> I need to search a column called "Subtitle" which contains information on
> product model numbers. If i search for "KF18W420GB" on a column that
> contains "KF18W420GB stainless steel" then nothing is returned. If i
change
> the value in the database to "KF18W420GB" and repopulate the index then
the
> search works. Similarly, if i change the value in the database to "another
> word KF18W420GB stainless steel" the search also works.
> Does anyone know why this is? I am using SQL Server 7 on NT 4 - i am
> guessing this is probably the problem and i am attempting to upgrade.
> Thanks in advance.
> Dan
>
|||Hi
i have tried using CONTAINSTABLE also but the result is the same as the
query below:
SELECT
KEY_TBL.Rank,
FT_TBL.LinkText,
FT_TBL.PageId,
FT_TBL.template
FROM (tblPageContent AS FT_TBL
INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
ON FT_TBL.PageID = KEY_TBL.[KEY])
WHERE FT_TBL.Search !=0 ORDER BY KEY_TBL.RANK DESC
Select @.@.version:
Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 14:18:16
Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows
NT 4.0 (Build 1381: Service Pack 6)
Select @.@.language:
us_english
"John Kane" <jt-kane@.comcast.net> wrote in message
news:e3EU%231bmEHA.3356@.TK2MSFTNGP14.phx.gbl...
> Dan,
> It would depend upon the OS platform wordbreaker, in this case the NT4.0
> infosoft.dll. It also depends upon the exact SQL Server 7.0 FTS query
> (contains vs. freetext) that you are using. Could you post the exact
> CONTAINS* or FREETEXT* FTS query you are using as well as a sample of the
> exact text you are expecting to return.
> FYI, as you're using NT4.0, you can easily move in the Win2K version of
> infosoft.dll as a test. If you want to do this, I have the exact methods
> on
> how to do this.
> Regards,
> John
>
> "Dan" <dan@.nospamplan9.co.uk> wrote in message
> news:O4fDi9amEHA.3372@.TK2MSFTNGP15.phx.gbl...
> change
> the
>
|||Dan,
If you re-write the query and remove the where clause (WHERE FT_TBL.Search
!=0)
SELECT KEY_TBL.Rank, FT_TBL.LinkText, FT_TBL.PageId, FT_TBL.template
FROM tblPageContent AS FT_TBL
INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
ON FT_TBL.PageID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC
does it return any &/or expectant results? If not, then as this is SQL 7.0
on NT4.0, this may be a NT4.0 wordbreaking issue, and unfortunately, I don't
have an NT4.0 installation to test the NT4.0 version of infosoft.dll. In the
row that contains the above search string 'KF18W420GB' is there any other
characters &/or punctuation that is in contact or touching the search
string?
Thanks,
John
"Dan" <dan@.nospamplan9.co.uk> wrote in message
news:eqzVCZemEHA.2616@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi
> i have tried using CONTAINSTABLE also but the result is the same as the
> query below:
> SELECT
> KEY_TBL.Rank,
> FT_TBL.LinkText,
> FT_TBL.PageId,
> FT_TBL.template
> FROM (tblPageContent AS FT_TBL
> INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
> ON FT_TBL.PageID = KEY_TBL.[KEY])
> WHERE FT_TBL.Search !=0 ORDER BY KEY_TBL.RANK DESC
> Select @.@.version:
> Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 14:18:16
> Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows
> NT 4.0 (Build 1381: Service Pack 6)
> Select @.@.language:
> us_english
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:e3EU%231bmEHA.3356@.TK2MSFTNGP14.phx.gbl...
the[vbcol=seagreen]
noticed[vbcol=seagreen]
on
>
|||No, that doesn't make a difference. There is no other words/characters other
than those specified.
I will endevour to upgrade the server.
Thanks
Dan
"John Kane" <jt-kane@.comcast.net> wrote in message
news:uIexBlgmEHA.512@.TK2MSFTNGP10.phx.gbl...
> Dan,
> If you re-write the query and remove the where clause (WHERE FT_TBL.Search
> !=0)
> SELECT KEY_TBL.Rank, FT_TBL.LinkText, FT_TBL.PageId, FT_TBL.template
> FROM tblPageContent AS FT_TBL
> INNER JOIN FREETEXTTABLE(tblPageContent,*,'KF18W420GB') AS KEY_TBL
> ON FT_TBL.PageID = KEY_TBL.[KEY]
> ORDER BY KEY_TBL.RANK DESC
> does it return any &/or expectant results? If not, then as this is SQL 7.0
> on NT4.0, this may be a NT4.0 wordbreaking issue, and unfortunately, I
> don't
> have an NT4.0 installation to test the NT4.0 version of infosoft.dll. In
> the
> row that contains the above search string 'KF18W420GB' is there any other
> characters &/or punctuation that is in contact or touching the search
> string?
> Thanks,
> John
>
>
> "Dan" <dan@.nospamplan9.co.uk> wrote in message
> news:eqzVCZemEHA.2616@.tk2msftngp13.phx.gbl...
> the
> noticed
> on
>

Full Text Index not populating

I have a table with 13,000,000 records. I want to generate a full-text index on one column (a varchar 2000). I am able to define the full-text index, but when I click on "Start Full population", there is virtually no activity (no disk activity, no CPU activity, very little to indicate anything is happening.

When I check the properties of the catalog, it shows 1 MB size and 0 records in the catalog. The status of the catalog is "idle" and the display in EM shows that the last full population occurred at (about) the time that I generated the population request. I have generated the request by using EM (right click on table) and through SQL Agent with the same result (no catalog generated).

I am running SQL 2000 (SP4) on Windows 2000 (SP4) with 4 GB RAM and sufficient disk space available. I have enabled the full-text service and verified that it is running (I have stopped and restarted it as well).

I have worked with Full Text indexes before and never had any kind of issue before. Any thoughts or suggestions would be welcome.

Regards,

hmscott

CREATE TABLE [OMBRE_AUDIT_LOG] (
[LOG_SEQ_NBR] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[APP_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[USER_ID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[USER_ORGANIZATION] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ACTION_START_DATE] [datetime] NOT NULL ,
[ACTION_END_DATE] [datetime] NULL ,
[ACTION_CODE] [int] NOT NULL ,
[VIEW_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[USER_DEF_TRACKING_NBR] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CMD_XML_STREAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[REC_CREATE] [datetime] NULL CONSTRAINT [DF_OMBRE_AUDIT_LOG_REC_CREATE] DEFAULT (getdate()),
[REC_UPDATE] [datetime] NULL ,
[ATTENTION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[REASON] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_OMBRE_AUDIT_LOG] PRIMARY KEY CLUSTERED
(
[LOG_SEQ_NBR]
)
)
GOPoor scott :D ,

Have u checked any errors in Microsoft Windows 2000 Event Viewer application log which related to Microsft Search?

Another hint is ,

Make sure that the BUILTIN\Administrators login exists in SQL Server.|||Poor scott :D ,

I don't want sympathy, I want answers!!! :D

Have u checked any errors in Microsoft Windows 2000 Event Viewer application log which related to Microsft Search?

Ding! Score 1 point for mallier!


Make sure that the BUILTIN\Administrators login exists in SQL Server.
Ding! Ding! We have a winner!

WTF? Best practice says remove the BUILTIN\Administrator account and yet it's required for this!?! I gotta go read up more on Full text.

Thanks for the help!

Regards,

hmscott|||Hi,
I also got the same problem as you Scott.
I found I have the BUILTIN\Administrator in SQL Server.

So what will be the reason?|||To access existing full-text search catalogs, rebuild and repopulate them. The existing catalogs can also be accessed by switching back to an administrator account.|||Hi Satya,

I have the exact problem as Scott, could you give me some idea how to solve the problem please?

Full text catalog just not populating

Hi all,
I spent the best part of the day yesterday scouring this newsgroup,
carrying out the routines that are common with FT not populating
(checking local system account, checking empty HCR reg entries for
empties, making sure local system in sys admin group) but none of them
seemed to solve my problem.
Whenever I try to do a population of my index, it just stops, the
registry contains the errors shown below. I've just spent the best
part of an hour going through my registry making sure (and removing
where found) empty registry keys (yes, proper empty ones, not the (not
set) ones) but that made no difference either.
Here's the result of a SELECT @.@.VERSION
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Could anyone please offer any advice on what to check next, I really
need to get this working but unfortunatley am not in a position where
I can reinstall the whole server again as it's in production.
Any help gratefully appreciated.
Thanks
// Carl
Here are the event log entries as I run the search (top being oldest)
and the result from gathrlog.vbs shown below as well.
Event Type:Information
Event Source:Microsoft Search
Event Category:Gatherer
Event ID:3019
Date:27/10/2004
Time:10:32:18
User:N/A
Computer:NUSDB1
Description:
The crawl on project <SQLServer SQL0000800005> has started.
Event Type:Warning
Event Source:Microsoft Search
Event Category:Gatherer
Event ID:3035
Date:27/10/2004
Time:10:32:18
User:N/A
Computer:NUSDB1
Description:
One or more warnings or errors for Gatherer project <SQLServer
SQL0000800005> were logged to file
<e:\MSSQL\MSSQL\FTData\SQLServer\GatherLogs\SQL000 0800005.2.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 Type:Warning
Event Source:Microsoft Search
Event Category:Gatherer
Event ID:3036
Date:27/10/2004
Time:10:32:18
User:N/A
Computer:NUSDB1
Description:
The crawl seed <MSSQL75://SQLServer/1d864d1d> in project <SQLServer
SQL0000800005> cannot be accessed. Error: 800700e9 - No process is on
the other end of the pipe. .
Event Type:Warning
Event Source:Microsoft Search
Event Category:Gatherer
Event ID:3024
Date:27/10/2004
Time:10:32:18
User:N/A
Computer:NUSDB1
Description:
The crawl for project <SQLServer SQL0000800005> could not be started,
because no crawl seeds could be accessed. Fix the errors and try the
crawl again.
Event Type:Information
Event Source:Microsoft Search
Event Category:Gatherer
Event ID:3018
Date:27/10/2004
Time:10:32:18
User:N/A
Computer:NUSDB1
Description:
The end of crawl for project <SQLServer SQL0000800005> has been
detected. The Gatherer successfully processed 0 documents totaling 0K.
It failed to filter 1 documents. 0 URLs could not be reached or were
denied access.
Event Type:Information
Event Source:Microsoft Search
Event Category:Indexer
Event ID:7045
Date:27/10/2004
Time:10:32:18
User:N/A
Computer:NUSDB1
Description:
The catalog was not propagated, because no new files were detected for
the project <SQLServer SQL0000800005>.
Here is the result of ruinning gathrlog.vbs
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
27/10/2004 09:44:22 Add Started Full crawl
27/10/2004 09:44:26 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 09:44:26 Add Completed Full crawl
27/10/2004 09:57:10 Add Started Incremental crawl
27/10/2004 09:57:10 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 09:57:10 Add Completed Incremental crawl
27/10/2004 09:58:52 Add Started Full crawl
27/10/2004 09:58:54 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 09:58:54 Add Completed Full crawl
27/10/2004 10:02:44 Add Started Full crawl
27/10/2004 10:02:44 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 10:02:44 Add Completed Full crawl
27/10/2004 10:06:54 Add The gatherer has started
27/10/2004 10:06:56 Add The initialization has
completed
27/10/2004 10:06:58 Add Started Full crawl
27/10/2004 10:07:00 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 10:07:00 Add Completed Full crawl
27/10/2004 10:09:02 Add Started Full crawl
27/10/2004 10:09:04 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 10:09:04 Add Completed Full crawl
27/10/2004 10:26:50 Add The gatherer has started
27/10/2004 10:26:52 Add The initialization has
completed
27/10/2004 10:27:08 Add Started Full crawl
27/10/2004 10:27:08 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 10:27:08 Add Completed Full crawl
27/10/2004 10:32:00 Add The gatherer has started
27/10/2004 10:32:00 Add The initialization has
completed
27/10/2004 10:32:20 Add Started Full crawl
27/10/2004 10:32:20 MSSQL75://SQLServer/1d864d1d Add Error
fetching U
RL, (800700e9 - No process is on the other end of the pipe. )
27/10/2004 10:32:20 Add Completed Full crawl
Carl,
First of all, thank you for providing the version (@.@.select) and eventlog
entries as they are both very helpful info in troubleshooting SQL FTS
issues! The primary error is "800700e9 - No process is on the other end of
the pipe." Have you or anyone else changed the MSSQLServer service startup
account &/or password via Win2K's Component Services? If so, please review
this KB article:
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services] at http://support.microsoft.com/default...B;EN-US;277549
Additionally, have you removed or altered the SQL Server login
BUILTIN\Administrators from the problem server? If so, then this most likely
is the source of the failure for FT Populations as the MSSearch services
needs this login to log into SQL Server and you can either add back this
login with the original permissions (default master db, sysadmin privileges
or see KB article: 263712 (Q263712) INF: How to Impede Windows NT
Administrators from Administering a Clustered SQL Server at:
http://support.microsoft.com/default...B;EN-US;263712
If you cannot add back the SQL Server login BUILTIN\Administrators login,
you can use the following SQL code as a substitute:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Regards,
John
"Carl Jones" <belial239@.gmail.com> wrote in message
news:29174ebe.0410270139.33291fef@.posting.google.c om...
> Hi all,
> I spent the best part of the day yesterday scouring this newsgroup,
> carrying out the routines that are common with FT not populating
> (checking local system account, checking empty HCR reg entries for
> empties, making sure local system in sys admin group) but none of them
> seemed to solve my problem.
> Whenever I try to do a population of my index, it just stops, the
> registry contains the errors shown below. I've just spent the best
> part of an hour going through my registry making sure (and removing
> where found) empty registry keys (yes, proper empty ones, not the (not
> set) ones) but that made no difference either.
> Here's the result of a SELECT @.@.VERSION
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
> 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> Could anyone please offer any advice on what to check next, I really
> need to get this working but unfortunatley am not in a position where
> I can reinstall the whole server again as it's in production.
> Any help gratefully appreciated.
> Thanks
> // Carl
> Here are the event log entries as I run the search (top being oldest)
> and the result from gathrlog.vbs shown below as well.
>
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3019
> Date: 27/10/2004
> Time: 10:32:18
> User: N/A
> Computer: NUSDB1
> Description:
> The crawl on project <SQLServer SQL0000800005> has started.
>
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3035
> Date: 27/10/2004
> Time: 10:32:18
> User: N/A
> Computer: NUSDB1
> Description:
> One or more warnings or errors for Gatherer project <SQLServer
> SQL0000800005> were logged to file
> <e:\MSSQL\MSSQL\FTData\SQLServer\GatherLogs\SQL000 0800005.2.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 Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3036
> Date: 27/10/2004
> Time: 10:32:18
> User: N/A
> Computer: NUSDB1
> Description:
> The crawl seed <MSSQL75://SQLServer/1d864d1d> in project <SQLServer
> SQL0000800005> cannot be accessed. Error: 800700e9 - No process is on
> the other end of the pipe. .
>
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3024
> Date: 27/10/2004
> Time: 10:32:18
> User: N/A
> Computer: NUSDB1
> Description:
> The crawl for project <SQLServer SQL0000800005> could not be started,
> because no crawl seeds could be accessed. Fix the errors and try the
> crawl again.
>
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3018
> Date: 27/10/2004
> Time: 10:32:18
> User: N/A
> Computer: NUSDB1
> Description:
> The end of crawl for project <SQLServer SQL0000800005> has been
> detected. The Gatherer successfully processed 0 documents totaling 0K.
> It failed to filter 1 documents. 0 URLs could not be reached or were
> denied access.
> Event Type: Information
> Event Source: Microsoft Search
> Event Category: Indexer
> Event ID: 7045
> Date: 27/10/2004
> Time: 10:32:18
> User: N/A
> Computer: NUSDB1
> Description:
> The catalog was not propagated, because no new files were detected for
> the project <SQLServer SQL0000800005>.
>
> Here is the result of ruinning gathrlog.vbs
>
> Microsoft (R) Windows Script Host Version 5.6
> Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
> 27/10/2004 09:44:22 Add Started Full crawl
> 27/10/2004 09:44:26 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 09:44:26 Add Completed Full crawl
> 27/10/2004 09:57:10 Add Started Incremental crawl
> 27/10/2004 09:57:10 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 09:57:10 Add Completed Incremental crawl
> 27/10/2004 09:58:52 Add Started Full crawl
> 27/10/2004 09:58:54 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 09:58:54 Add Completed Full crawl
> 27/10/2004 10:02:44 Add Started Full crawl
> 27/10/2004 10:02:44 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 10:02:44 Add Completed Full crawl
> 27/10/2004 10:06:54 Add The gatherer has started
> 27/10/2004 10:06:56 Add The initialization has
> completed
> 27/10/2004 10:06:58 Add Started Full crawl
> 27/10/2004 10:07:00 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 10:07:00 Add Completed Full crawl
> 27/10/2004 10:09:02 Add Started Full crawl
> 27/10/2004 10:09:04 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 10:09:04 Add Completed Full crawl
> 27/10/2004 10:26:50 Add The gatherer has started
> 27/10/2004 10:26:52 Add The initialization has
> completed
> 27/10/2004 10:27:08 Add Started Full crawl
> 27/10/2004 10:27:08 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 10:27:08 Add Completed Full crawl
> 27/10/2004 10:32:00 Add The gatherer has started
> 27/10/2004 10:32:00 Add The initialization has
> completed
> 27/10/2004 10:32:20 Add Started Full crawl
> 27/10/2004 10:32:20 MSSQL75://SQLServer/1d864d1d Add Error
> fetching U
> RL, (800700e9 - No process is on the other end of the pipe. )
> 27/10/2004 10:32:20 Add Completed Full crawl
|||John, very quick question if I may.
I've seen a few posts where you've said:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
My question is, is there any way at all to run FTI without either the
Builtin of Nt authority accounts as sysadmin? It just strikes me as odd that
what is essentially a data read requires such high level permissions. It
means either the network guys in my company who don't know SQL but are admins
of the box becomes SQL admins, or the other services on the box can in theory
gain admin rights. Are there no registry keys, OS permissions or anything
else which can get this working without SA permissions? We try to secure
boxes as much as we can at the server and OS level and then do the same
within SQL. We've build policies specifically so that the domain account
running sql isn't an admin on its box, so ideally we'd avoid giving out sql
admin rights.
Thanks
"John Kane" wrote:

> Carl,
> First of all, thank you for providing the version (@.@.select) and eventlog
> entries as they are both very helpful info in troubleshooting SQL FTS
> issues! The primary error is "800700e9 - No process is on the other end of
> the pipe." Have you or anyone else changed the MSSQLServer service startup
> account &/or password via Win2K's Component Services? If so, please review
> this KB article:
> 277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
> MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
> Services] at http://support.microsoft.com/default...B;EN-US;277549
> Additionally, have you removed or altered the SQL Server login
> BUILTIN\Administrators from the problem server? If so, then this most likely
> is the source of the failure for FT Populations as the MSSearch services
> needs this login to log into SQL Server and you can either add back this
> login with the original permissions (default master db, sysadmin privileges
> or see KB article: 263712 (Q263712) INF: How to Impede Windows NT
> Administrators from Administering a Clustered SQL Server at:
> http://support.microsoft.com/default...B;EN-US;263712
> If you cannot add back the SQL Server login BUILTIN\Administrators login,
> you can use the following SQL code as a substitute:
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System','us_english'
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> Regards,
> John
>
>
> "Carl Jones" <belial239@.gmail.com> wrote in message
> news:29174ebe.0410270139.33291fef@.posting.google.c om...
>
>

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jjTry executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Co
mponent
Services]
http://support.microsoft.com/defaul...KB;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/defaul...kb;en-us;317746
HTH
Francis
"jj" wrote:

> I just created a full text index on a table and everything appears fine b
ut
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jjTry executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
HTH
Francis
"jj" wrote:
> I just created a full text index on a table and everything appears fine but
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jj
Try executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/default...b;en-us;317746
HTH
Francis
"jj" wrote:

> I just created a full text index on a table and everything appears fine but
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>