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: [email protected]
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 <[email protected]> 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"
