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
>