Full Text Indexing Limitations

Can anyone confirm for me that full text indexing will flake out once
reaching around 256 folders in the MSSQL\FTDATA directory? I've had a
larger number in this folder on a constant basis over the last year and have
had an occasional problem with the error of "
update sysobjects set ftcatid = 0 where ftcatid <> 0" along with other
errors when moving DBs to and from my staging servers.
I developed a script a couple of years ago that got me to the point where I
could delete and re-create these indexes when necessary and since they work
pretty regularly with my 500+, 1000+ folders in this directory I find it
hard to believe that 256 is the limit and was wondering what other
experiences there are out there.
Yes, I've tried probably every fix including manually reinstalling Full
Text, checking permissions, etc etc from MSDN articles out there so no need
to send them my way. I'm just asking for experiences here before calling
PSS.
Thanks.
Adam P. Cassidy
can you define what you mean by flake out?
Ideally you will have as few catalogs as possible. I'll try to repro this.
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
"Adam Patrick Cassidy" <apcassidy@.aol.com> wrote in message
news:eIkMKERKHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Can anyone confirm for me that full text indexing will flake out once
> reaching around 256 folders in the MSSQL\FTDATA directory? I've had a
> larger number in this folder on a constant basis over the last year and
> have had an occasional problem with the error of "
> update sysobjects set ftcatid = 0 where ftcatid <> 0" along with other
> errors when moving DBs to and from my staging servers.
> I developed a script a couple of years ago that got me to the point where
> I could delete and re-create these indexes when necessary and since they
> work pretty regularly with my 500+, 1000+ folders in this directory I find
> it hard to believe that 256 is the limit and was wondering what other
> experiences there are out there.
> Yes, I've tried probably every fix including manually reinstalling Full
> Text, checking permissions, etc etc from MSDN articles out there so no
> need to send them my way. I'm just asking for experiences here before
> calling PSS.
> Thanks.
> Adam P. Cassidy
>
|||My apologies Hilary, I see that the error that I pasted was actually some
code I was working with! My definition of "flake out" would be getting the
regular guest of "An unknown full text failure (80004005) occurred in
function EnumCatalogs on full-text catalog ''." on one staging server and
most recently and never before seen by me as of last week "The Microsoft
Search service cannot be administered under the present user account" on a
second staging server.
I'm running SQL 2000 on both and within the last year I've had to reload two
servers from the ground up (windows installs included) in order to resolve
the first error message. What I'm trying to figure out is, what additional
troubleshooting I can do to:
Determine what caused the problem versus searching the msdn/technet articles
for this message only to find what seems to be multiple guesses as to what I
can check that has caused the problem (registry, permissions, accounts used,
manual reinstall, etc) when none of these things (in my opinion) would ever
be changed. I've yet to find any of these resolving my problem, including
the manual reinstall of MSSearch. I've always found nothing changed or
missing from the MSDN/Technet articles and therefore only resolved, for a
number of months at a time, the problem by reinstalling.
Currently that is my planned track for this upcoming weekend (what an
exciting time I'll have). There needs to be a more specific error message
for these full text index issues in my opinion - esp. when you find articles
that list 4-5 solutions to the same error.
Adam
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23iFOPDSKHHA.3952@.TK2MSFTNGP02.phx.gbl...
> can you define what you mean by flake out?
> Ideally you will have as few catalogs as possible. I'll try to repro this.
> --
> 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
>
> "Adam Patrick Cassidy" <apcassidy@.aol.com> wrote in message
> news:eIkMKERKHHA.2028@.TK2MSFTNGP03.phx.gbl...
>