Re: Error on Full-Text

From: John Kane (jt-kane_at_comcast.net)
Date: 08/04/04 

Date: Tue, 3 Aug 2004 20:47:05 -0700

Sathya,
Like money and taxes and death, the truth is in the details...
Could you provide the exact SQL query code that exceeds 8k (8192 bytes)
limit that succeeds in one database and fails in another on the same server?
Additionally, could you provide the full output of the following SQL code
from the server where both of these databases exist as well as a sample of
the text from the FT-enable tables in both databases?

use <your_database_1_name_here>
go
SELECT @@language
SELECT @@version
-- Note, you may need to set advance option for sp_configure.
EXEC sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

use <your_database_2_name_here>
go
SELECT @@language
SELECT @@version
-- Note, you may need to set advance option for sp_configure.
EXEC sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

Thanks,
John

"Sathya" <Sathya@discussions.microsoft.com> wrote in message
news:2F6BDF87-AB62-4208-A73C-053D04A69C83@microsoft.com...
> John,
>
> On the same server..this query works fine for one database whereas it does
not work for another database..since it is the same server everything is
same ie., the resources remain the same...
>
> If the contains clause size exceeds 8k this error is coming...I'm totally
confused and frustrated.
>
> Regards,
> Sathya
> "John Kane" wrote:
>
> > Sathya,
> > When you say "size exceeds 8k" are you referring to the "
> > contains_search_condition " (or 'freetext_string' ) string of the
contents
> > of your CONTAINS or FREETEXT query?
> >
> > Microsoft asked you to apply SP3 to your SQL Server 2000 server where
this
> > error occurred per KB article 317486 (Q317486) "FIX: A Query That Uses a
> > Large Search String in the CONTAINS Clause May Fail with Error Message
7607"
> > at:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;317486 Correct?
> >
> > If so, then what Microsoft most likely did not do was to further
research
> > the actual hex value returned with the "unknown results". Specifically,
the
> > hex value of "80040406" translates to "The request cannot be processed,
> > because the system is low on resources. Try again later, or contact your
> > system administrator to free up system resources."
> >
> > So, you may want to review your server's System event log for any low
system
> > resources, i.e., low free disk space on the system drive, or the disk
drive
> > where your FT Catalog's exist as well as low virtual memory. You can use
> > Perfmon performance counters to monitor these events when it re-occurs.
> >
> > Regards,
> > John
> >
> >
> >
> >
> >
> > "Sathya" <Sathya@discussions.microsoft.com> wrote in message
> > news:E7F6F5C4-5847-4621-A69B-495EA9FA4D0C@microsoft.com...
> > > Hi...
> > > If i reduce the size of the query it is working fine. If the size
exceeds
> > 8k this error is thrown...for that i installed sp3 which is the solution
> > microsoft rcommended. EVen after that it is not working. KIndly help me
in
> > this regard
> > > Thanks,
> > > sathya
> > >
> > > "Sathya" wrote:
> > >
> > > > No...I don't have any error messagefor 7607..
> > > > regards,
> > > > sathya
> > > >
> > > > "John Kane" wrote:
> > > >
> > > > > Sathya,
> > > > > This may be related to possible FT Catalog corruption issues. You
> > should
> > > > > review your server's Application event log for source events
> > "Microsoft
> > > > > Search" and MssCi (especially MssCi as it will contain the stack
trace
> > info)
> > > > > errors, warnings and informational events near the day/time of the
> > below
> > > > > error Msg 7607 and post them in your reply.
> > > > >
> > > > > For FTS related questions, please post to the newsgroup:
> > > > > microsoft.public.sqlserver.fulltext
> > > > > Regards,
> > > > > John
> > > > >
> > > > >
> > > > > "Sathya" <Sathya@discussions.microsoft.com> wrote in message
> > > > > news:BF6E262B-7AB7-48C5-8B46-E686D367D4BF@microsoft.com...
> > > > > > I'm getting the following error even after installing SP3
> > > > > >
> > > > > > Server: Msg 7607, Level 17, State 1, Line 1
> > > > > > Search on full-text catalog 'egpl_kb_index_on_attachment' for
> > database ID
> > > > > 8, table ID 1694629080 with search condition '"want"' failed with
> > unknown
> > > > > result (80040406).
> > > > > >
> > > > > > Please help me in this regard
> > > > >
> > > > >
> > > > >
> >
> >
> >