John,
This issue with the Full-Text is occuring at one of our
clients and I need to contact them to get the answers for
all the questions you asked. Unfortunately, they are gone
for today. As soon as i have the info i will post it for
you.
But in the mean time, let me answer some of the questions
that i do know. I know that they are running SQL Server
2000 (SP3).
And i know that they did run the same query in Query
Analyzer and yes, the Query Analyzer failed too. I think
the error they got was something about the catalog not
being enabled...
Tomorrow, I will get the exact error message and post that
information as well.
BTW- below is the T-SQL statement:
SELECT DISTINCT sm.id
FROM smtp_mail sm
JOIN (SELECT mcon.id_mail FROM mime_content mcon
WHERE CONTAINS(mcon.content,' "percent" ')) mc ON sm.id =
mc.id_mail
Thank you so much!
--Mitra
[quoted text, click to view] >-----Original Message-----
>Mitra,
>What's the exact version of SQL Server (7.0 or 2000) that
you are using?
>Could you post the full output of the following SQL code:
>
>SELECT @@version
>SELECT @@language
>go
>use <user_database_name>
>go
>exec sp_help_fulltext_catalogs
>exec sp_help_fulltext_tables
>exec sp_help_fulltext_columns
>go
>sp_help <FT_enable_table_name>
>go
>
>If you execute your T-SQL FTS query from SQL Server's
Query Analyzer tool,
>in the correct FT-enabled database and against the
correct FT-enabled table,
>do you get the same error?
>
>Thanks,
>John
>
>
>
>"mitra fatolahi" <mitra928@hotmail.com> wrote in message
>news:028801c3c5a5$1336f3b0$a401280a@phx.gbl...
>> Hi All,
>>
>> Our web application log file reports the following error
>> message when an end-user trys to search on a column that
>> has a full-text indexing:
>>
>> "[ERROR] archives.display_results(Execute new Query -
>> SMTP) : java.sql.SQLException: [Mitra2000]Search on
full-
>> text catalog 'CAT_Mime_Content' for database ID 7, table
>> ID 901578250 with search condition ' "stock" ' failed
with
>> unknown result (8004181d)"
>>
>> Any clue as to why we are getting this error?
>>
>> Your help is greatly appreciated!
>>
>> Thank you so much!
>> Mitra
>
>
>.
Mitra,
Thanks, I suspected that the FT Catalog might not be available &/or
populated and that running the T-SQL statement from the QA would provide a
more meaningful error and error message text. The sp_help_fulltext* system
stored proc outputs will also help.
BTW, an interesting FTS query...
John
[quoted text, click to view] "mitra fatolahi" <mitra928@hotmail.com> wrote in message
news:04ae01c3c5c7$4744a270$a401280a@phx.gbl...
> John,
>
> This issue with the Full-Text is occuring at one of our
> clients and I need to contact them to get the answers for
> all the questions you asked. Unfortunately, they are gone
> for today. As soon as i have the info i will post it for
> you.
>
> But in the mean time, let me answer some of the questions
> that i do know. I know that they are running SQL Server
> 2000 (SP3).
> And i know that they did run the same query in Query
> Analyzer and yes, the Query Analyzer failed too. I think
> the error they got was something about the catalog not
> being enabled...
> Tomorrow, I will get the exact error message and post that
> information as well.
>
> BTW- below is the T-SQL statement:
>
> SELECT DISTINCT sm.id
> FROM smtp_mail sm
> JOIN (SELECT mcon.id_mail FROM mime_content mcon
> WHERE CONTAINS(mcon.content,' "percent" ')) mc ON sm.id =
> mc.id_mail
>
> Thank you so much!
>
> --Mitra
>
>
>
>
>
> >-----Original Message-----
> >Mitra,
> >What's the exact version of SQL Server (7.0 or 2000) that
> you are using?
> >Could you post the full output of the following SQL code:
> >
> >SELECT @@version
> >SELECT @@language
> >go
> >use <user_database_name>
> >go
> >exec sp_help_fulltext_catalogs
> >exec sp_help_fulltext_tables
> >exec sp_help_fulltext_columns
> >go
> >sp_help <FT_enable_table_name>
> >go
> >
> >If you execute your T-SQL FTS query from SQL Server's
> Query Analyzer tool,
> >in the correct FT-enabled database and against the
> correct FT-enabled table,
> >do you get the same error?
> >
> >Thanks,
> >John
> >
> >
> >
> >"mitra fatolahi" <mitra928@hotmail.com> wrote in message
> >news:028801c3c5a5$1336f3b0$a401280a@phx.gbl...
> >> Hi All,
> >>
> >> Our web application log file reports the following error
> >> message when an end-user trys to search on a column that
> >> has a full-text indexing:
> >>
> >> "[ERROR] archives.display_results(Execute new Query -
> >> SMTP) : java.sql.SQLException: [Mitra2000]Search on
> full-
> >> text catalog 'CAT_Mime_Content' for database ID 7, table
> >> ID 901578250 with search condition ' "stock" ' failed
> with
> >> unknown result (8004181d)"
> >>
> >> Any clue as to why we are getting this error?
> >>
> >> Your help is greatly appreciated!
> >>
> >> Thank you so much!
> >> Mitra
> >
> >
> >.
> >
