Maybe they just started to use some of the database capabilities that are
available:
http://laurentschneider.com/wordpress/2009/07/how-to-tune-where-name-likebc.html
Axton Grams
On Tue, Feb 7, 2012 at 10:37 AM, Joe Martin D'Souza <jdso...@shyle.net>wrote:
> Talking about bugs with FTS, did any of you'll have bugs with having the
> "(" character in the search (open parenthesis) with no close parenthesis in
> that search string throw out an FTS error "ARERR [875] FTSService could not
> complete the requested operation : FTSPlugin::multiGetOperation -
> com.bmc.arsys.fts.impl.lucene.**query.FTSQueryParser: *A*N*D* ARERR
> [8753] Error in plugin : ARSYS.ARF.FTS errors"..
>
> You would think a search should not really care what's in the search
> string so why is it expecting a close parenthesis when there is an open one
> in the search string? Its almost like its trying to evaluate the string as
> if it contains functions and parse it..
>
> I've raised a ticket last weekend with Remedy Support and am expecting it
> to be classified as a bug - (or as designed)..
>
> Joe
>
> -----Original Message----- From: Tauf Chowdhury
> Sent: Tuesday, February 07, 2012 10:08 AM Newsgroups:
> public.remedy.arsystem.general
>
> To: arslist@ARSLIST.ORG
> Subject: Re: 7.6.04 SP3 - SW00391781
>
> Misi,
> I remember this issue specifically with the Full text search. Do you
> know if it is related to that or specifically the DB?
>
> Sent from my iPhone
>
> On Feb 7, 2012, at 10:06 AM, Misi Mladoniczky <m...@rrr.se> wrote:
>
> Hi,
>>
>> In the "Known issues in the AR System server 7.6.04 Service Pack 3" I
>> found this thing:
>>
>> SW00391781
>> In BMC Remedy AR System, the search operation using the leading wildcard
>> character (%) is not as efficient as a complete string search or a
>> trailing wildcard search.
>> For example, search for the %block string is less efficient than a search
>> for either the block or block% strings.
>> To fix the issue, contact BMC Software Customer Support.
>> ---
>>
>> I thought that this was all due to database issues when doing LIKE
>> searches. Indexes was never used when doing trailing searches. How can
>> this be "fixed"?
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
>> Find these products, and many free tools and utilities, at http://rrr.se.
>>
>> ______________________________**______________________________**
>> ___________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>>
>
> ______________________________**______________________________**
> ___________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
> ______________________________**______________________________**
> ___________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
