Re: 'update index in background' not running.
- From: "John Mott" <johnmott59@xxxxxxxxxxx>
- Date: Fri, 28 Oct 2005 09:56:51 -0500
Thanks John,
the results of the queries were:
'TableHasActiveFulltextIndex' = 1
'TableFullTextBackgroundUpdateIndexOn = 1
'TableFullTextChangeTrackingOn' = 1
'UniqueKeyCount' = 109132
'itemcount' = 43844
'indexsize' = 60
I think I know what this might be related to, but i'm not sure how to change
it. From an earlier version of this database i learned that in Windows 2003
in order to allow an .net web program to access the SQL server you have to
add IIS_WPG account to the database, there apparantly isn't an account
called 'system' anymore.
I think the failure began when I added this account to the database; it had
been running for a day or so just fine. So, there must be an interaction
between IIS_WPG and this. I had tried to reproduce the setup for dbo for
this account, but i'm very weak on SQL server administration so its quite
likely that there is something missing. I went through and added privileges
wherever i could find them.
Yesterday I started an incremental build thats still running to try to catch
up. will the update index work while a build is taking place?
There are no error messages in the event logs or reports of an inability to
access any resources.
I wish the client could find an expert in this area; i'm very weak on SQL
DBA and wish I could just focus on the software development. Everyone is
either too busy or doesn't have the necessary depth..
john
"John Kane" <jt-kane@xxxxxxxxxxx> wrote in message
news:%237yZRV42FHA.320@xxxxxxxxxxxxxxxxxxxxxxx
> John,
> First you should review the server's "Microsoft Search" and MssCi source
> events (informational, warnings & errors), as it is only in the
Application
> event log that SQL Server 2000 FT Indexing success & failures are
recorded.
> Secondly, could you execute the following SQL code and post the output?
>
> use <your_database_name>
> go
> SELECT OBJECTPROPERTY
> (object_id('<table_name>'),'TableHasActiveFulltextIndex')
> SELECT OBJECTPROPERTY
> (object_id('<table_name>'),'TableFullTextBackgroundUpdateIndexOn')
> SELECT OBJECTPROPERTY
> (object_id('<table_name>'),'TableFullTextChangeTrackingOn')
> go
> select FulltextCatalogProperty('<FT_Catalog>', 'UniqueKeyCount')
> select FullTextCatalogProperty('<FT_Catalog>', 'itemcount')
> select FullTextCatalogProperty('<FT_Catalog>', 'indexsize')
>
> 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.aspx?scid=kb;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.aspx?scid=KB;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
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
>
> "John Mott" <johnmott59@xxxxxxxxxxx> wrote in message
> news:eHI51vy2FHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> > this is a new windows 2003 server/sql server 2000 set up (2-3 days old).
> > full text is set up and working and definetely added data, andi have
> > update
> > index in background set.
> >
> > It seems to have worked for a while, then stopped. The application event
> > log
> > records events for Microsoft Search as 'Search service has started',
> > 'Search
> > service has loaded project ...' and 'indexer started successfully for
> > project..' from yesterday afternoon, about the time that it stopped
> > adding
> > articles.
> >
> > There is only one catalog and one table with two fields that are
indexed.
> >
> > since there is data in there it seems to have stopped in the last day or
> > so.
> > the system is lightly loaded, nothign else going on, and i can see
> > mssearch.exe in the task list.
> >
> > where can i look to see why its not loading?
> >
> > thanks,
> >
> > john
> >
> >
> >
>
>
.
- Follow-Ups:
- Re: 'update index in background' not running.
- From: John Kane
- Re: 'update index in background' not running.
- References:
- 'update index in background' not running.
- From: John Mott
- Re: 'update index in background' not running.
- From: John Kane
- 'update index in background' not running.
- Prev by Date: Re: 'update index in background' not running.
- Next by Date: Re: Batch Size
- Previous by thread: Re: 'update index in background' not running.
- Next by thread: Re: 'update index in background' not running.
- Index(es):
Relevant Pages
|
