Hi all,
I have multiple full-text catalogs on about 8 tables (sql server 2005 ee -
all varchar(max)).
A few days ago, they all went to an idle status and won't start picking up
any new changes - all catalogs are auto update.
when i say 'idle' - mean :
objectpropertyex ( [table object_id] , 'TableFulltextPopulateStatus' ) = 0
objectpropertyex ( [catalog_id] , PopulateStatus) = 0
and
objectpropertyex ( table object_id , 'TableFulltextItemCount' ) shows that
there are many rows missing from the table so there is much work to be done.
i have seen this once before and ended up doing a rebuild but I hope to
avoid that this time around as it takes several days to rebuild all catalogs.
Has anyone seen anything similar to this or have any suggestions for the
full-text catalog to start 'picking back up' the auto changes?
Many thanks,
Robert Towne
check the full text logs, they can be found in C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\LOG and will look like SQLFT0005600015.log
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sql411@.nospam.com" <sql411nospamcom@.discussions.microsoft.com> wrote in
message news:D77BD52A-7107-4284-8522-60E95C45E15E@.microsoft.com...
> Hi all,
> I have multiple full-text catalogs on about 8 tables (sql server 2005 ee -
> all varchar(max)).
> A few days ago, they all went to an idle status and won't start picking up
> any new changes - all catalogs are auto update.
> when i say 'idle' - mean :
> objectpropertyex ( [table object_id] , 'TableFulltextPopulateStatus' ) = 0
> objectpropertyex ( [catalog_id] , PopulateStatus) = 0
> and
> objectpropertyex ( table object_id , 'TableFulltextItemCount' ) shows that
> there are many rows missing from the table so there is much work to be
> done.
> i have seen this once before and ended up doing a rebuild but I hope to
> avoid that this time around as it takes several days to rebuild all
> catalogs.
> Has anyone seen anything similar to this or have any suggestions for the
> full-text catalog to start 'picking back up' the auto changes?
> Many thanks,
> Robert Towne
|||Thanks, Hilary. I checked the logs initially and only saw a pause (from
backup) and resume (backup finished). it was weird because it happened
across all full-text catalogs - i could still do a contains search but they
just were idle as far as adding new records.
I did a reboot and that cleared it up. (I was hoping to avoid the reboot as
we are always doing business and it is difficult to get a maintenance period).
Thanks again,
robert
Showing posts with label catalog. Show all posts
Showing posts with label catalog. Show all posts
Monday, March 19, 2012
Wednesday, March 7, 2012
New installation - Catalog does not get popuated
I am tearing my hair out here!
I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL
Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and everything
seemed to go fine until I tried to populate it. It seems to get stuck in
populate mode, and the only errors that I can see are in the event log as
below.
I have looked at various postings on the subject, and the only one that I
can see is relevant is the one about SQL server running under a different
account to the LocalSystem, which it was. I corrected this via Enterprise
manager, re-started SQL Server, then re-started Microsoft Search/Full-text
Search, but still it does not populate!
The event log errors are:
One or more warnings or errors for Gatherer project <SQLServer
SQL0001800005> were logged to file <C:\Program Files\Microsoft SQL
Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000180 0005.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).
Followed by:
The crawl seed <MSSQL75://SQLServer/64d0200a> in project <SQLServer
SQL0001800005> cannot be accessed. Error: 800700e9 - No process is on the
other end of the pipe. .
Any ideas?
Cheers, Mike.
SQL FTS uses named pipes to communicate with MSSearch.
The error message you are getting is most often related to security, such as
changing the SQL Server service account through control panel rather than
Enterprise Manager.
Can you confirm, that 1) a stopping and starting of MSSearch, SQL Server,
and even a reboot does not solve this problem. I can be resource related. 2)
secondly verify that the BuiltIn Administrators group is in your security
folder and is a system administrator.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> I am tearing my hair out here!
> I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL
> Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and
everything
> seemed to go fine until I tried to populate it. It seems to get stuck in
> populate mode, and the only errors that I can see are in the event log as
> below.
> I have looked at various postings on the subject, and the only one that I
> can see is relevant is the one about SQL server running under a different
> account to the LocalSystem, which it was. I corrected this via Enterprise
> manager, re-started SQL Server, then re-started Microsoft Search/Full-text
> Search, but still it does not populate!
> The event log errors are:
> One or more warnings or errors for Gatherer project <SQLServer
> SQL0001800005> were logged to file <C:\Program Files\Microsoft SQL
> Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000180 0005.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).
> Followed by:
> The crawl seed <MSSQL75://SQLServer/64d0200a> in project <SQLServer
> SQL0001800005> cannot be accessed. Error: 800700e9 - No process is on the
> other end of the pipe. .
> Any ideas?
>
> Cheers, Mike.
|||Mike,
Yes, I have an idea and thank you for providing the version (@.@.select) and
eventlog error 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.". This error is often caused by removing or altering the SQL Server
login BUILTIN\Administrators and it most likely is the source of this
problem for you. This most likely is the source of the failure for FT
Populations as the MSSearch service 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
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> I am tearing my hair out here!
> I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL
> Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and
everything
> seemed to go fine until I tried to populate it. It seems to get stuck in
> populate mode, and the only errors that I can see are in the event log as
> below.
> I have looked at various postings on the subject, and the only one that I
> can see is relevant is the one about SQL server running under a different
> account to the LocalSystem, which it was. I corrected this via Enterprise
> manager, re-started SQL Server, then re-started Microsoft Search/Full-text
> Search, but still it does not populate!
> The event log errors are:
> One or more warnings or errors for Gatherer project <SQLServer
> SQL0001800005> were logged to file <C:\Program Files\Microsoft SQL
> Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000180 0005.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).
> Followed by:
> The crawl seed <MSSQL75://SQLServer/64d0200a> in project <SQLServer
> SQL0001800005> cannot be accessed. Error: 800700e9 - No process is on the
> other end of the pipe. .
> Any ideas?
>
> Cheers, Mike.
|||Thanks Hilary, I had previously checked to see what permissions the
BUILTIN\Administrators user(s) had on all the DB's, which was db_owner, but I
didn't check it's 'Server Roles' - It had no server roles, and as soon as I
gave it System Administrators Role eveything started working!
Thanks for your help, Mike.
"Hilary Cotter" wrote:
> SQL FTS uses named pipes to communicate with MSSearch.
> The error message you are getting is most often related to security, such as
> changing the SQL Server service account through control panel rather than
> Enterprise Manager.
> Can you confirm, that 1) a stopping and starting of MSSearch, SQL Server,
> and even a reboot does not solve this problem. I can be resource related. 2)
> secondly verify that the BuiltIn Administrators group is in your security
> folder and is a system administrator.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
> news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> everything
> log
>
>
|||Thanks for replying John.
I worked through Hilary's answer first (as it was posted first), which I
think was similar to yours, and added BUILTIN\Administrators to the 'System
Administrators' Role, and it all started working.
Cheers, Mike.
"John Kane" wrote:
> Mike,
> Yes, I have an idea and thank you for providing the version (@.@.select) and
> eventlog error 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.". This error is often caused by removing or altering the SQL Server
> login BUILTIN\Administrators and it most likely is the source of this
> problem for you. This most likely is the source of the failure for FT
> Populations as the MSSearch service 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
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
> news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> everything
> log
>
>
I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL
Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and everything
seemed to go fine until I tried to populate it. It seems to get stuck in
populate mode, and the only errors that I can see are in the event log as
below.
I have looked at various postings on the subject, and the only one that I
can see is relevant is the one about SQL server running under a different
account to the LocalSystem, which it was. I corrected this via Enterprise
manager, re-started SQL Server, then re-started Microsoft Search/Full-text
Search, but still it does not populate!
The event log errors are:
One or more warnings or errors for Gatherer project <SQLServer
SQL0001800005> were logged to file <C:\Program Files\Microsoft SQL
Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000180 0005.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).
Followed by:
The crawl seed <MSSQL75://SQLServer/64d0200a> in project <SQLServer
SQL0001800005> cannot be accessed. Error: 800700e9 - No process is on the
other end of the pipe. .
Any ideas?
Cheers, Mike.
SQL FTS uses named pipes to communicate with MSSearch.
The error message you are getting is most often related to security, such as
changing the SQL Server service account through control panel rather than
Enterprise Manager.
Can you confirm, that 1) a stopping and starting of MSSearch, SQL Server,
and even a reboot does not solve this problem. I can be resource related. 2)
secondly verify that the BuiltIn Administrators group is in your security
folder and is a system administrator.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> I am tearing my hair out here!
> I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL
> Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and
everything
> seemed to go fine until I tried to populate it. It seems to get stuck in
> populate mode, and the only errors that I can see are in the event log as
> below.
> I have looked at various postings on the subject, and the only one that I
> can see is relevant is the one about SQL server running under a different
> account to the LocalSystem, which it was. I corrected this via Enterprise
> manager, re-started SQL Server, then re-started Microsoft Search/Full-text
> Search, but still it does not populate!
> The event log errors are:
> One or more warnings or errors for Gatherer project <SQLServer
> SQL0001800005> were logged to file <C:\Program Files\Microsoft SQL
> Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000180 0005.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).
> Followed by:
> The crawl seed <MSSQL75://SQLServer/64d0200a> in project <SQLServer
> SQL0001800005> cannot be accessed. Error: 800700e9 - No process is on the
> other end of the pipe. .
> Any ideas?
>
> Cheers, Mike.
|||Mike,
Yes, I have an idea and thank you for providing the version (@.@.select) and
eventlog error 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.". This error is often caused by removing or altering the SQL Server
login BUILTIN\Administrators and it most likely is the source of this
problem for you. This most likely is the source of the failure for FT
Populations as the MSSearch service 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
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> I am tearing my hair out here!
> I have set up a full text catlog on an SQL 2000 Server ( Microsoft SQL
> Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ), and
everything
> seemed to go fine until I tried to populate it. It seems to get stuck in
> populate mode, and the only errors that I can see are in the event log as
> below.
> I have looked at various postings on the subject, and the only one that I
> can see is relevant is the one about SQL server running under a different
> account to the LocalSystem, which it was. I corrected this via Enterprise
> manager, re-started SQL Server, then re-started Microsoft Search/Full-text
> Search, but still it does not populate!
> The event log errors are:
> One or more warnings or errors for Gatherer project <SQLServer
> SQL0001800005> were logged to file <C:\Program Files\Microsoft SQL
> Server\MSSQL\FTData\SQLServer\GatherLogs\SQL000180 0005.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).
> Followed by:
> The crawl seed <MSSQL75://SQLServer/64d0200a> in project <SQLServer
> SQL0001800005> cannot be accessed. Error: 800700e9 - No process is on the
> other end of the pipe. .
> Any ideas?
>
> Cheers, Mike.
|||Thanks Hilary, I had previously checked to see what permissions the
BUILTIN\Administrators user(s) had on all the DB's, which was db_owner, but I
didn't check it's 'Server Roles' - It had no server roles, and as soon as I
gave it System Administrators Role eveything started working!
Thanks for your help, Mike.
"Hilary Cotter" wrote:
> SQL FTS uses named pipes to communicate with MSSearch.
> The error message you are getting is most often related to security, such as
> changing the SQL Server service account through control panel rather than
> Enterprise Manager.
> Can you confirm, that 1) a stopping and starting of MSSearch, SQL Server,
> and even a reboot does not solve this problem. I can be resource related. 2)
> secondly verify that the BuiltIn Administrators group is in your security
> folder and is a system administrator.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
> news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> everything
> log
>
>
|||Thanks for replying John.
I worked through Hilary's answer first (as it was posted first), which I
think was similar to yours, and added BUILTIN\Administrators to the 'System
Administrators' Role, and it all started working.
Cheers, Mike.
"John Kane" wrote:
> Mike,
> Yes, I have an idea and thank you for providing the version (@.@.select) and
> eventlog error 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.". This error is often caused by removing or altering the SQL Server
> login BUILTIN\Administrators and it most likely is the source of this
> problem for you. This most likely is the source of the failure for FT
> Populations as the MSSearch service 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
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Mike Owen" <MikeOwen@.discussions.microsoft.com> wrote in message
> news:F1FF6F58-C7D3-4DC8-913B-9EB244CE6B5F@.microsoft.com...
> everything
> log
>
>
new index, catalog empty
I have created a FT Index on a varchar(200) col of my 'movies' table.
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.
(item count 0, unique key count 1, etc..)
Any ideas ?
Any error messages in the event log from MSSearch or MSSCI?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I have created a FT Index on a varchar(200) col of my 'movies' table.
> The table has about 2000 rows, so there is lots to index.
> But even after forcing a catalog rebuild and full population, the catalog
> remains empty.
> (item count 0, unique key count 1, etc..)
> Any ideas ?
>
>
|||sql server general "ERRORLOG" (all caps, no file extension)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Any error messages in the event log from MSSearch or MSSCI?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Tony B." <Test@.spam.ca> wrote in message
> news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||I assume you are telling me the contents of the log directory. I want you to
look in the application log. At a command prompt type eventvwr, hit enter,
and drill down on application log. Look for messages from mssci, or mssearch
and post them back here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:%23aOiEMnDHHA.3212@.TK2MSFTNGP04.phx.gbl...
> sql server general "ERRORLOG" (all caps, no file extension)
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.
(item count 0, unique key count 1, etc..)
Any ideas ?
Any error messages in the event log from MSSearch or MSSCI?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>I have created a FT Index on a varchar(200) col of my 'movies' table.
> The table has about 2000 rows, so there is lots to index.
> But even after forcing a catalog rebuild and full population, the catalog
> remains empty.
> (item count 0, unique key count 1, etc..)
> Any ideas ?
>
>
|||sql server general "ERRORLOG" (all caps, no file extension)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
> Any error messages in the event log from MSSearch or MSSCI?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Tony B." <Test@.spam.ca> wrote in message
> news:ei$gfyYDHHA.3524@.TK2MSFTNGP06.phx.gbl...
>
|||I assume you are telling me the contents of the log directory. I want you to
look in the application log. At a command prompt type eventvwr, hit enter,
and drill down on application log. Look for messages from mssci, or mssearch
and post them back here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tony B." <Test@.spam.ca> wrote in message
news:%23aOiEMnDHHA.3212@.TK2MSFTNGP04.phx.gbl...
> sql server general "ERRORLOG" (all caps, no file extension)
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OIP0J9jDHHA.3228@.TK2MSFTNGP03.phx.gbl...
>
Subscribe to:
Posts (Atom)