2012年3月9日星期五

Full text content index corrupt

Hello,
I am getting this error on my full text search...
Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
content index is corrupt. , Server ULSM1, Procedure , Line 1
I am using SQL 2000 Standard...
This happens on only ONE of my tables... i have 2 tables, that are almost
identical in structure, but 1 table has 100k records, and the other has 600k
records..
It is the table that has 600k records where this corrupt action happens...
Can anyone help me with this? This is the first time i've seen this error
(and i've done a couple google searches, but nothing this specific).
Thank you.Is this table the only table in its catalog? If so rebuild the catalog to
see if this solves the problem. Review the event log to see if there are any
disk errors, or errors 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
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am getting this error on my full text search...
> Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
> content index is corrupt. , Server ULSM1, Procedure , Line 1
> I am using SQL 2000 Standard...
> This happens on only ONE of my tables... i have 2 tables, that are almost
> identical in structure, but 1 table has 100k records, and the other has
> 600k
> records..
> It is the table that has 600k records where this corrupt action happens...
> Can anyone help me with this? This is the first time i've seen this error
> (and i've done a couple google searches, but nothing this specific).
> Thank you.
>|||Hi Hilary,
I'll review the event log, but in the meantime i'll start the rebuild of the
catalog and see if that helps...
Thanks...
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any
> disk errors, or errors 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I am getting this error on my full text search...
> >
> > Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed.
The
> > content index is corrupt. , Server ULSM1, Procedure , Line 1
> >
> > I am using SQL 2000 Standard...
> >
> > This happens on only ONE of my tables... i have 2 tables, that are
almost
> > identical in structure, but 1 table has 100k records, and the other has
> > 600k
> > records..
> >
> > It is the table that has 600k records where this corrupt action
happens...
> >
> > Can anyone help me with this? This is the first time i've seen this
error
> > (and i've done a couple google searches, but nothing this specific).
> >
> > Thank you.
> >
> >
>|||Thanks hilary, that has helped...
Just an odd error i've never seen, nor could i find any topics on this
error.
Anyway, thanks again.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any
> disk errors, or errors 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I am getting this error on my full text search...
> >
> > Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed.
The
> > content index is corrupt. , Server ULSM1, Procedure , Line 1
> >
> > I am using SQL 2000 Standard...
> >
> > This happens on only ONE of my tables... i have 2 tables, that are
almost
> > identical in structure, but 1 table has 100k records, and the other has
> > 600k
> > records..
> >
> > It is the table that has 600k records where this corrupt action
happens...
> >
> > Can anyone help me with this? This is the first time i've seen this
error
> > (and i've done a couple google searches, but nothing this specific).
> >
> > Thank you.
> >
> >
>

没有评论:

发表评论