Re: FTS reindex
I second LJ. there will be an indexer Java process which you can kill upon cleaning of the ft pending and ft collection content. If even that doesn't work. Remove fts license. Regards, Ravindrakumar On Thu, Jan 17, 2019, 5:08 AM Kevin Shaffer It still says re-index in progress, is there a way to reset that flag? > > > > [image: Partner Logo-EmailSig] <http://www.partneritsm.com/> > > Kevin Shaffer > > Partner IT, Inc. > > (C) 316-208-5341 > > (O) 888-380-8899 > > (F) 708-887-1704 > > > > *From:* ARSList *On Behalf Of *La Grua, Ed > via ARSList > *Sent:* Wednesday, January 16, 2019 2:25 PM > *To:* ARSList > *Cc:* La Grua, Ed > *Subject:* RE: FTS reindex > > > > Just delete all the records in ft_pending. > > > > delete from ft_pending > > commit > > > > > > Regards, > > > > Ed La Grua > > CTO Operations | Application Production Support for CTO | 222 Broadway, > New York, N.Y.|w 212.647.4311| c 917.583.0443 > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Kevin > Shaffer > *Sent:* Wednesday, January 16, 2019 3:20 PM > *To:* ARSList > *Subject:* FTS reindex > > > > 8.1.02 > > > > Is there a way to force stop a FTS re-index? We had a mistake in in our > configuration and we want to re-index but we have a re-index already in > progress. > > > > [image: Partner Logo-EmailSig] > <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.partneritsm.com_=DwMFAg=SFszdw3oxIkTvaP4xmzq_apLU3uL-3SxdAPNkldf__Q=C9ESUY6nyIajkdo3TpZCA19maEfsy2KhL303Vck73FY=uuk9yW69sXAmjPywlBT6dqBWmPtMvrf8mElcNPLXDBw=Ox8EXso-89Hzmecwc6pgiT7x_iqVPyW4R7DkW_2Xbks=> > > Kevin Shaffer > > Partner IT, Inc. > > (C) 316-208-5341 > > (O) 888-380-8899 > > (F) 708-887-1704 > > > -- > > This message, and any attachments, is for the intended recipient(s) only, > may contain information that is privileged, confidential and/or proprietary > and subject to important terms and conditions available at > http://www.bankofamerica.com/emaildisclaimer. If you are not the intended > recipient, please delete this message. > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: FTS reindex
It still says re-index in progress, is there a way to reset that flag? [Partner Logo-EmailSig]<http://www.partneritsm.com/> Kevin Shaffer Partner IT, Inc. (C) 316-208-5341 (O) 888-380-8899 (F) 708-887-1704 From: ARSList On Behalf Of La Grua, Ed via ARSList Sent: Wednesday, January 16, 2019 2:25 PM To: ARSList Cc: La Grua, Ed Subject: RE: FTS reindex Just delete all the records in ft_pending. delete from ft_pending commit Regards, Ed La Grua CTO Operations | Application Production Support for CTO | 222 Broadway, New York, N.Y.|w 212.647.4311| c 917.583.0443 From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Kevin Shaffer Sent: Wednesday, January 16, 2019 3:20 PM To: ARSList Subject: FTS reindex 8.1.02 Is there a way to force stop a FTS re-index? We had a mistake in in our configuration and we want to re-index but we have a re-index already in progress. [Partner Logo-EmailSig]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.partneritsm.com_=DwMFAg=SFszdw3oxIkTvaP4xmzq_apLU3uL-3SxdAPNkldf__Q=C9ESUY6nyIajkdo3TpZCA19maEfsy2KhL303Vck73FY=uuk9yW69sXAmjPywlBT6dqBWmPtMvrf8mElcNPLXDBw=Ox8EXso-89Hzmecwc6pgiT7x_iqVPyW4R7DkW_2Xbks=> Kevin Shaffer Partner IT, Inc. (C) 316-208-5341 (O) 888-380-8899 (F) 708-887-1704 This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: FTS reindex
Kevin, Shut down Remedy, clear out the FTS Collection directory and FT_Pending, restart remedy, tell it to re-index :) On Wed, Jan 16, 2019 at 1:21 PM Kevin Shaffer wrote: > 8.1.02 > > > > Is there a way to force stop a FTS re-index? We had a mistake in in our > configuration and we want to re-index but we have a re-index already in > progress. > > > > [image: Partner Logo-EmailSig] <http://www.partneritsm.com/> > > Kevin Shaffer > > Partner IT, Inc. > > (C) 316-208-5341 > > (O) 888-380-8899 > > (F) 708-887-1704 > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: FTS reindex
Just delete all the records in ft_pending. delete from ft_pending commit Regards, Ed La Grua CTO Operations | Application Production Support for CTO | 222 Broadway, New York, N.Y.|w 212.647.4311| c 917.583.0443 From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Kevin Shaffer Sent: Wednesday, January 16, 2019 3:20 PM To: ARSList Subject: FTS reindex 8.1.02 Is there a way to force stop a FTS re-index? We had a mistake in in our configuration and we want to re-index but we have a re-index already in progress. [Partner Logo-EmailSig]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.partneritsm.com_=DwMFAg=SFszdw3oxIkTvaP4xmzq_apLU3uL-3SxdAPNkldf__Q=C9ESUY6nyIajkdo3TpZCA19maEfsy2KhL303Vck73FY=uuk9yW69sXAmjPywlBT6dqBWmPtMvrf8mElcNPLXDBw=Ox8EXso-89Hzmecwc6pgiT7x_iqVPyW4R7DkW_2Xbks=> Kevin Shaffer Partner IT, Inc. (C) 316-208-5341 (O) 888-380-8899 (F) 708-887-1704 -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
FTS reindex
8.1.02 Is there a way to force stop a FTS re-index? We had a mistake in in our configuration and we want to re-index but we have a re-index already in progress. [Partner Logo-EmailSig]<http://www.partneritsm.com/> Kevin Shaffer Partner IT, Inc. (C) 316-208-5341 (O) 888-380-8899 (F) 708-887-1704 -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Inconsistent FTS Search Results
Hey Kevin, We've been having some similar FTS issues, as well. We just applied a BMC Hot Fix and it looks like it fixed our issues. Not sure if it will fix yours. I've attached the readme doc so you can take a look. Good Luck! Dylan On Tue, Oct 9, 2018 at 6:03 AM wrote: > Send ARSList mailing list submissions to > arslist@arslist.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://mailman.rrr.se/cgi/listinfo/arslist > or, via email, send a message with subject or body 'help' to > arslist-requ...@arslist.org > > You can reach the person managing the list at > arslist-ow...@arslist.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of ARSList digest..." > > > Today's Topics: > >1. Inconsistent FTS Search Results (Kevin Shaffer) >2. Re: Inconsistent FTS Search Results (LJ LongWing) >3. RE: Inconsistent FTS Search Results (Joel D Sender) > > > -- > > Message: 1 > Date: Mon, 8 Oct 2018 19:37:10 + > From: Kevin Shaffer > To: ARSList > Subject: Inconsistent FTS Search Results > Message-ID: > < > bn6pr05mb3492dbb5e442825168937649de...@bn6pr05mb3492.namprd05.prod.outlook.com > > > > Content-Type: text/plain; charset="us-ascii" > > 8.1.02 > Oracle > Solaris > Just finished a full reindex > > > When I query for a full incident number in the Global Search field from > the any console, i.e.Overview Console, sometimes it find a match and other > times it does not. For example, INC002000102345 returns a match and > INC002000102346 does not. It is not a permission issue or a tenancy issue > because I see both incidents in my console. I just cant query them both > from the Global Search field. > > What I notice is that the one that does get returned, INC002000102345, the > incident number is highlighted in the Excerpt column so I think FTS is > searching the Excerpt field not the actual incident number field. > > Has anyone seen a similar issue and is this working as expected? I would > assume that I can type any valid incident number and get a result, but > maybe not? Are there use cases that this is not true? How does the > Excerpt column in the FTS results get populated? > > TIA > Keviin > > -- next part -- > An HTML attachment was scrubbed... > URL: < > https://mailman.rrr.se/arslist/attachments/20181008/4f96fae9/attachment.html > > > > -- > > Message: 2 > Date: Mon, 8 Oct 2018 13:45:33 -0600 > From: LJ LongWing > To: arslist@arslist.org > Subject: Re: Inconsistent FTS Search Results > Message-ID: > < > canwtrtq+ukpuzdn4i3-ssn3wnmvntvsokok-evijbrsujae...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Kevin, > If you check the HPD:HelpDesk form and find the Incident Number field, if > you check the DB properties, there should be a value of 'ARticleId', or > something similar in the MSF Category field (I think that's it's > name)either way, having that value in there should populate it as the > first column in the global search column list > > On Mon, Oct 8, 2018 at 1:39 PM Kevin Shaffer > wrote: > > > 8.1.02 > > > > Oracle > > > > Solaris > > > > Just finished a full reindex > > > > > > > > > > > > When I query for a full incident number in the Global Search field from > > the any console, i.e.Overview Console, sometimes it find a match and > other > > times it does not. For example, INC002000102345 returns a match and > > INC002000102346 does not. It is not a permission issue or a tenancy > issue > > because I see both incidents in my console. I just cant query them both > > from the Global Search field. > > > > > > > > What I notice is that the one that does get returned, INC002000102345, > the > > incident number is highlighted in the Excerpt column so I think FTS is > > searching the Excerpt field not the actual incident number field. > > > > > > > > Has anyone seen a similar issue and is this working as expected? I would > > assume that I can type any valid incident number and get a result, but > > maybe not? Are there use cases that this is not true? How does the > > Excerpt column in the FTS results get populated? > > > > > > > > TIA > > > > Keviin > > > > > > -- > > ARSList mailing list > > ARSList@arslist.org > > https://mailm
RE: Inconsistent FTS Search Results
Kevin, On the outside chance that LJ didn’t solve your issue, you might check to see if an active link is (occasionally) setting a field that should not be included in the search. I solved a similar issue when we discovered an A/L that, for some records, set the ‘Assigned To Group’ in the search window. HTH, Joel Joel Sender * jdsen...@earthlink.net From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Monday, October 8, 2018 12:46 PM To: arslist@arslist.org Subject: Re: Inconsistent FTS Search Results Kevin, If you check the HPD:HelpDesk form and find the Incident Number field, if you check the DB properties, there should be a value of 'ARticleId', or something similar in the MSF Category field (I think that's it's name)either way, having that value in there should populate it as the first column in the global search column list On Mon, Oct 8, 2018 at 1:39 PM Kevin Shaffer wrote: 8.1.02 Oracle Solaris Just finished a full reindex When I query for a full incident number in the Global Search field from the any console, i.e.Overview Console, sometimes it find a match and other times it does not. For example, INC002000102345 returns a match and INC002000102346 does not. It is not a permission issue or a tenancy issue because I see both incidents in my console. I just cant query them both from the Global Search field. What I notice is that the one that does get returned, INC002000102345, the incident number is highlighted in the Excerpt column so I think FTS is searching the Excerpt field not the actual incident number field. Has anyone seen a similar issue and is this working as expected? I would assume that I can type any valid incident number and get a result, but maybe not? Are there use cases that this is not true? How does the Excerpt column in the FTS results get populated? TIA Keviin -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Inconsistent FTS Search Results
Kevin, If you check the HPD:HelpDesk form and find the Incident Number field, if you check the DB properties, there should be a value of 'ARticleId', or something similar in the MSF Category field (I think that's it's name)either way, having that value in there should populate it as the first column in the global search column list On Mon, Oct 8, 2018 at 1:39 PM Kevin Shaffer wrote: > 8.1.02 > > Oracle > > Solaris > > Just finished a full reindex > > > > > > When I query for a full incident number in the Global Search field from > the any console, i.e.Overview Console, sometimes it find a match and other > times it does not. For example, INC002000102345 returns a match and > INC002000102346 does not. It is not a permission issue or a tenancy issue > because I see both incidents in my console. I just cant query them both > from the Global Search field. > > > > What I notice is that the one that does get returned, INC002000102345, the > incident number is highlighted in the Excerpt column so I think FTS is > searching the Excerpt field not the actual incident number field. > > > > Has anyone seen a similar issue and is this working as expected? I would > assume that I can type any valid incident number and get a result, but > maybe not? Are there use cases that this is not true? How does the > Excerpt column in the FTS results get populated? > > > > TIA > > Keviin > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Inconsistent FTS Search Results
8.1.02 Oracle Solaris Just finished a full reindex When I query for a full incident number in the Global Search field from the any console, i.e.Overview Console, sometimes it find a match and other times it does not. For example, INC002000102345 returns a match and INC002000102346 does not. It is not a permission issue or a tenancy issue because I see both incidents in my console. I just cant query them both from the Global Search field. What I notice is that the one that does get returned, INC002000102345, the incident number is highlighted in the Excerpt column so I think FTS is searching the Excerpt field not the actual incident number field. Has anyone seen a similar issue and is this working as expected? I would assume that I can type any valid incident number and get a result, but maybe not? Are there use cases that this is not true? How does the Excerpt column in the FTS results get populated? TIA Keviin -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Still waiting for the response. Cheers, AA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Also please let me know how to access "FT_Pending" table so as to configure BPPM alert on it:- 1. Developer Studio? 2. Mid Tier? 3. Database.? etc ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Still waiting for the response on last mail queries. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Thank you :) May Bakken Director Global Technical Programs Service Support, R Direct +1 408.571.7248 Mobile +1 408.204.6578 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand Sent: Friday, June 17, 2016 2:54 AM To: arslist@ARSLIST.ORG Subject: Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue? Thanks for your kind response. As the FTS issue is frequent one that's why we are trying to implement the monitoring alert for the FT_Pending table. Please could you suggest for the threshold that need to be defined for the alert & also the approach so that it can be taken ahead. Also we are thinking to implement FTS collection folder monitoring as well with the help of BPPM tool. Early response will be highly appreciated. Cheers, AA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Thanks for your kind response. As the FTS issue is frequent one that's why we are trying to implement the monitoring alert for the FT_Pending table. Please could you suggest for the threshold that need to be defined for the alert & also the approach so that it can be taken ahead. Also we are thinking to implement FTS collection folder monitoring as well with the help of BPPM tool. Early response will be highly appreciated. Cheers, AA. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
To clarify we deleted the non indexing servers from the ranking form and only had the indexer. ARS will need to be restarted... On Thu, Jun 16, 2016, 6:03 PM Saji Philip <sphili...@gmail.com> wrote: > We had a similar issue. And it was related to the ranking form. We have > 3 application servers that are server grouped and had them ranked. We > noticed on the ft_pending table records were being placed from the non > indexing servers. So we just deleted all servers except for the indexer. > Truncated the fr_pending table, cleared out the configuration folder and > restarted index. Now the ft_pending table is clearing out and no > backlogged records. > > Hope this helps... > > On Thu, Jun 16, 2016, 8:48 AM Abhi$hek <abhi.masc...@gmail.com> wrote: > >> ** >> >> Remedy 8.1.02 >> On 16 Jun 2016 7:05 p.m., "Gadgil, Abhijeet" <abhijeet_gad...@bmc.com> >> wrote: >> >>> ** >>> What version of Remedy stack are you on? >>> >>> -Original Message- >>> *From:* Abhishek Anand [abhi.masc...@gmail.com] >>> *Received:* Thursday, 16 Jun 2016, 6:07PM >>> *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG] >>> *Subject:* Housekeeping & monitoring check on the FT_Pending & FTS >>> /collection/ folder for the FTS Failure issue? >>> >>> Hi Experts, >>> >>> >>> >>> We are facing frequent FTS failure issues with global as well as local >>> search. >>> >>> And records are getting piled up in FT_Pending table as well. >>> >>> >>> >>> So we are planning to implement monitoring alerts on the FT_Pending as >>> well as FTS /collection/ folder to proactively manage FTS issues. >>> >>> >>> >>> Please provide your valuable suggestion on it. >>> >>> Early response will be highly appreciated. >>> >>> >>> >>> Cheers, >>> >>> AA >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> "Where the Answers Are, and have been for 20 years" >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
We had a similar issue. And it was related to the ranking form. We have 3 application servers that are server grouped and had them ranked. We noticed on the ft_pending table records were being placed from the non indexing servers. So we just deleted all servers except for the indexer. Truncated the fr_pending table, cleared out the configuration folder and restarted index. Now the ft_pending table is clearing out and no backlogged records. Hope this helps... On Thu, Jun 16, 2016, 8:48 AM Abhi$hek <abhi.masc...@gmail.com> wrote: > ** > > Remedy 8.1.02 > On 16 Jun 2016 7:05 p.m., "Gadgil, Abhijeet" <abhijeet_gad...@bmc.com> > wrote: > >> ** >> What version of Remedy stack are you on? >> >> -Original Message- >> *From:* Abhishek Anand [abhi.masc...@gmail.com] >> *Received:* Thursday, 16 Jun 2016, 6:07PM >> *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG] >> *Subject:* Housekeeping & monitoring check on the FT_Pending & FTS >> /collection/ folder for the FTS Failure issue? >> >> Hi Experts, >> >> >> >> We are facing frequent FTS failure issues with global as well as local >> search. >> >> And records are getting piled up in FT_Pending table as well. >> >> >> >> So we are planning to implement monitoring alerts on the FT_Pending as >> well as FTS /collection/ folder to proactively manage FTS issues. >> >> >> >> Please provide your valuable suggestion on it. >> >> Early response will be highly appreciated. >> >> >> >> Cheers, >> >> AA >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Remedy 8.1.02 On 16 Jun 2016 7:05 p.m., "Gadgil, Abhijeet" <abhijeet_gad...@bmc.com> wrote: > ** > What version of Remedy stack are you on? > > -Original Message- > *From:* Abhishek Anand [abhi.masc...@gmail.com] > *Received:* Thursday, 16 Jun 2016, 6:07PM > *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG] > *Subject:* Housekeeping & monitoring check on the FT_Pending & FTS > /collection/ folder for the FTS Failure issue? > > Hi Experts, > > > > We are facing frequent FTS failure issues with global as well as local > search. > > And records are getting piled up in FT_Pending table as well. > > > > So we are planning to implement monitoring alerts on the FT_Pending as > well as FTS /collection/ folder to proactively manage FTS issues. > > > > Please provide your valuable suggestion on it. > > Early response will be highly appreciated. > > > > Cheers, > > AA > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
What version of Remedy stack are you on? -Original Message- From: Abhishek Anand [abhi.masc...@gmail.com] Received: Thursday, 16 Jun 2016, 6:07PM To: arslist@ARSLIST.ORG [arslist@ARSLIST.ORG] Subject: Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue? Hi Experts, We are facing frequent FTS failure issues with global as well as local search. And records are getting piled up in FT_Pending table as well. So we are planning to implement monitoring alerts on the FT_Pending as well as FTS /collection/ folder to proactively manage FTS issues. Please provide your valuable suggestion on it. Early response will be highly appreciated. Cheers, AA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Housekeeping & monitoring check on the FT_Pending & FTS /collection/ folder for the FTS Failure issue?
Hi Experts, We are facing frequent FTS failure issues with global as well as local search. And records are getting piled up in FT_Pending table as well. So we are planning to implement monitoring alerts on the FT_Pending as well as FTS /collection/ folder to proactively manage FTS issues. Please provide your valuable suggestion on it. Early response will be highly appreciated. Cheers, AA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS re-indexing Issue
Been there, done that. We had major performance problems with FTS re-indexing for a while too. Then we were referred to the FTS Index fortifications by BMC Support. This makes indexing MUCH more efficient and faster. It removes a bunch of indexes you don't need (for example, on join forms where the underlying forms are already indexed. Do this - you won't be sorry! Make sure you know what your custom (if any) FTS/MFS indexes are before you start though. https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Thursday, November 12, 2015 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: FTS re-indexing Issue Hi Chetan, check with BMC Support, we had a very similar issue where the FTS would never complete. I'm not near a computer and I don't remember the specifics but I remember BMC sent us a hotfix, it was for 7.6.04 SP2 I believe - hope this helps- Jase > On Nov 12, 2015, at 12:42 PM, Chetan Shinde <chetanshi...@gmail.com> wrote: > > ** > At a customer, we have three servers in a server group. I need to configure > FTS in failover. So I did the configurations for FTS as required. > App1(Primary FTS) is termed as Indexer and had re-index checked since last > night. rest of the two servers have Indexer and Searcher disabled. I do not > see any errors related to plugin in any of the arerror.log files on all the > three servers. > I was expecting re-indexing to get over today morning since it has been > running since the last 17 hrs. > Has anybody seen this before? Any advice? > > Regards, > Chetan Shinde > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4842 / Virus Database: 4447/10972 - Release Date: 11/09/15 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS re-indexing Issue
Thanks Jase. At the earlier client I worked, I configured FTS and that was a smooth implementation but with the current customer it is just not getting completed. To my surprise the earlier client had a huge environment and huge set of data compared to the one now. The reason I dont want to go to BMC is the two environments are with similar version so I know it works and it does not require any hotfix. Regards, Chetan Shinde On Thu, Nov 12, 2015 at 6:04 PM, Jase Brandon <jasebran...@gmail.com> wrote: > Hi Chetan, check with BMC Support, we had a very similar issue where the > FTS would never complete. I'm not near a computer and I don't remember the > specifics but I remember BMC sent us a hotfix, it was for 7.6.04 SP2 I > believe - hope this helps- Jase > > > On Nov 12, 2015, at 12:42 PM, Chetan Shinde <chetanshi...@gmail.com> > wrote: > > > > ** > > At a customer, we have three servers in a server group. I need to > configure FTS in failover. So I did the configurations for FTS as required. > App1(Primary FTS) is termed as Indexer and had re-index checked since last > night. rest of the two servers have Indexer and Searcher disabled. I do not > see any errors related to plugin in any of the arerror.log files on all the > three servers. > > I was expecting re-indexing to get over today morning since it has been > running since the last 17 hrs. > > Has anybody seen this before? Any advice? > > > > Regards, > > Chetan Shinde > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
FTS re-indexing Issue
At a customer, we have three servers in a server group. I need to configure FTS in failover. So I did the configurations for FTS as required. App1(Primary FTS) is termed as Indexer and had re-index checked since last night. rest of the two servers have Indexer and Searcher disabled. I do not see any errors related to plugin in any of the arerror.log files on all the three servers. I was expecting re-indexing to get over today morning since it has been running since the last 17 hrs. Has anybody seen this before? Any advice? Regards, Chetan Shinde ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS re-indexing Issue
Hi Chetan, check with BMC Support, we had a very similar issue where the FTS would never complete. I'm not near a computer and I don't remember the specifics but I remember BMC sent us a hotfix, it was for 7.6.04 SP2 I believe - hope this helps- Jase > On Nov 12, 2015, at 12:42 PM, Chetan Shinde <chetanshi...@gmail.com> wrote: > > ** > At a customer, we have three servers in a server group. I need to configure > FTS in failover. So I did the configurations for FTS as required. > App1(Primary FTS) is termed as Indexer and had re-index checked since last > night. rest of the two servers have Indexer and Searcher disabled. I do not > see any errors related to plugin in any of the arerror.log files on all the > three servers. > I was expecting re-indexing to get over today morning since it has been > running since the last 17 hrs. > Has anybody seen this before? Any advice? > > Regards, > Chetan Shinde > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS Re-index issue
We saw a race condition with ARS/ITSM 8.0 and 8.1 where FTS workflow searched the FTS index prior to a new record being indexed. The issue stopped when we unchecked Use FTS in Workflow. Because the record had not been indexed yet, instead of finding the recently submitted CM request by the CHG ID as designed, a filter with a Set Field expecting the ID would set a field to NULL based on If No Request Match = Set Field to $NULL$. From there the remaining workflow was thrown off. Turned out the Infrastructure Change ID (100182) had been set to FTS and MFS and should have only been MFS Only. After changing the field back to MFS Only we were able to re-enable Use FTS in Workflow. This was before the FTS Fortification <https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification> info was published so I suspect a lack of tuning was at play. Jason On Wed, Oct 28, 2015 at 6:48 AM, Jithin T.R < jithin.t.radhakrish...@gmail.com> wrote: > ** > Hi Michelle, > > Sorry for the delay in response. > > Thanks a lot for your suggestion. > > However, our issue was with FTS, as of now we just disabled o FTS on > workflows and that resolved the issue. We are looking into root cause of > the issue. > > Best Regards, > Jithin > > > > On Wed, Oct 7, 2015 at 7:15 PM, Lucero, Michelle < > michelle.luc...@bankofamerica.com> wrote: > >> ** >> >> Hi, Jithin: >> >> >> >> I am not sure if the error you’re seeing is related to FTS. >> >> >> >> In the past we’ve seen mismatches, because of an added middle initial, >> name, space, etc. We’ve also had a format mismatch, where an older record >> was stored First Name Last Name and the People record was stored Last Name, >> First Name. >> >> >> >> 1. Compare the Full Name for this individual in these three places: >> >> · CTM:People >> >> · CTM:SupportGroupFunctionalRole >> >> · User >> >> >> >> The Full Name format in all three places must match. >> >> >> >> 2. One more thing. Check to see if this individual has the same full >> name as someone else? >> >> >> >> Hope this helps, >> >> Michelle >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Jithin T.R >> *Sent:* Tuesday, October 06, 2015 2:37 AM >> >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: FTS Re-index issue >> >> >> >> ** >> >> Hi Manoj, >> >> >> >> Thanks you. >> >> >> >> The user form and permission are set up for this user without any issue. >> >> >> >> From my knowledge I don't think Functional Role are mapped in user form. >> >> >> >> Actually there are some workflows setting some temporary values while >> setting the Change Manager value in the field. This value will be set if >> there is a record CTM:SupportGroupFuncRoleLookUp with Full Name we selected >> from the list. >> >> >> >> I think because of the FTS issue, the system is unable to search the >> records using Full Name and in turn throws an error stating Invalid Change >> Manager. >> >> CHG:CRQ:ValidateChgManager_145 it is searching record using fullname >> >> CHG:CRQ:ValidateChgManager_146 this one is throwing error >> >> >> >> Best Regards, >> >> Jithin >> >> >> >> On Tue, Oct 6, 2015 at 12:25 PM, Manoj Kumar <manoj.anup...@gmail.com> >> wrote: >> >> ** >> >> Jithin, >> >> Check in user form once if the permission exists and try to re-add the >> permission. >> We had same issue and it worked . >> >> Thanks, >> Manoj >> +91 996 223 2006 >> >> Sent from my Moto Turbo smart phone >> >> On 6 Oct 2015 11:33, "Jithin T.R" <jithin.t.radhakrish...@gmail.com> >> wrote: >> >> ** >> >> Hi All, >> >> >> >> Thanks a lot for your valuable time on this. >> >> >> >> *"The issue we are facing is when we try to assign a change request to >> change manager system throws an error stating Invalid change manager. We >> have everything configured for that users.* >> >> >> >> *When we searched the record for that user in >> CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the >> records. However, when try it with full name no records found."* >> >> &g
Re: FTS Re-index issue
Hi Michelle, Sorry for the delay in response. Thanks a lot for your suggestion. However, our issue was with FTS, as of now we just disabled o FTS on workflows and that resolved the issue. We are looking into root cause of the issue. Best Regards, Jithin On Wed, Oct 7, 2015 at 7:15 PM, Lucero, Michelle < michelle.luc...@bankofamerica.com> wrote: > ** > > Hi, Jithin: > > > > I am not sure if the error you’re seeing is related to FTS. > > > > In the past we’ve seen mismatches, because of an added middle initial, > name, space, etc. We’ve also had a format mismatch, where an older record > was stored First Name Last Name and the People record was stored Last Name, > First Name. > > > > 1. Compare the Full Name for this individual in these three places: > > · CTM:People > > · CTM:SupportGroupFunctionalRole > > · User > > > > The Full Name format in all three places must match. > > > > 2. One more thing. Check to see if this individual has the same full > name as someone else? > > > > Hope this helps, > > Michelle > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Jithin T.R > *Sent:* Tuesday, October 06, 2015 2:37 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: FTS Re-index issue > > > > ** > > Hi Manoj, > > > > Thanks you. > > > > The user form and permission are set up for this user without any issue. > > > > From my knowledge I don't think Functional Role are mapped in user form. > > > > Actually there are some workflows setting some temporary values while > setting the Change Manager value in the field. This value will be set if > there is a record CTM:SupportGroupFuncRoleLookUp with Full Name we selected > from the list. > > > > I think because of the FTS issue, the system is unable to search the > records using Full Name and in turn throws an error stating Invalid Change > Manager. > > CHG:CRQ:ValidateChgManager_145 it is searching record using fullname > > CHG:CRQ:ValidateChgManager_146 this one is throwing error > > > > Best Regards, > > Jithin > > > > On Tue, Oct 6, 2015 at 12:25 PM, Manoj Kumar <manoj.anup...@gmail.com> > wrote: > > ** > > Jithin, > > Check in user form once if the permission exists and try to re-add the > permission. > We had same issue and it worked . > > Thanks, > Manoj > +91 996 223 2006 > > Sent from my Moto Turbo smart phone > > On 6 Oct 2015 11:33, "Jithin T.R" <jithin.t.radhakrish...@gmail.com> > wrote: > > ** > > Hi All, > > > > Thanks a lot for your valuable time on this. > > > > *"The issue we are facing is when we try to assign a change request to > change manager system throws an error stating Invalid change manager. We > have everything configured for that users.* > > > > *When we searched the record for that user in > CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the > records. However, when try it with full name no records found."* > > > > We are on Remedy 8.1 and have 2 servers. > > > > Both servers are configured as Server Group-Indexer in FTS Configuration > form, there is no Server Group-Searcher defined and both servers have entry > in Server Ranking form for FTS. > > > > Is this mandatory to have a Server Group-Searcher ? or based on ranking in > Server Group Ranking form, will lower ranked server automatically turns > into Searcher ? > > > > Best Regards, > > Jithin > > > > > > On Tue, Oct 6, 2015 at 8:17 AM, William Rentfrow < > wrentf...@stratacominc.com> wrote: > > ** > > We're in the process of testing version 9, so I can't comment on that yet. > > > > William Rentfrow > > wrentf...@stratacominc.com > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Peter Romain > *Sent:* Monday, October 05, 2015 3:51 PM > > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: FTS Re-index issue > > > > ** > > FTS has changed since Williams description. > > > > Indexes should now be on the disks of the servers doing the indexing for > improved performance. > > Each indexing server creates its own index that it uses for searches. > > Servers that are not indexers (those having no FTS record in the server > group ranking form) use the primary indexing server for searches. If this > server isn’t available the
Re: FTS Re-index issue
Hi, Jithin: No worries. I’m glad you were able to resolve it for now. Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R Sent: Wednesday, October 28, 2015 8:49 AM To: arslist@ARSLIST.ORG Subject: Re: FTS Re-index issue ** Hi Michelle, Sorry for the delay in response. Thanks a lot for your suggestion. However, our issue was with FTS, as of now we just disabled o FTS on workflows and that resolved the issue. We are looking into root cause of the issue. Best Regards, Jithin On Wed, Oct 7, 2015 at 7:15 PM, Lucero, Michelle <michelle.luc...@bankofamerica.com<mailto:michelle.luc...@bankofamerica.com>> wrote: ** Hi, Jithin: I am not sure if the error you’re seeing is related to FTS. In the past we’ve seen mismatches, because of an added middle initial, name, space, etc. We’ve also had a format mismatch, where an older record was stored First Name Last Name and the People record was stored Last Name, First Name. 1. Compare the Full Name for this individual in these three places: • CTM:People • CTM:SupportGroupFunctionalRole • User The Full Name format in all three places must match. 2. One more thing. Check to see if this individual has the same full name as someone else? Hope this helps, Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Jithin T.R Sent: Tuesday, October 06, 2015 2:37 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** Hi Manoj, Thanks you. The user form and permission are set up for this user without any issue. From my knowledge I don't think Functional Role are mapped in user form. Actually there are some workflows setting some temporary values while setting the Change Manager value in the field. This value will be set if there is a record CTM:SupportGroupFuncRoleLookUp with Full Name we selected from the list. I think because of the FTS issue, the system is unable to search the records using Full Name and in turn throws an error stating Invalid Change Manager. CHG:CRQ:ValidateChgManager_145 it is searching record using fullname CHG:CRQ:ValidateChgManager_146 this one is throwing error Best Regards, Jithin On Tue, Oct 6, 2015 at 12:25 PM, Manoj Kumar <manoj.anup...@gmail.com<mailto:manoj.anup...@gmail.com>> wrote: ** Jithin, Check in user form once if the permission exists and try to re-add the permission. We had same issue and it worked . Thanks, Manoj +91 996 223 2006 Sent from my Moto Turbo smart phone On 6 Oct 2015 11:33, "Jithin T.R" <jithin.t.radhakrish...@gmail.com<mailto:jithin.t.radhakrish...@gmail.com>> wrote: ** Hi All, Thanks a lot for your valuable time on this. "The issue we are facing is when we try to assign a change request to change manager system throws an error stating Invalid change manager. We have everything configured for that users. When we searched the record for that user in CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the records. However, when try it with full name no records found." We are on Remedy 8.1 and have 2 servers. Both servers are configured as Server Group-Indexer in FTS Configuration form, there is no Server Group-Searcher defined and both servers have entry in Server Ranking form for FTS. Is this mandatory to have a Server Group-Searcher ? or based on ranking in Server Group Ranking form, will lower ranked server automatically turns into Searcher ? Best Regards, Jithin On Tue, Oct 6, 2015 at 8:17 AM, William Rentfrow <wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com>> wrote: ** We're in the process of testing version 9, so I can't comment on that yet. William Rentfrow wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com> Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Peter Romain Sent: Monday, October 05, 2015 3:51 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** FTS has changed since Williams description. Indexes should now be on the disks of the servers doing the indexing for improved performance. Each indexing server creates its own index that it uses for searches. Servers that are not indexers (those having no FTS record in the server group ranking form) use the primary indexing server for searches. If this server isn’t available the ranking form tells them which server to try next. Community posts discuss FTS, e.g.: https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group The fortification does work to reduce the number of fields needing indexing but we found that adding a cus
Re: FTS Re-index issue
Hi, Jithin: I am not sure if the error you’re seeing is related to FTS. In the past we’ve seen mismatches, because of an added middle initial, name, space, etc. We’ve also had a format mismatch, where an older record was stored First Name Last Name and the People record was stored Last Name, First Name. 1. Compare the Full Name for this individual in these three places: · CTM:People · CTM:SupportGroupFunctionalRole · User The Full Name format in all three places must match. 2. One more thing. Check to see if this individual has the same full name as someone else? Hope this helps, Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R Sent: Tuesday, October 06, 2015 2:37 AM To: arslist@ARSLIST.ORG Subject: Re: FTS Re-index issue ** Hi Manoj, Thanks you. The user form and permission are set up for this user without any issue. From my knowledge I don't think Functional Role are mapped in user form. Actually there are some workflows setting some temporary values while setting the Change Manager value in the field. This value will be set if there is a record CTM:SupportGroupFuncRoleLookUp with Full Name we selected from the list. I think because of the FTS issue, the system is unable to search the records using Full Name and in turn throws an error stating Invalid Change Manager. CHG:CRQ:ValidateChgManager_145 it is searching record using fullname CHG:CRQ:ValidateChgManager_146 this one is throwing error Best Regards, Jithin On Tue, Oct 6, 2015 at 12:25 PM, Manoj Kumar <manoj.anup...@gmail.com<mailto:manoj.anup...@gmail.com>> wrote: ** Jithin, Check in user form once if the permission exists and try to re-add the permission. We had same issue and it worked . Thanks, Manoj +91 996 223 2006 Sent from my Moto Turbo smart phone On 6 Oct 2015 11:33, "Jithin T.R" <jithin.t.radhakrish...@gmail.com<mailto:jithin.t.radhakrish...@gmail.com>> wrote: ** Hi All, Thanks a lot for your valuable time on this. "The issue we are facing is when we try to assign a change request to change manager system throws an error stating Invalid change manager. We have everything configured for that users. When we searched the record for that user in CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the records. However, when try it with full name no records found." We are on Remedy 8.1 and have 2 servers. Both servers are configured as Server Group-Indexer in FTS Configuration form, there is no Server Group-Searcher defined and both servers have entry in Server Ranking form for FTS. Is this mandatory to have a Server Group-Searcher ? or based on ranking in Server Group Ranking form, will lower ranked server automatically turns into Searcher ? Best Regards, Jithin On Tue, Oct 6, 2015 at 8:17 AM, William Rentfrow <wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com>> wrote: ** We're in the process of testing version 9, so I can't comment on that yet. William Rentfrow wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com> Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Peter Romain Sent: Monday, October 05, 2015 3:51 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** FTS has changed since Williams description. Indexes should now be on the disks of the servers doing the indexing for improved performance. Each indexing server creates its own index that it uses for searches. Servers that are not indexers (those having no FTS record in the server group ranking form) use the primary indexing server for searches. If this server isn’t available the ranking form tells them which server to try next. Community posts discuss FTS, e.g.: https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group The fortification does work to reduce the number of fields needing indexing but we found that adding a customisation to, say, the incident form caused the index information on indexed fields to propagate to incident join forms and then be indexed. BMC was going to fix this but I’ve not tested this on the latest versions. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: 05 October 2015 16:47 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** I disagree. You do NOT want to re-index from every server. First of all - what version of ARS? Let's assume it's version 8 or later. Second - when you re-index there's a specific process. You should disable FTS on all servers and disable indexing on all servers. Then shut them all down. Delete all
Re: FTS Re-index issue
Hi All, Thanks a lot for your valuable time on this. *"The issue we are facing is when we try to assign a change request to change manager system throws an error stating Invalid change manager. We have everything configured for that users.* *When we searched the record for that user in CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the records. However, when try it with full name no records found."* We are on Remedy 8.1 and have 2 servers. Both servers are configured as Server Group-Indexer in FTS Configuration form, there is no Server Group-Searcher defined and both servers have entry in Server Ranking form for FTS. Is this mandatory to have a Server Group-Searcher ? or based on ranking in Server Group Ranking form, will lower ranked server automatically turns into Searcher ? Best Regards, Jithin On Tue, Oct 6, 2015 at 8:17 AM, William Rentfrow <wrentf...@stratacominc.com > wrote: > ** > > We're in the process of testing version 9, so I can't comment on that yet. > > > > William Rentfrow > > wrentf...@stratacominc.com > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Peter Romain > *Sent:* Monday, October 05, 2015 3:51 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: FTS Re-index issue > > > > ** > > FTS has changed since Williams description. > > > > Indexes should now be on the disks of the servers doing the indexing for > improved performance. > > Each indexing server creates its own index that it uses for searches. > > Servers that are not indexers (those having no FTS record in the server > group ranking form) use the primary indexing server for searches. If this > server isn’t available the ranking form tells them which server to try next. > > Community posts discuss FTS, e.g.: > > > https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group > > > > The fortification does work to reduce the number of fields needing > indexing but we found that adding a customisation to, say, the incident > form caused the index information on indexed fields to propagate to > incident join forms and then be indexed. > > BMC was going to fix this but I’ve not tested this on the latest versions. > > > > > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *William > Rentfrow > *Sent:* 05 October 2015 16:47 > *To:* arslist@ARSLIST.ORG > *Subject:* Re: FTS Re-index issue > > > > ** > > I disagree. You do NOT want to re-index from every server. > > > > First of all - what version of ARS? Let's assume it's version 8 or > later. > > > > Second - when you re-index there's a specific process. You should disable > FTS on all servers and disable indexing on all servers. Then shut them all > down. Delete all of the index files from the shared index location (see > below). Use a SQL tool and truncate the table FT_PENDING (or write a > Display Only form + workflow to do this, which is what I did for long term > ease of use). Then start the admin server and enable indexing. Then start > a re-index. Start the other servers back up and turn FTS back on when the > re-index is done. > > > > Now as to configuration > > > > There's more than one way to do it but BMC definitely has a preferred way. > > > > In a server group BMC prefers you have a shared file location all servers > can access. One server - usually the admin server for the server group - > is the indexing server. It creates all of the index files and updates the > files when new requests are put into the FT_PENDING table. > > > > One of the other servers (or the other server if you only have two > servers) is the search server. It should have FTS indexing disabled and > should be configured to retrieve all searches for FTS. So all of the > plugins in the ar.conf/ar.cfg on every server should reference the search > server. This prevents file locking problems. > > > > Also, there is an FTS fortifications patch out that removes a LOT of > extra/unused indexes and GREATLY reduces the amount of time it takes to do > a full re-index. I highly recommend applying this if you have not. > > > > William Rentfrow > > wrentf...@stratacominc.com > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Du
Re: FTS Re-index issue
Hi Manoj, Thanks you. The user form and permission are set up for this user without any issue. >From my knowledge I don't think Functional Role are mapped in user form. Actually there are some workflows setting some temporary values while setting the Change Manager value in the field. This value will be set if there is a record CTM:SupportGroupFuncRoleLookUp with Full Name we selected from the list. I think because of the FTS issue, the system is unable to search the records using Full Name and in turn throws an error stating Invalid Change Manager. CHG:CRQ:ValidateChgManager_145 it is searching record using fullname CHG:CRQ:ValidateChgManager_146 this one is throwing error Best Regards, Jithin On Tue, Oct 6, 2015 at 12:25 PM, Manoj Kumar <manoj.anup...@gmail.com> wrote: > ** > > Jithin, > > Check in user form once if the permission exists and try to re-add the > permission. > We had same issue and it worked . > > Thanks, > Manoj > +91 996 223 2006 > > Sent from my Moto Turbo smart phone > On 6 Oct 2015 11:33, "Jithin T.R" <jithin.t.radhakrish...@gmail.com> > wrote: > >> ** >> Hi All, >> >> Thanks a lot for your valuable time on this. >> >> *"The issue we are facing is when we try to assign a change request to >> change manager system throws an error stating Invalid change manager. We >> have everything configured for that users.* >> >> *When we searched the record for that user in >> CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the >> records. However, when try it with full name no records found."* >> >> We are on Remedy 8.1 and have 2 servers. >> >> Both servers are configured as Server Group-Indexer in FTS Configuration >> form, there is no Server Group-Searcher defined and both servers have entry >> in Server Ranking form for FTS. >> >> Is this mandatory to have a Server Group-Searcher ? or based on ranking >> in Server Group Ranking form, will lower ranked server automatically turns >> into Searcher ? >> >> Best Regards, >> Jithin >> >> >> On Tue, Oct 6, 2015 at 8:17 AM, William Rentfrow < >> wrentf...@stratacominc.com> wrote: >> >>> ** >>> >>> We're in the process of testing version 9, so I can't comment on that >>> yet. >>> >>> >>> >>> William Rentfrow >>> >>> wrentf...@stratacominc.com >>> >>> Office: 715-204-3061 or 701-232-5697x25 >>> >>> Cell: 715-498-5056 >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Peter Romain >>> *Sent:* Monday, October 05, 2015 3:51 PM >>> >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: FTS Re-index issue >>> >>> >>> >>> ** >>> >>> FTS has changed since Williams description. >>> >>> >>> >>> Indexes should now be on the disks of the servers doing the indexing for >>> improved performance. >>> >>> Each indexing server creates its own index that it uses for searches. >>> >>> Servers that are not indexers (those having no FTS record in the server >>> group ranking form) use the primary indexing server for searches. If this >>> server isn’t available the ranking form tells them which server to try next. >>> >>> Community posts discuss FTS, e.g.: >>> >>> >>> https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group >>> >>> >>> >>> The fortification does work to reduce the number of fields needing >>> indexing but we found that adding a customisation to, say, the incident >>> form caused the index information on indexed fields to propagate to >>> incident join forms and then be indexed. >>> >>> BMC was going to fix this but I’ve not tested this on the latest >>> versions. >>> >>> >>> >>> >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [ >>> mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *William >>> Rentfrow >>> *Sent:* 05 October 2015 16:47 >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: FTS Re-index issue >>> >>> >>> >>> ** >>> >>> I disagree. You do NOT want to re-index from every server. >>> >>> >>> >
Re: FTS Re-index issue
Jithin, Check in user form once if the permission exists and try to re-add the permission. We had same issue and it worked . Thanks, Manoj +91 996 223 2006 Sent from my Moto Turbo smart phone On 6 Oct 2015 11:33, "Jithin T.R" <jithin.t.radhakrish...@gmail.com> wrote: > ** > Hi All, > > Thanks a lot for your valuable time on this. > > *"The issue we are facing is when we try to assign a change request to > change manager system throws an error stating Invalid change manager. We > have everything configured for that users.* > > *When we searched the record for that user in > CTM:SupportGroupFuncRoleLookUp using Login ID it retrieves all the > records. However, when try it with full name no records found."* > > We are on Remedy 8.1 and have 2 servers. > > Both servers are configured as Server Group-Indexer in FTS Configuration > form, there is no Server Group-Searcher defined and both servers have entry > in Server Ranking form for FTS. > > Is this mandatory to have a Server Group-Searcher ? or based on ranking in > Server Group Ranking form, will lower ranked server automatically turns > into Searcher ? > > Best Regards, > Jithin > > > On Tue, Oct 6, 2015 at 8:17 AM, William Rentfrow < > wrentf...@stratacominc.com> wrote: > >> ** >> >> We're in the process of testing version 9, so I can't comment on that yet. >> >> >> >> William Rentfrow >> >> wrentf...@stratacominc.com >> >> Office: 715-204-3061 or 701-232-5697x25 >> >> Cell: 715-498-5056 >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Peter Romain >> *Sent:* Monday, October 05, 2015 3:51 PM >> >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: FTS Re-index issue >> >> >> >> ** >> >> FTS has changed since Williams description. >> >> >> >> Indexes should now be on the disks of the servers doing the indexing for >> improved performance. >> >> Each indexing server creates its own index that it uses for searches. >> >> Servers that are not indexers (those having no FTS record in the server >> group ranking form) use the primary indexing server for searches. If this >> server isn’t available the ranking form tells them which server to try next. >> >> Community posts discuss FTS, e.g.: >> >> >> https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group >> >> >> >> The fortification does work to reduce the number of fields needing >> indexing but we found that adding a customisation to, say, the incident >> form caused the index information on indexed fields to propagate to >> incident join forms and then be indexed. >> >> BMC was going to fix this but I’ve not tested this on the latest versions. >> >> >> >> >> >> >> >> *From:* Action Request System discussion list(ARSList) [ >> mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *William >> Rentfrow >> *Sent:* 05 October 2015 16:47 >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: FTS Re-index issue >> >> >> >> ** >> >> I disagree. You do NOT want to re-index from every server. >> >> >> >> First of all - what version of ARS? Let's assume it's version 8 or >> later. >> >> >> >> Second - when you re-index there's a specific process. You should >> disable FTS on all servers and disable indexing on all servers. Then shut >> them all down. Delete all of the index files from the shared index >> location (see below). Use a SQL tool and truncate the table FT_PENDING (or >> write a Display Only form + workflow to do this, which is what I did for >> long term ease of use). Then start the admin server and enable indexing. >> Then start a re-index. Start the other servers back up and turn FTS back >> on when the re-index is done. >> >> >> >> Now as to configuration >> >> >> >> There's more than one way to do it but BMC definitely has a preferred way. >> >> >> >> In a server group BMC prefers you have a shared file location all servers >> can access. One server - usually the admin server for the server group - >> is the indexing server. It creates all of the index files and updates the >> files when new requests are put into the FT_PENDING table. >> >> >> >> One of the other servers (or the other ser
Re: FTS Re-index issue
FTS has changed since Williams description. Indexes should now be on the disks of the servers doing the indexing for improved performance. Each indexing server creates its own index that it uses for searches. Servers that are not indexers (those having no FTS record in the server group ranking form) use the primary indexing server for searches. If this server isn’t available the ranking form tells them which server to try next. Community posts discuss FTS, e.g.: https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group The fortification does work to reduce the number of fields needing indexing but we found that adding a customisation to, say, the incident form caused the index information on indexed fields to propagate to incident join forms and then be indexed. BMC was going to fix this but I’ve not tested this on the latest versions. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: 05 October 2015 16:47 To: arslist@ARSLIST.ORG Subject: Re: FTS Re-index issue ** I disagree. You do NOT want to re-index from every server. First of all - what version of ARS? Let's assume it's version 8 or later. Second - when you re-index there's a specific process. You should disable FTS on all servers and disable indexing on all servers. Then shut them all down. Delete all of the index files from the shared index location (see below). Use a SQL tool and truncate the table FT_PENDING (or write a Display Only form + workflow to do this, which is what I did for long term ease of use). Then start the admin server and enable indexing. Then start a re-index. Start the other servers back up and turn FTS back on when the re-index is done. Now as to configuration There's more than one way to do it but BMC definitely has a preferred way. In a server group BMC prefers you have a shared file location all servers can access. One server - usually the admin server for the server group - is the indexing server. It creates all of the index files and updates the files when new requests are put into the FT_PENDING table. One of the other servers (or the other server if you only have two servers) is the search server. It should have FTS indexing disabled and should be configured to retrieve all searches for FTS. So all of the plugins in the ar.conf/ar.cfg on every server should reference the search server. This prevents file locking problems. Also, there is an FTS fortifications patch out that removes a LOT of extra/unused indexes and GREATLY reduces the amount of time it takes to do a full re-index. I highly recommend applying this if you have not. William Rentfrow wrentf...@stratacominc.com <mailto:wrentf...@stratacominc.com> Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Durga, V H V Sekhar Sent: Monday, October 05, 2015 8:59 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** You need to re-index from both the indexer servers. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R Sent: 05 October 2015 06:55 To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: FTS Re-index issue ** Hi Team, We have an issue, I cannot search using full name (Change Manager) and throwing error. This we have fixed by re-indexing. However, no we have an issue when we run re-index(only on primary server) it works fine in that server but not in other server. What is the procedure to FTS re-index in a server group environment ? We have 2 server both are configured as Server Group Indexer. Ranked the servers in Ranking form. Do we need to re-index each server ? Thanks & Regards, Jithin Radhakrishnan _ARSlist: "Where the Answers Are" and have been for 20 years_ _ No virus found in this message. Checked by AVG - www.avg.com <http://www.avg.com> Version: 2014.0.4830 / Virus Database: 4365/10744 - Release Date: 10/02/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS Re-index issue
We're in the process of testing version 9, so I can't comment on that yet. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peter Romain Sent: Monday, October 05, 2015 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: FTS Re-index issue ** FTS has changed since Williams description. Indexes should now be on the disks of the servers doing the indexing for improved performance. Each indexing server creates its own index that it uses for searches. Servers that are not indexers (those having no FTS record in the server group ranking form) use the primary indexing server for searches. If this server isn’t available the ranking form tells them which server to try next. Community posts discuss FTS, e.g.: https://communities.bmc.com/community/bmcdn/bmc_remedy_ar_system/blog/2013/10/11/the-pulse-high-availability-for-fts-in-a-server-group The fortification does work to reduce the number of fields needing indexing but we found that adding a customisation to, say, the incident form caused the index information on indexed fields to propagate to incident join forms and then be indexed. BMC was going to fix this but I’ve not tested this on the latest versions. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: 05 October 2015 16:47 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** I disagree. You do NOT want to re-index from every server. First of all - what version of ARS? Let's assume it's version 8 or later. Second - when you re-index there's a specific process. You should disable FTS on all servers and disable indexing on all servers. Then shut them all down. Delete all of the index files from the shared index location (see below). Use a SQL tool and truncate the table FT_PENDING (or write a Display Only form + workflow to do this, which is what I did for long term ease of use). Then start the admin server and enable indexing. Then start a re-index. Start the other servers back up and turn FTS back on when the re-index is done. Now as to configuration There's more than one way to do it but BMC definitely has a preferred way. In a server group BMC prefers you have a shared file location all servers can access. One server - usually the admin server for the server group - is the indexing server. It creates all of the index files and updates the files when new requests are put into the FT_PENDING table. One of the other servers (or the other server if you only have two servers) is the search server. It should have FTS indexing disabled and should be configured to retrieve all searches for FTS. So all of the plugins in the ar.conf/ar.cfg on every server should reference the search server. This prevents file locking problems. Also, there is an FTS fortifications patch out that removes a LOT of extra/unused indexes and GREATLY reduces the amount of time it takes to do a full re-index. I highly recommend applying this if you have not. William Rentfrow wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com> Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Durga, V H V Sekhar Sent: Monday, October 05, 2015 8:59 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: FTS Re-index issue ** You need to re-index from both the indexer servers. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R Sent: 05 October 2015 06:55 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: FTS Re-index issue ** Hi Team, We have an issue, I cannot search using full name (Change Manager) and throwing error. This we have fixed by re-indexing. However, no we have an issue when we run re-index(only on primary server) it works fine in that server but not in other server. What is the procedure to FTS re-index in a server group environment ? We have 2 server both are configured as Server Group Indexer. Ranked the servers in Ranking form. Do we need to re-index each server ? Thanks & Regards, Jithin Radhakrishnan _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4830 / Virus Database: 4365/10744 - Release Date: 10/02/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4830 / Virus Database: 4365/10744 - Release Date:
FTS Re-index issue
Hi Team, We have an issue, I cannot search using full name (Change Manager) and throwing error. This we have fixed by re-indexing. However, no we have an issue when we run re-index(only on primary server) it works fine in that server but not in other server. What is the procedure to FTS re-index in a server group environment ? We have 2 server both are configured as Server Group Indexer. Ranked the servers in Ranking form. Do we need to re-index each server ? Thanks & Regards, Jithin Radhakrishnan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS Re-index issue
You need to re-index from both the indexer servers. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R Sent: 05 October 2015 06:55 To: arslist@ARSLIST.ORG Subject: FTS Re-index issue ** Hi Team, We have an issue, I cannot search using full name (Change Manager) and throwing error. This we have fixed by re-indexing. However, no we have an issue when we run re-index(only on primary server) it works fine in that server but not in other server. What is the procedure to FTS re-index in a server group environment ? We have 2 server both are configured as Server Group Indexer. Ranked the servers in Ranking form. Do we need to re-index each server ? Thanks & Regards, Jithin Radhakrishnan _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS Re-index issue
I disagree. You do NOT want to re-index from every server. First of all - what version of ARS? Let's assume it's version 8 or later. Second - when you re-index there's a specific process. You should disable FTS on all servers and disable indexing on all servers. Then shut them all down. Delete all of the index files from the shared index location (see below). Use a SQL tool and truncate the table FT_PENDING (or write a Display Only form + workflow to do this, which is what I did for long term ease of use). Then start the admin server and enable indexing. Then start a re-index. Start the other servers back up and turn FTS back on when the re-index is done. Now as to configuration There's more than one way to do it but BMC definitely has a preferred way. In a server group BMC prefers you have a shared file location all servers can access. One server - usually the admin server for the server group - is the indexing server. It creates all of the index files and updates the files when new requests are put into the FT_PENDING table. One of the other servers (or the other server if you only have two servers) is the search server. It should have FTS indexing disabled and should be configured to retrieve all searches for FTS. So all of the plugins in the ar.conf/ar.cfg on every server should reference the search server. This prevents file locking problems. Also, there is an FTS fortifications patch out that removes a LOT of extra/unused indexes and GREATLY reduces the amount of time it takes to do a full re-index. I highly recommend applying this if you have not. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Durga, V H V Sekhar Sent: Monday, October 05, 2015 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: FTS Re-index issue ** You need to re-index from both the indexer servers. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jithin T.R Sent: 05 October 2015 06:55 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: FTS Re-index issue ** Hi Team, We have an issue, I cannot search using full name (Change Manager) and throwing error. This we have fixed by re-indexing. However, no we have an issue when we run re-index(only on primary server) it works fine in that server but not in other server. What is the procedure to FTS re-index in a server group environment ? We have 2 server both are configured as Server Group Indexer. Ranked the servers in Ranking form. Do we need to re-index each server ? Thanks & Regards, Jithin Radhakrishnan _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4830 / Virus Database: 4365/10744 - Release Date: 10/02/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS and Character Fields (with less than 3 characters)
That's exactly what happened. There's over 100 words on the ignore list for FTS that we have to watch out for. Luckily, these are only test accounts so I'm just going to educate the customer and not update the ignore list. Thanks! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Saturday, August 29, 2015 9:10 PM To: arslist@ARSLIST.ORG Subject: Re: FTS and Character Fields (with less than 3 characters) Is "Ar" in the ignore words list? William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Thursday, August 27, 2015 3:45 PM To: arslist@ARSLIST.ORG Subject: FTS and Character Fields (with less than 3 characters) We are using ARS 8.1 SP2, have an Oracle Database and turned on FTS. I also enabled FTS on the First and Last Name character fields on the CTM:People form. Before we enabled FTS and added the FTS property to these two fields, I was able to do a search on First Name = "Ar" and get back many records that have the characters ar in the first name INCLUDING the one record that I really need returned that the first name IS only "Ar". But when I added the FTS property to the First Name field, I get back all records with ar in the first name EXCEPT the first name that's actually Ar. Is there something with FTS that does not allow character fields with less than three characters get indexed or something? Why does this not return the record that I actually need? I've tested this with many other First Names that were less than three characters: Go, No, Ar, but I was able to create a person with a first name of Le and it found this person when doing a search. Maybe Go, No and Ar are reserved words??? Anyone else experience this? Lisa Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4830 / Virus Database: 4365/10537 - Release Date: 08/29/15 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: FTS and Character Fields (with less than 3 characters)
Is Ar in the ignore words list? William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Thursday, August 27, 2015 3:45 PM To: arslist@ARSLIST.ORG Subject: FTS and Character Fields (with less than 3 characters) We are using ARS 8.1 SP2, have an Oracle Database and turned on FTS. I also enabled FTS on the First and Last Name character fields on the CTM:People form. Before we enabled FTS and added the FTS property to these two fields, I was able to do a search on First Name = Ar and get back many records that have the characters ar in the first name INCLUDING the one record that I really need returned that the first name IS only Ar. But when I added the FTS property to the First Name field, I get back all records with ar in the first name EXCEPT the first name that's actually Ar. Is there something with FTS that does not allow character fields with less than three characters get indexed or something? Why does this not return the record that I actually need? I've tested this with many other First Names that were less than three characters: Go, No, Ar, but I was able to create a person with a first name of Le and it found this person when doing a search. Maybe Go, No and Ar are reserved words??? Anyone else experience this? Lisa Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4830 / Virus Database: 4365/10537 - Release Date: 08/29/15 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS and Character Fields (with less than 3 characters)
We are using ARS 8.1 SP2, have an Oracle Database and turned on FTS. I also enabled FTS on the First and Last Name character fields on the CTM:People form. Before we enabled FTS and added the FTS property to these two fields, I was able to do a search on First Name = Ar and get back many records that have the characters ar in the first name INCLUDING the one record that I really need returned that the first name IS only Ar. But when I added the FTS property to the First Name field, I get back all records with ar in the first name EXCEPT the first name that's actually Ar. Is there something with FTS that does not allow character fields with less than three characters get indexed or something? Why does this not return the record that I actually need? I've tested this with many other First Names that were less than three characters: Go, No, Ar, but I was able to create a person with a first name of Le and it found this person when doing a search. Maybe Go, No and Ar are reserved words??? Anyone else experience this? Lisa Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Weird FTS search results isse
Hi all - System = ARS/ITSM 8.1.02 with the FTS fortifications and hotfixes in place. We have a bizarre issue. I added a FTS index to CTM:People on the Corporate ID field. It is indexed for both FTS and MFS. We have incident management configured so that Customer ID is searching using the Corporate ID. Or, in other words, when you enter an ID in the Customer ID field in a new incident it searches CTM:People using the Corporate ID. That's an out of the box option. Without FTS turned on it works fine, but I have to search in all uppercase because that is how our ID's are stored. For example mine is something similar to this: GHTY78. With FTS turned on it's not working. I as an administrator can log in and it works for me. I can enter the first three characters of my ID in either upper or lower case and it returns two possible entries in the type-ahead list. If I enter the entire ID it finds only one result (which makes sense, since our ID's are unique). Howeverwhen I login to our test environment as a regular user and enter the same three characters (or even all 6) we get a message that says The query matched more than the maximum number of entries specified for retrieval ARWARN 66. This makes zero sense, for two reasons. First, this is a test server, and the limit set in the server configuration for Max entries returned by GetList is at 5,000,000. That's 10X the number of records in CTM:People. Second, there should only be two matches total, or one when I enter the entire thing. Plus, an administrator should see more records than a regular user or at least the same number. Never less BMC is working on it but they have not found any results yet. It's interesting to note that there are no errors in the SQL/API/Filter logs from this, so I'm starting to think it's some kind of limit on the mid-tier. However, there's still only 1 or 2 search results, depending on how you do the test. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Database reboot during FTS Reindex
Jase, The FTS reindexing finished this morning, thankfully! So I guess we still don't know for sure if a DB reboot would corrupt the index or not. Just thought I'd update you. Thanks, Thad On Wed, Feb 18, 2015 at 2:37 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Thad, my experience has been that the FTS index becomes corrupt and I have to start the whole thing over. I hope it finishes before your DB restart. Please let us know if it doesn't. I'd be interested to see if your FTS index up to the point if restart is retained. Mine are not. Thanks ~ Jase On Feb 18, 2015, at 1:20 PM, Thad Esser thad.es...@gmail.com wrote: ** Jase, So I asked BMC the same questions, and they seemed to think that the reindexing will weather the reboot fine. * How will this impact the FTS Reindex if it is still in progress? BMC : It will break your FTS Reindex for that time period. * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) BMC : Yes the Reindex should attempt to pick up from where it left off. * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? BMC : Either way, AR Server or DB being down breaks the FTS Reindex, so it doesn't matter whoever is first down. * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? BMC : We do not expect any corruption to occur, But you can enable FTS logs before server goes down to see any errors. I guess we'll see. I've got my fingers crossed that it just finishes before then so I don't have to worry about it. Thanks, Thad On Tue, Feb 17, 2015 at 3:22 PM, Jase Brandon jasebran...@gmail.com wrote: Hi Thad, short answer is you're screwed. I've been fighting this for months. There is an FTS fortification available if you're on the right version. See the link in my post I put up about 30-45 mins ago. Hope this helps - Jase On Feb 17, 2015, at 5:07 PM, Thad Esser thad.es...@gmail.com wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How will this impact the FTS reindex if it is still in progress? * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? * Or am I just screwed, and am going to have to restart the FTS indexing again after the DB reboot? Thanks, Thad Environment: ARS 8.1.0 on Windows with a remote SQL Server 2008 DB. Full 8.1 ITSM suite. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Database reboot during FTS Reindex
Jase, So I asked BMC the same questions, and they seemed to think that the reindexing will weather the reboot fine. * How will this impact the FTS Reindex if it is still in progress? BMC : It will break your FTS Reindex for that time period. * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) BMC : Yes the Reindex should attempt to pick up from where it left off. * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? BMC : Either way, AR Server or DB being down breaks the FTS Reindex, so it doesn't matter whoever is first down. * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? BMC : We do not expect any corruption to occur, But you can enable FTS logs before server goes down to see any errors. I guess we'll see. I've got my fingers crossed that it just finishes before then so I don't have to worry about it. Thanks, Thad On Tue, Feb 17, 2015 at 3:22 PM, Jase Brandon jasebran...@gmail.com wrote: Hi Thad, short answer is you're screwed. I've been fighting this for months. There is an FTS fortification available if you're on the right version. See the link in my post I put up about 30-45 mins ago. Hope this helps - Jase On Feb 17, 2015, at 5:07 PM, Thad Esser thad.es...@gmail.com wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How will this impact the FTS reindex if it is still in progress? * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? * Or am I just screwed, and am going to have to restart the FTS indexing again after the DB reboot? Thanks, Thad Environment: ARS 8.1.0 on Windows with a remote SQL Server 2008 DB. Full 8.1 ITSM suite. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Database reboot during FTS Reindex
Hi Thad, my experience has been that the FTS index becomes corrupt and I have to start the whole thing over. I hope it finishes before your DB restart. Please let us know if it doesn't. I'd be interested to see if your FTS index up to the point if restart is retained. Mine are not. Thanks ~ Jase On Feb 18, 2015, at 1:20 PM, Thad Esser thad.es...@gmail.com wrote: ** Jase, So I asked BMC the same questions, and they seemed to think that the reindexing will weather the reboot fine. * How will this impact the FTS Reindex if it is still in progress? BMC : It will break your FTS Reindex for that time period. * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) BMC : Yes the Reindex should attempt to pick up from where it left off. * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? BMC : Either way, AR Server or DB being down breaks the FTS Reindex, so it doesn't matter whoever is first down. * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? BMC : We do not expect any corruption to occur, But you can enable FTS logs before server goes down to see any errors. I guess we'll see. I've got my fingers crossed that it just finishes before then so I don't have to worry about it. Thanks, Thad On Tue, Feb 17, 2015 at 3:22 PM, Jase Brandon jasebran...@gmail.com wrote: Hi Thad, short answer is you're screwed. I've been fighting this for months. There is an FTS fortification available if you're on the right version. See the link in my post I put up about 30-45 mins ago. Hope this helps - Jase On Feb 17, 2015, at 5:07 PM, Thad Esser thad.es...@gmail.com wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How will this impact the FTS reindex if it is still in progress? * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? * Or am I just screwed, and am going to have to restart the FTS indexing again after the DB reboot? Thanks, Thad Environment: ARS 8.1.0 on Windows with a remote SQL Server 2008 DB. Full 8.1 ITSM suite. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS Fortification for 7.6.04 SP3
And another thinglater in the comments, the author discusses the fact that even with the latest patches of the latest service packs of the latest versions, you still need to run fortification, and that there is not yet a version released that handles everything in the fortification documentation automatically. On Wed, Feb 18, 2015 at 7:32 AM, Jamie jamie.bo...@transamerica.com wrote: We have completed the FTS fortification and HA setup within our 8.1.01 environment. The article states that Hotfix bundles exist only for 7.6.04 SP2+. I think LJ is correct, that within the first table, they are just referencing the minimum; therefore for SP3, you need to complete all 3 steps. If you have any doubts, you can always open a support ticket. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS Fortification for 7.6.04 SP3
We have completed the FTS fortification and HA setup within our 8.1.01 environment. The article states that Hotfix bundles exist only for 7.6.04 SP2+. I think LJ is correct, that within the first table, they are just referencing the minimum; therefore for SP3, you need to complete all 3 steps. If you have any doubts, you can always open a support ticket. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS Fortification for 7.6.04 SP3
Yep, we got caught out on this originally by believing the documentation!! From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 18 February 2015 14:43 To: arslist@ARSLIST.ORG Subject: Re: FTS Fortification for 7.6.04 SP3 ** And another thinglater in the comments, the author discusses the fact that even with the latest patches of the latest service packs of the latest versions, you still need to run fortification, and that there is not yet a version released that handles everything in the fortification documentation automatically. On Wed, Feb 18, 2015 at 7:32 AM, Jamie jamie.bo...@transamerica.com mailto:jamie.bo...@transamerica.com wrote: We have completed the FTS fortification and HA setup within our 8.1.01 environment. The article states that Hotfix bundles exist only for 7.6.04 SP2+. I think LJ is correct, that within the first table, they are just referencing the minimum; therefore for SP3, you need to complete all 3 steps. If you have any doubts, you can always open a support ticket. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Database reboot during FTS Reindex
Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How will this impact the FTS reindex if it is still in progress? * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? * Or am I just screwed, and am going to have to restart the FTS indexing again after the DB reboot? Thanks, Thad Environment: ARS 8.1.0 on Windows with a remote SQL Server 2008 DB. Full 8.1 ITSM suite. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Database reboot during FTS Reindex
Hi Thad, short answer is you're screwed. I've been fighting this for months. There is an FTS fortification available if you're on the right version. See the link in my post I put up about 30-45 mins ago. Hope this helps - Jase On Feb 17, 2015, at 5:07 PM, Thad Esser thad.es...@gmail.com wrote: ** Hello, I find myself in a situation where I have an FTS reindex in progress that I don't think will be complete by this weekend, which is when our database server will be restarted. Due to other circumstances, I can't stop the rebooting of the database server. * How will this impact the FTS reindex if it is still in progress? * Will the reindexing pick up where it left off once the DB connection is re-established? (the AR Server usually recovers just fine these days) * Would shutting down the AR Server first make things worse, or better (in terms of the re-indexing operations)? * Are there any preventative steps I can take to keep the FTS index from becoming corrupted (which seems to happen really easily and is my main concern)? * Or am I just screwed, and am going to have to restart the FTS indexing again after the DB reboot? Thanks, Thad Environment: ARS 8.1.0 on Windows with a remote SQL Server 2008 DB. Full 8.1 ITSM suite. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS Fortification for 7.6.04 SP3
Hello All, I'm interested in the FTS fortification mentioned in the below link from BMC Communities. From what I can glean - if we are on 7.6.04 SP3, then there is nothing we can do to get this Full Text Search fortification installed. Has anyone else successfully installed this who is on 7.6.04 SP3? Even though the article mentions hot fix is only available for 7.6.04 SP2, it references SP3 later in the article. Hoping someone can clear this up for me. :-) https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification Thanks, Jase Brandon 7.6.04 SP3 Oracle Dbase Linux ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS Fortification for 7.6.04 SP3
Jase, Reading the article, it mentions SP2 as a 'base', or a minimum, so if you are running SP3, then you should be able to perform all actions involved in the fortification processit's not installing anythingit's more indexing, and improving setup than anything else. On Tue, Feb 17, 2015 at 3:49 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hello All, I'm interested in the FTS fortification mentioned in the below link from BMC Communities. From what I can glean - if we are on 7.6.04 SP3, then there is nothing we can do to get this Full Text Search fortification installed. Has anyone else successfully installed this who is on 7.6.04 SP3? Even though the article mentions hot fix is only available for 7.6.04 SP2, it references SP3 later in the article. Hoping someone can clear this up for me. :-) https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification Thanks, Jase Brandon 7.6.04 SP3 Oracle Dbase Linux _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS Fortification for 7.6.04 SP3
FYI, don’t think that fortification is a one time and forget process because that’s not our experience on 8.1.1/8.1.2 After running fortification you’ll find the custom fields report empty as expected (assuming you haven’t added any fields to FTS as customisations). If you then import, say, the change form from a development environment as you migrate customisations and then re-run the fortification reports you may still get an empty custom fields report. Now restart AR server and you are likely to see many more fields in the custom fields report as the FTS characteristics of fields in the regular form have been propagated to the change join forms. According to BMC this propagation should not happen. The indexer will see these additional FTS fields and start indexing them which adds to the size of the index itself. If a field on the underlying regular form of a join (or a join of a join) form is configured for FTS then FTS will be used on searches on the join form even when the field on the join form has no FTS configuration. The result is that you need to turn off indexing before importing forms, then restart AR server, the run fortification again before turning indexing on again. Good luck! Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 17 February 2015 23:02 To: arslist@ARSLIST.ORG Subject: Re: FTS Fortification for 7.6.04 SP3 ** Jase, Reading the article, it mentions SP2 as a 'base', or a minimum, so if you are running SP3, then you should be able to perform all actions involved in the fortification processit's not installing anythingit's more indexing, and improving setup than anything else. On Tue, Feb 17, 2015 at 3:49 PM, Jase Brandon jasebran...@gmail.com mailto:jasebran...@gmail.com wrote: ** Hello All, I'm interested in the FTS fortification mentioned in the below link from BMC Communities. From what I can glean - if we are on 7.6.04 SP3, then there is nothing we can do to get this Full Text Search fortification installed. Has anyone else successfully installed this who is on 7.6.04 SP3? Even though the article mentions hot fix is only available for 7.6.04 SP2, it references SP3 later in the article. Hoping someone can clear this up for me. :-) https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification Thanks, Jase Brandon 7.6.04 SP3 Oracle Dbase Linux _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS and Temp Tables
ITSM 764 sp2, Oracle, Linux While copying our production database to development I noticed a huge difference in the number of tables. Running the following SQL select count(*) from user_tables I found there were over 7000 in production but our development server had about 5000. After doing some digging I found the difference to be in the temp tables that FTS creates, but never deletes. These all start with AR[number]CHAR[ThreadPID]. According to BMC support the system should delete them when ARS services are stopped but this is not the case, at least for 764 sp2. Support said that we can delete them at any time with impacting the application. Anybody else dealing with these temp tables? Thank you Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS and Temp Tables
Frank, I've never looked for those tables, nor had them cause an issue that I know of, so I can't provide any guidance on what to do about them. I can confirm that I have bunch (843) of them on our system as well though, so it's not just you. We are on ARS 8.1.00 no patch, Windows, SQL Server. Hope that helps. Thad On Wed, Dec 17, 2014 at 10:08 AM, Frank Caruso caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Linux While copying our production database to development I noticed a huge difference in the number of tables. Running the following SQL select count(*) from user_tables I found there were over 7000 in production but our development server had about 5000. After doing some digging I found the difference to be in the temp tables that FTS creates, but never deletes. These all start with AR[number]CHAR[ThreadPID]. According to BMC support the system should delete them when ARS services are stopped but this is not the case, at least for 764 sp2. Support said that we can delete them at any time with impacting the application. Anybody else dealing with these temp tables? Thank you Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS 8.1 Administration Questions
We had issues with FTS and 8.1. The the memory threshold would exceed the allocated limit and error. We went to 8.1.01 and set the primary/indexer java at 3072 and the secondary java at 2560. We have 2 servers, but it all depends on how many secondaries you have. The primary/indexer needs to be beefy in memory and possibly not client facing. 8.1.01, they say is more for HA, but we do notice better memory management. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS 8.1 Administration Questions
On the collection directory (we have alot of stuff) and our size is steady at 32 gigabytes On Jul 3, 2014 12:20 PM, Hynes, Douglas douglas.hy...@froedtert.com wrote: ** Greetings, Our group is beginning the testing of Knowledge Management (RKM). Of the many things this entails is nailing down the FTS configuration. The most I’ve been able to find in terms of configuring the FTS is the AR System Administration FTS Configuration Form, but this still leaves me with questions: · In a previous ARS Listing someone asked how to determine the size requirements for the BMC Software\ARSystem\ftsconfiguration\collection directory. I get that no one can really estimate this for you as it’s dependent on how much “stuff” you have in your system. My question here is: how do I get a good estimate of how much “stuff” I have. Is there a directory or a command that I can use? Should I base it off of some part of the SQL DB? How did any of you decide on what size storage to use? o Link: http://ars-action-request-system.1093659.n2.nabble.com/Recommended-size-for-FTS-index-collection-directory-td7581791.html · Occasionally, the BMC Software\ARSystem\ftsconfiguration\collection directory grows wildly and then appears to wipe old records from this folder and the size returns to something manageable. o Is this due to an auto-indexing? o Can a threshold be set on how much storage is used for the indexing? o Can a schedule be set for when it needs to dump old records (if this is even what it’s actually doing)? · If we use the failover FTS functionality recently released (in 8.1.01 I think), is it safe to assume that we’ll need this space on the backup servers as well? Cheers, -Doug Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS 8.1 Administration Questions
Greetings, Our group is beginning the testing of Knowledge Management (RKM). Of the many things this entails is nailing down the FTS configuration. The most I've been able to find in terms of configuring the FTS is the AR System Administration FTS Configuration Form, but this still leaves me with questions: * In a previous ARS Listing someone asked how to determine the size requirements for the BMC Software\ARSystem\ftsconfiguration\collection directory. I get that no one can really estimate this for you as it's dependent on how much stuff you have in your system. My question here is: how do I get a good estimate of how much stuff I have. Is there a directory or a command that I can use? Should I base it off of some part of the SQL DB? How did any of you decide on what size storage to use? o Link: http://ars-action-request-system.1093659.n2.nabble.com/Recommended-size-for-FTS-index-collection-directory-td7581791.html * Occasionally, the BMC Software\ARSystem\ftsconfiguration\collection directory grows wildly and then appears to wipe old records from this folder and the size returns to something manageable. o Is this due to an auto-indexing? o Can a threshold be set on how much storage is used for the indexing? o Can a schedule be set for when it needs to dump old records (if this is even what it's actually doing)? * If we use the failover FTS functionality recently released (in 8.1.01 I think), is it safe to assume that we'll need this space on the backup servers as well? Cheers, -Doug Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS Issue - While searching the records in the incident/problem....relationship search the records are retrieved with no bracket/background color.
Hi Team, Any helpful suggestion will be highly appreciated. Regards, Abhishek A ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS Issue - While creating a relationship within any application(IM,PM.....), the relationship search is not having the value for the Title and ID column in the search table.
** Hi Team, While creating a relationship from any incident to another incident the incident relationship search is taking place. And it is retrieving the matched records but the ID and Title column in the table is not having any value in it. FTS.jpg Any needful suggestion will be highly appreciated. Regards, Abhishek A _ARSlist: "Where the Answers Are" and have been for 20 years_
Re: FTS Issue - While creating a relationship within any application(IM,PM.....), the relationship search is not having the value for the Title and ID column in the search table.
Abhishek,What is ARS version? Check the FTS properties of Field 100161 on HPD:Help DeskFull text MFS Category Name= ArticleidIndex FOR FTS=MFS Only Index for MFS=FalseSTRIP Tag for FTS=FALSELiteral FTS Index =FALSE After Setting this properties re index Incident module Ravi Rai Date: Fri, 6 Jun 2014 05:59:23 -0400 From: abhi.masc...@gmail.com Subject: FTS Issue - While creating a relationship within any application(IM,PM.), the relationship search is not having the value for the Title and ID column in the search table. To: arslist@ARSLIST.ORG ** Hi Team, While creating a relationship from any incident to another incident the incident relationship search is taking place. And it is retrieving the matched records but the ID and Title column in the table is not having any value in it. FTS.jpg Any needful suggestion will be highly appreciated. Regards, Abhishek A _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Hi Suresh, Thanks for your kind input. I have checked the file armonitor.cfg and found two threads for FTS:- FTS Primary is enabled but FTS Secondary is commented there. So do i need to uncomment the secondary also. -Abhishek A On Mon, Jun 2, 2014 at 10:53 PM, Suresh Loganathan ersures...@gmail.com wrote: ** Can you please try armonitor.cfg file and check the any comment line mentioned into FTS service. if yes. enable the services and check the status. Regards, Suresh Loganathan On Jun 2, 2014 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Welcome. kindly check and compare the service name both primary and secondary. check any LB Name or individual server name available. Regards, Suresh Loganathan.. On Jun 3, 2014 12:17 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Suresh, Thanks for your kind input. I have checked the file armonitor.cfg and found two threads for FTS:- FTS Primary is enabled but FTS Secondary is commented there. So do i need to uncomment the secondary also. -Abhishek A On Mon, Jun 2, 2014 at 10:53 PM, Suresh Loganathan ersures...@gmail.com wrote: ** Can you please try armonitor.cfg file and check the any comment line mentioned into FTS service. if yes. enable the services and check the status. Regards, Suresh Loganathan On Jun 2, 2014 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Welcome. kindly check and compare the service name both primary and secondary. check any LB Name or individual server name available. Regards, Suresh Loganathan... ** Hi Suresh, Thanks for your kind input. I have checked the file armonitor.cfg and found two threads for FTS:- FTS Primary is enabled but FTS Secondary is commented there. So do i need to uncomment the secondary also. -Abhishek A On Mon, Jun 2, 2014 at 10:53 PM, Suresh Loganathan ersures...@gmail.com wrote: ** Can you please try armonitor.cfg file and check the any comment line mentioned into FTS service. if yes. enable the services and check the status. Regards, Suresh Loganathan On Jun 2, 2014 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Yes the server name on both the threads are same for the FTS. But the secondary FTS are commented. On Tue, Jun 3, 2014 at 12:25 PM, Suresh Loganathan ersures...@gmail.com wrote: ** Welcome. kindly check and compare the service name both primary and secondary. check any LB Name or individual server name available. Regards, Suresh Loganathan.. On Jun 3, 2014 12:17 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Suresh, Thanks for your kind input. I have checked the file armonitor.cfg and found two threads for FTS:- FTS Primary is enabled but FTS Secondary is commented there. So do i need to uncomment the secondary also. -Abhishek A On Mon, Jun 2, 2014 at 10:53 PM, Suresh Loganathan ersures...@gmail.com wrote: ** Can you please try armonitor.cfg file and check the any comment line mentioned into FTS service. if yes. enable the services and check the status. Regards, Suresh Loganathan On Jun 2, 2014 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Regarding the FTS issue on 8.1.01 ITSM server.
Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 3. Check FTS related entries in ar.conf. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
what's the value of below parameter in ar.conf? *Full-Text-Server-Name:* *I hope this name is correct.* On Mon, Jun 2, 2014 at 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Sorry i am not getting *Full-Text-Server-Name parameter in ar.conf file.* On Mon, Jun 2, 2014 at 2:55 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** what's the value of below parameter in ar.conf? *Full-Text-Server-Name: * *I hope this name is correct. * On Mon, Jun 2, 2014 at 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Where can i trace the parameter and if not found where can i mention it in ar.conf file. On Mon, Jun 2, 2014 at 3:14 PM, Abhi$hek abhi.masc...@gmail.com wrote: Sorry i am not getting *Full-Text-Server-Name parameter in ar.conf file.* On Mon, Jun 2, 2014 at 2:55 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** what's the value of below parameter in ar.conf? *Full-Text-Server-Name: * *I hope this name is correct. * On Mon, Jun 2, 2014 at 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Regarding the FTS issue on 8.1.01 ITSM server.
Can you please try armonitor.cfg file and check the any comment line mentioned into FTS service. if yes. enable the services and check the status. Regards, Suresh Loganathan On Jun 2, 2014 2:37 PM, Abhi$hek abhi.masc...@gmail.com wrote: ** Hi Mayuresh, Thanks for your kind response. PFB my inline comment for your queries. On Mon, Jun 2, 2014 at 2:21 PM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** Hi Abhishek, Check below things - 1. Is your FTS Plugin config running? YES 2. Do you see any records in ft_pending table at DB side? If you have large number of records try deleting them commit the change retry the operation. 900 records are present in FT pending so does it require any deletion operation. 3. Check FTS related entries in ar.conf. Its configured properly. 4. If you can share arftsplugin.log, ar,conf, arerror.log then it would be great. I checked all the above logs but no luck till now. Regards, Mayuresh On Mon, Jun 2, 2014 at 2:02 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Sub – Reg. the FTS issue. Steps to Reproduce – While navigating to the Server Info - FTS tab - Reindex check box. On applying the Reindex we are getting the error:- Full text indexing is disabled -- turn on full text indexing and retry your operation : 234 (ARERR 678) Analysis completed – 1. The FTS config. Is enabled in ar.conf. file and it’s a single server environment. 2. Also while navigating to the AR System config. Page - FTS Config – the config is present for the single server as required(searcher/indexer). 3. The directory for the FTS Collection/config. is also configured as required. Also no trace route in the corresponding FTS indexer/arftsindex/arerr/arftsplugin.log. Any support will be highly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 8.1.01 FTS error...
Thanks, Ravi, what we did instead is rename the folder to 'primary' so it matched the config file. It wasn't what we had initially wanted, but it does now work. rp On 3/21/2014 4:41 PM, ravi rai wrote: ** Rick check the folder Server\C\Program Files\BMC Software\ARSystem\pluginsvr\fts\primary\pluginsrvr_config.xml It contains path for FTS collection and Conf directory Ravi Date: Fri, 21 Mar 2014 14:15:04 -0700 From: r...@netfirst.com Subject: 8.1.01 FTS error... To: arslist@ARSLIST.ORG ** Hi, I've got the following error in my arjavaplugin.log: /Caused by: ERROR (8750): Create entry operations are not supported for this form.; Failed to set ar.conf entry.In method createftsprimConfiguration:D:\Program Files\BMC Software\ARSystem\pluginsvr\fts\*primary*\pluginsvr_config.xml (The system cannot find the path specified)// //at com.bmc.arsys.plugins.ftsconfig.helper.FTSConfigConfFileCreate.retrievePort(FTSConfigConfFileCreate.java:334)// //at com.bmc.arsys.plugins.ftsconfig.FTSConfigPlugin.readconfFile(FTSConfigPlugin.java:222)// //... 12 more/ This standalone server was built from a vm clone and db copy of a server in a server group. The problem is that the path to the fts pluginsvr_config.xml is not correct in the above log entry. It should read \fts\servername\pluginsvr_config.xml. Where should I make the change? Thanks, Rick _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
8.1.01 FTS error...
Hi, I've got the following error in my arjavaplugin.log: /Caused by: ERROR (8750): Create entry operations are not supported for this form.; Failed to set ar.conf entry.In method createftsprimConfiguration:D:\Program Files\BMC Software\ARSystem\pluginsvr\fts\*primary*\pluginsvr_config.xml (The system cannot find the path specified)// //at com.bmc.arsys.plugins.ftsconfig.helper.FTSConfigConfFileCreate.retrievePort(FTSConfigConfFileCreate.java:334)// //at com.bmc.arsys.plugins.ftsconfig.FTSConfigPlugin.readconfFile(FTSConfigPlugin.java:222)// //... 12 more/ This standalone server was built from a vm clone and db copy of a server in a server group. The problem is that the path to the fts pluginsvr_config.xml is not correct in the above log entry. It should read \fts\servername\pluginsvr_config.xml. Where should I make the change? Thanks, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 8.1.01 FTS error...
Rick check the folderServer\C\Program Files\BMC Software\ARSystem\pluginsvr\fts\primary\pluginsrvr_config.xml It contains path for FTS collection and Conf directory Ravi Date: Fri, 21 Mar 2014 14:15:04 -0700 From: r...@netfirst.com Subject: 8.1.01 FTS error... To: arslist@ARSLIST.ORG ** Hi, I've got the following error in my arjavaplugin.log: Caused by: ERROR (8750): Create entry operations are not supported for this form.; Failed to set ar.conf entry.In method createftsprimConfiguration:D:\Program Files\BMC Software\ARSystem\pluginsvr\fts\primary\pluginsvr_config.xml (The system cannot find the path specified) at com.bmc.arsys.plugins.ftsconfig.helper.FTSConfigConfFileCreate.retrievePort(FTSConfigConfFileCreate.java:334) at com.bmc.arsys.plugins.ftsconfig.FTSConfigPlugin.readconfFile(FTSConfigPlugin.java:222) ... 12 more This standalone server was built from a vm clone and db copy of a server in a server group. The problem is that the path to the fts pluginsvr_config.xml is not correct in the above log entry. It should read \fts\servername\pluginsvr_config.xml. Where should I make the change? Thanks, Rick _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 8.1.01 FTS error...
In server information you will see the fts tab. I think that is where you will have to change the path. On 22 Mar 2014 05:05, Rick Phillips r...@netfirst.com wrote: ** Hi, I've got the following error in my arjavaplugin.log: *Caused by: ERROR (8750): Create entry operations are not supported for this form.; Failed to set ar.conf entry.In method createftsprimConfiguration:D:\Program Files\BMC Software\ARSystem\pluginsvr\fts\primary\pluginsvr_config.xml (The system cannot find the path specified)* *at com.bmc.arsys.plugins.ftsconfig.helper.FTSConfigConfFileCreate.retrievePort(FTSConfigConfFileCreate.java:334)* *at com.bmc.arsys.plugins.ftsconfig.FTSConfigPlugin.readconfFile(FTSConfigPlugin.java:222)* *... 12 more* This standalone server was built from a vm clone and db copy of a server in a server group. The problem is that the path to the fts pluginsvr_config.xml is not correct in the above log entry. It should read \fts\servername\pluginsvr_config.xml. Where should I make the change? Thanks, Rick _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS and Remedy 8.1 in a Server Group
Hi, You can take a look here: https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_techno logies/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification I had a customer on the weekend have trouble with Re-indexing. They increased the resources to the Plugin's (4GB RAM) and had to move Escalations off to another server than the one performing the Indexing. It is recommended to stop the Escalations and Searching whilst re-indexing. _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Saji Philip Sent: 11 February 2014 23:26 To: arslist@ARSLIST.ORG Subject: FTS and Remedy 8.1 in a Server Group ** Is anyone out there installed RKM in v. 8.1.002 and in a Server Group and FTS enabled? We are having issues where the indexing is hung. I noticed there is a 8.1.01 ARS now available and it addresses some issues with FTS, but in the notes it mentioned that 'in a Server Group environment the ft_pending table may have forms that cannot be indexed' there is no fix and the workaround is blowing away that table. Indexing never stops. And while its indexing any new Knowledge articles are not searchable until I blow away that table. Our fear is that we are missing indexes if I prematurely stop indexing.. Our single server development is fine. Maybe my configuration of FTS is also wrong on my system for Server Groups. Anyone know where I can go to get more info on FTS configuration on Server Grouped environment for 8.x? _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS and Remedy 8.1 in a Server Group
Is anyone out there installed RKM in v. 8.1.002 and in a Server Group and FTS enabled? We are having issues where the indexing is hung. I noticed there is a 8.1.01 ARS now available and it addresses some issues with FTS, but in the notes it mentioned that 'in a Server Group environment the ft_pending table may have forms that cannot be indexed' there is no fix and the workaround is blowing away that table. Indexing never stops. And while its indexing any new Knowledge articles are not searchable until I blow away that table. Our fear is that we are missing indexes if I prematurely stop indexing.. Our single server development is fine. Maybe my configuration of FTS is also wrong on my system for Server Groups. Anyone know where I can go to get more info on FTS configuration on Server Grouped environment for 8.x? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
how to identify FTS-indexed fields from the DB?
Hello everyone, I currently find myself in the third circle of ARS hell ... debugging FTS on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to say, I have no immediate control of that situation). We have had an FTS re-index procedure running for more than a month now. I need to get an idea on where it is, and how much longer it needs to finish. I can trace some of this through the arftsindex.log(s). It seems to iterate per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed field 2, etc, etc cycling through every record in the form N times where N is the number of indexed columns in the form. So ... part of this is that I need to be able to know exactly how many such fields and forms I'm looking at. I need a better way of doing this than to open each form on the server, and pick through the field properties on every form. I've tried running the sql log on server startup to try and capture whatever it is the ft dispatcher executes in the DB to find the indexed fields, but if it's there I sure as heck can't find it. There do not appear to be any obvious columns on the 'FIELD' table that would indicate FTS indexing mode, nor do there appear to be any adjunct tables (like the various FIELD_* tables) that would contain this data. I'd like very much to be able to execute a query on the DB that would return schemaid and fieldid of all the fields that the FTS indexer is going to try and run through. Does anyone know of a way to do this? -Andy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
I may be fuzzy on this but there is a table called FT_Pending that holds some data on what is being indexed and then dropped once it is in the collection directory. If your indexing is running for more than a month though, I'm pretty sure it's hung and not doing anything. The size of FT_Pending should always be small if the indexing is in progress. Sent from my iPhone On May 28, 2013, at 1:47 PM, Andrew Hicox and...@hicox.com wrote: Hello everyone, I currently find myself in the third circle of ARS hell ... debugging FTS on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to say, I have no immediate control of that situation). We have had an FTS re-index procedure running for more than a month now. I need to get an idea on where it is, and how much longer it needs to finish. I can trace some of this through the arftsindex.log(s). It seems to iterate per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed field 2, etc, etc cycling through every record in the form N times where N is the number of indexed columns in the form. So ... part of this is that I need to be able to know exactly how many such fields and forms I'm looking at. I need a better way of doing this than to open each form on the server, and pick through the field properties on every form. I've tried running the sql log on server startup to try and capture whatever it is the ft dispatcher executes in the DB to find the indexed fields, but if it's there I sure as heck can't find it. There do not appear to be any obvious columns on the 'FIELD' table that would indicate FTS indexing mode, nor do there appear to be any adjunct tables (like the various FIELD_* tables) that would contain this data. I'd like very much to be able to execute a query on the DB that would return schemaid and fieldid of all the fields that the FTS indexer is going to try and run through. Does anyone know of a way to do this? -Andy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
On a previous version of FTS, I seem to recall there was a table you could query that would let you know what fields were indexed. It's either in the docs or in the online knowledge base, I bet. Also, in my limited experience (which may not apply to your situation), it seemed that rebuilding the indexes was faster than actually trying to reindex. I was on Oracle, and that was ARS 6.0 or 7.5 at the time, with maybe 250,000 records, include 2 or 3 diary fields a 0 length character field plus some smaller character fields. Directions for that were also in the knowledge base. David Durling University of Georgia -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Tuesday, May 28, 2013 1:54 PM To: arslist@ARSLIST.ORG Subject: Re: how to identify FTS-indexed fields from the DB? I may be fuzzy on this but there is a table called FT_Pending that holds some data on what is being indexed and then dropped once it is in the collection directory. If your indexing is running for more than a month though, I'm pretty sure it's hung and not doing anything. The size of FT_Pending should always be small if the indexing is in progress. Sent from my iPhone On May 28, 2013, at 1:47 PM, Andrew Hicox and...@hicox.com wrote: Hello everyone, I currently find myself in the third circle of ARS hell ... debugging FTS on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to say, I have no immediate control of that situation). We have had an FTS re-index procedure running for more than a month now. I need to get an idea on where it is, and how much longer it needs to finish. I can trace some of this through the arftsindex.log(s). It seems to iterate per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed field 2, etc, etc cycling through every record in the form N times where N is the number of indexed columns in the form. So ... part of this is that I need to be able to know exactly how many such fields and forms I'm looking at. I need a better way of doing this than to open each form on the server, and pick through the field properties on every form. I've tried running the sql log on server startup to try and capture whatever it is the ft dispatcher executes in the DB to find the indexed fields, but if it's there I sure as heck can't find it. There do not appear to be any obvious columns on the 'FIELD' table that would indicate FTS indexing mode, nor do there appear to be any adjunct tables (like the various FIELD_* tables) that would contain this data. I'd like very much to be able to execute a query on the DB that would return schemaid and fieldid of all the fields that the FTS indexer is going to try and run through. Does anyone know of a way to do this? -Andy __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
aah yes, FT_PENDING ... I had perhaps falsely presumed this was a cache mechanism to queue fields for the indexer while the indexer was busy doing things (for instance re-indexing, as it is now, or for instance to queue records if the indexer is still working on the last run at the next scan interval). I see a relatively small number of records in FT_PENDING (around 9k). However, I don't think the indexer is stuck. It is consistently writing to the collection directory (albeit excruciatingly slowly), and also it's logging like mad. It should have several million records to scan ... each with multiple indexed fields, so I would expect this to run for a while, but at the same time ... at this point, I need to get an idea of what it's doing ... how much longer it has to go. People have questions, and I don't have answers :-/ I should mention that we've taken the obvious steps of allocating more threads to the FTS RPC queue and also in the FTS plugin config. I should also mention that for a period of about a week and a half, we had some external issues which were causing the arserverd process to hang, die and restart at least twice daily ... does anyone know if arsystem restart causes an in-progress FTS re-index to dump it's work and begin again? I wonder if this could be part of our problem? By that same token I can't seem to find any obvious way to force FTS to abort a re-index procedure and begin again (presuming that's not what happens by default when you restart arsystem). thanks for the pointers to the docs and the kb guys ... I'll have another search through those. -Andy On May 28, 2013, at 12:53 PM, Tauf Chowdhury wrote: I may be fuzzy on this but there is a table called FT_Pending that holds some data on what is being indexed and then dropped once it is in the collection directory. If your indexing is running for more than a month though, I'm pretty sure it's hung and not doing anything. The size of FT_Pending should always be small if the indexing is in progress. Sent from my iPhone On May 28, 2013, at 1:47 PM, Andrew Hicox and...@hicox.com wrote: Hello everyone, I currently find myself in the third circle of ARS hell ... debugging FTS on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to say, I have no immediate control of that situation). We have had an FTS re-index procedure running for more than a month now. I need to get an idea on where it is, and how much longer it needs to finish. I can trace some of this through the arftsindex.log(s). It seems to iterate per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed field 2, etc, etc cycling through every record in the form N times where N is the number of indexed columns in the form. So ... part of this is that I need to be able to know exactly how many such fields and forms I'm looking at. I need a better way of doing this than to open each form on the server, and pick through the field properties on every form. I've tried running the sql log on server startup to try and capture whatever it is the ft dispatcher executes in the DB to find the indexed fields, but if it's there I sure as heck can't find it. There do not appear to be any obvious columns on the 'FIELD' table that would indicate FTS indexing mode, nor do there appear to be any adjunct tables (like the various FIELD_* tables) that would contain this data. I'd like very much to be able to execute a query on the DB that would return schemaid and fieldid of all the fields that the FTS indexer is going to try and run through. Does anyone know of a way to do this? -Andy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
Andy,Stop AR Server Clear Contect of Collection Directory Restart ARS and reindex from FTS tab Do this on Primary FTS server if you have Server group and start secondary FTS after starting Primary FTS and Indexing In the latest doc BMC suggest not to increase thread and go with Default settings Also Restarting AR server will not cause FTS to start again. Ravi Date: Tue, 28 May 2013 13:18:47 -0500 From: and...@hicox.com Subject: Re: how to identify FTS-indexed fields from the DB? To: arslist@ARSLIST.ORG ** aah yes, FT_PENDING ... I had perhaps falsely presumed this was a cache mechanism to queue fields for the indexer while the indexer was busy doing things (for instance re-indexing, as it is now, or for instance to queue records if the indexer is still working on the last run at the next scan interval). I see a relatively small number of records in FT_PENDING (around 9k). However, I don't think the indexer is stuck. It is consistently writing to the collection directory (albeit excruciatingly slowly), and also it's logging like mad. It should have several million records to scan ... each with multiple indexed fields, so I would expect this to run for a while, but at the same time ... at this point, I need to get an idea of what it's doing ... how much longer it has to go. People have questions, and I don't have answers :-/ I should mention that we've taken the obvious steps of allocating more threads to the FTS RPC queue and also in the FTS plugin config. I should also mention that for a period of about a week and a half, we had some external issues which were causing the arserverd process to hang, die and restart at least twice daily ... does anyone know if arsystem restart causes an in-progress FTS re-index to dump it's work and begin again? I wonder if this could be part of our problem? By that same token I can't seem to find any obvious way to force FTS to abort a re-index procedure and begin again (presuming that's not what happens by default when you restart arsystem). thanks for the pointers to the docs and the kb guys ... I'll have another search through those. -Andy On May 28, 2013, at 12:53 PM, Tauf Chowdhury wrote:I may be fuzzy on this but there is a table called FT_Pending that holds some data on what is being indexed and then dropped once it is in the collection directory. If your indexing is running for more than a month though, I'm pretty sure it's hung and not doing anything. The size of FT_Pending should always be small if the indexing is in progress. Sent from my iPhone On May 28, 2013, at 1:47 PM, Andrew Hicox and...@hicox.com wrote: Hello everyone, I currently find myself in the third circle of ARS hell ... debugging FTS on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to say, I have no immediate control of that situation). We have had an FTS re-index procedure running for more than a month now. I need to get an idea on where it is, and how much longer it needs to finish. I can trace some of this through the arftsindex.log(s). It seems to iterate per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed field 2, etc, etc cycling through every record in the form N times where N is the number of indexed columns in the form. So ... part of this is that I need to be able to know exactly how many such fields and forms I'm looking at. I need a better way of doing this than to open each form on the server, and pick through the field properties on every form. I've tried running the sql log on server startup to try and capture whatever it is the ft dispatcher executes in the DB to find the indexed fields, but if it's there I sure as heck can't find it. There do not appear to be any obvious columns on the 'FIELD' table that would indicate FTS indexing mode, nor do there appear to be any adjunct tables (like the various FIELD_* tables) that would contain this data. I'd like very much to be able to execute a query on the DB that would return schemaid and fieldid of all the fields that the FTS indexer is going to try and run through. Does anyone know of a way to do this? -Andy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
I've seen bad things happen with FTS when the server stays up so if your arserver process hung up and restarted, that could def be a problem. In order to start the indexing fresh again, you would need to stop AR, delete the contents of the collection directory and delete the data from FT_Pending. Then start. Sent from my iPhone On May 28, 2013, at 2:19 PM, Andrew Hicox and...@hicox.com wrote: ** aah yes, FT_PENDING ... I had perhaps falsely presumed this was a cache mechanism to queue fields for the indexer while the indexer was busy doing things (for instance re-indexing, as it is now, or for instance to queue records if the indexer is still working on the last run at the next scan interval). I see a relatively small number of records in FT_PENDING (around 9k). However, I don't think the indexer is stuck. It is consistently writing to the collection directory (albeit excruciatingly slowly), and also it's logging like mad. It should have several million records to scan ... each with multiple indexed fields, so I *would* expect this to run for a while, but at the same time ... at this point, I need to get an idea of what it's doing ... how much longer it has to go. People have questions, and I don't have answers :-/ I should mention that we've taken the obvious steps of allocating more threads to the FTS RPC queue and also in the FTS plugin config. I should also mention that for a period of about a week and a half, we had some external issues which were causing the arserverd process to hang, die and restart at least twice daily ... does anyone know if arsystem restart causes an in-progress FTS re-index to dump it's work and begin again? I wonder if this could be part of our problem? By that same token I can't seem to find any obvious way to force FTS to abort a re-index procedure and begin again (presuming that's not what happens by default when you restart arsystem). thanks for the pointers to the docs and the kb guys ... I'll have another search through those. -Andy On May 28, 2013, at 12:53 PM, Tauf Chowdhury wrote: I may be fuzzy on this but there is a table called FT_Pending that holds some data on what is being indexed and then dropped once it is in the collection directory. If your indexing is running for more than a month though, I'm pretty sure it's hung and not doing anything. The size of FT_Pending should always be small if the indexing is in progress. Sent from my iPhone On May 28, 2013, at 1:47 PM, Andrew Hicox and...@hicox.com wrote: Hello everyone, I currently find myself in the third circle of ARS hell ... debugging FTS on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it to say, I have no immediate control of that situation). We have had an FTS re-index procedure running for more than a month now. I need to get an idea on where it is, and how much longer it needs to finish. I can trace some of this through the arftsindex.log(s). It seems to iterate per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed field 2, etc, etc cycling through every record in the form N times where N is the number of indexed columns in the form. So ... part of this is that I need to be able to know exactly how many such fields and forms I'm looking at. I need a better way of doing this than to open each form on the server, and pick through the field properties on every form. I've tried running the sql log on server startup to try and capture whatever it is the ft dispatcher executes in the DB to find the indexed fields, but if it's there I sure as heck can't find it. There do not appear to be any obvious columns on the 'FIELD' table that would indicate FTS indexing mode, nor do there appear to be any adjunct tables (like the various FIELD_* tables) that would contain this data. I'd like very much to be able to execute a query on the DB that would return schemaid and fieldid of all the fields that the FTS indexer is going to try and run through. Does anyone know of a way to do this? -Andy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
While you've gotten some direction with FT_Pending which is good, to answer
your original question on a query for seeing what fields are currently set
to be indexed (full list)... you simply look to see what fields have FTS
attribute set. FTS will work against character, diary and attachment
fields so you just need to query those field_* tables and see where the
fullTextOptions is set to '1'.
e.g.
select schemaId, fieldId from field_char where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_diary where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_attach where fullTextOptions = '1'
If you want to use that to pull in field names and form names you can
easily build out the query to pull that in with the info provided by also
querying the field table and arschema table.
Hope this helps.
Also, to get at this info via Java API, you could have a method that looks
something this to give a CSV style output of Form Name,Field
Name,Field ID:
public static void getFTSIndexedFields() {
try {
ListString schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
System.out.println(\Schema Name\,\Field Name\,\Field ID\);
for (String schema : schemaList) {
ListField schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
for (Field field : schemaFields) {
FieldLimit fLimit = field.getFieldLimit();
if (fLimit != null) {
if (fLimit.getDataType() == Constants.AR_DATA_TYPE_CHAR)
{
if
(((CharacterFieldLimit)fLimit).getFullTextOption() == 1) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
if (((DiaryFieldLimit)fLimit).getFullTextOption() ==
1) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
if
(((AttachmentFieldLimit)fLimit).getFullTextOption() == 1) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
}
}
}
} catch (ARException e) {
System.out.println(e.getMessage());
}
}
Cheers,
On Tue, May 28, 2013 at 1:43 PM, Andrew Hicox and...@hicox.com wrote:
Hello everyone,
I currently find myself in the third circle of ARS hell ... debugging FTS
on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but
suffice it to say, I have no immediate control of that situation).
We have had an FTS re-index procedure running for more than a month now. I
need to get an idea on where it is, and how much longer it needs to finish.
I can trace some of this through the arftsindex.log(s). It seems to iterate
per-form, per-indexed field. So ... form A, indexed field 1 ... then
indexed field 2, etc, etc cycling through every record in the form N times
where N is the number of indexed columns in the form.
So ... part of this is that I need to be able to know exactly how many
such fields and forms I'm looking at.
I need a better way of doing this than to open each form on the server,
and pick through the field properties on every form.
I've tried running the sql log on server startup to try and capture
whatever it is the ft dispatcher executes in the DB to find the indexed
fields, but if it's there I sure as heck can't find it. There do not appear
to be any obvious columns on the 'FIELD' table that would indicate FTS
indexing mode, nor do there appear to be any adjunct tables (like the
various FIELD_* tables) that would contain this data.
I'd like very much to be able to execute a query on the DB that would
return schemaid and fieldid of all the fields that the FTS indexer is going
to try and run through.
Does anyone know of a way to do this?
-Andy
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
--
:wq cuga
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
EXCELLENT, dude! That's exactly what I was looking for.
Rock on!
thanks again,
-Andy
On May 28, 2013, at 1:57 PM, Curtis Gallant wrote:
**
While you've gotten some direction with FT_Pending which is good, to answer
your original question on a query for seeing what fields are currently set to
be indexed (full list)... you simply look to see what fields have FTS
attribute set. FTS will work against character, diary and attachment fields
so you just need to query those field_* tables and see where the
fullTextOptions is set to '1'.
e.g.
select schemaId, fieldId from field_char where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_diary where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_attach where fullTextOptions = '1'
If you want to use that to pull in field names and form names you can easily
build out the query to pull that in with the info provided by also querying
the field table and arschema table.
Hope this helps.
Also, to get at this info via Java API, you could have a method that looks
something this to give a CSV style output of Form Name,Field Name,Field
ID:
public static void getFTSIndexedFields() {
try {
ListString schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
System.out.println(\Schema Name\,\Field Name\,\Field ID\);
for (String schema : schemaList) {
ListField schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
for (Field field : schemaFields) {
FieldLimit fLimit = field.getFieldLimit();
if (fLimit != null) {
if (fLimit.getDataType() == Constants.AR_DATA_TYPE_CHAR) {
if (((CharacterFieldLimit)fLimit).getFullTextOption()
== 1) {
System.out.println(\ + schema + \, + \ +
field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
if (((DiaryFieldLimit)fLimit).getFullTextOption() ==
1) {
System.out.println(\ + schema + \, + \ +
field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
if (((AttachmentFieldLimit)fLimit).getFullTextOption()
== 1) {
System.out.println(\ + schema + \, + \ +
field.getName() + \, + \ + field.getFieldID() + \);
}
}
}
}
}
} catch (ARException e) {
System.out.println(e.getMessage());
}
}
Cheers,
On Tue, May 28, 2013 at 1:43 PM, Andrew Hicox and...@hicox.com wrote:
Hello everyone,
I currently find myself in the third circle of ARS hell ... debugging FTS on
ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but suffice it
to say, I have no immediate control of that situation).
We have had an FTS re-index procedure running for more than a month now. I
need to get an idea on where it is, and how much longer it needs to finish. I
can trace some of this through the arftsindex.log(s). It seems to iterate
per-form, per-indexed field. So ... form A, indexed field 1 ... then indexed
field 2, etc, etc cycling through every record in the form N times where N is
the number of indexed columns in the form.
So ... part of this is that I need to be able to know exactly how many such
fields and forms I'm looking at.
I need a better way of doing this than to open each form on the server, and
pick through the field properties on every form.
I've tried running the sql log on server startup to try and capture whatever
it is the ft dispatcher executes in the DB to find the indexed fields, but if
it's there I sure as heck can't find it. There do not appear to be any
obvious columns on the 'FIELD' table that would indicate FTS indexing mode,
nor do there appear to be any adjunct tables (like the various FIELD_*
tables) that would contain this data.
I'd like very much to be able to execute a query on the DB that would return
schemaid and fieldid of all the fields that the FTS indexer is going to try
and run through.
Does anyone know of a way to do this?
-Andy
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
--
:wq cuga
_ARSlist: Where the Answers Are and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: how to identify FTS-indexed fields from the DB?
I just took a quick look again and the query needs a slight tweak, on the
DB it will store other possible values in the fullTextOptions if some of
the other FTS options are selected, like Literal FTS Index. So instead
of = '1' you should use 0.
select schemaId, fieldId from field_char where fullTextOptions 0
UNION
select schemaId, fieldId from field_diary where fullTextOptions 0
UNION
select schemaId, fieldId from field_attach where fullTextOptions 0
On the API side, a slight change as well:
public static void getFTSIndexedFields() {
try {
ListString schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
System.out.println(\Schema Name\,\Field Name\,\Field ID\);
for (String schema : schemaList) {
ListField schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
for (Field field : schemaFields) {
FieldLimit fLimit = field.getFieldLimit();
if (fLimit != null) {
if (fLimit.getDataType() == Constants.AR_DATA_TYPE_CHAR)
{
if
(((CharacterFieldLimit)fLimit).getFullTextOption()
Constants.AR_FULLTEXT_OPTIONS_NONE) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
if (((DiaryFieldLimit)fLimit).getFullTextOption()
Constants.AR_FULLTEXT_OPTIONS_NONE) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
if
(((AttachmentFieldLimit)fLimit).getFullTextOption()
Constants.AR_FULLTEXT_OPTIONS_NONE) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
}
}
}
} catch (ARException e) {
System.out.println(e.getMessage());
}
}
On Tue, May 28, 2013 at 3:07 PM, Andrew Hicox and...@hicox.com wrote:
**
EXCELLENT, dude! That's exactly what I was looking for.
Rock on!
thanks again,
-Andy
On May 28, 2013, at 1:57 PM, Curtis Gallant wrote:
**
While you've gotten some direction with FT_Pending which is good, to
answer your original question on a query for seeing what fields are
currently set to be indexed (full list)... you simply look to see what
fields have FTS attribute set. FTS will work against character, diary and
attachment fields so you just need to query those field_* tables and see
where the fullTextOptions is set to '1'.
e.g.
select schemaId, fieldId from field_char where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_diary where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_attach where fullTextOptions = '1'
If you want to use that to pull in field names and form names you can
easily build out the query to pull that in with the info provided by also
querying the field table and arschema table.
Hope this helps.
Also, to get at this info via Java API, you could have a method that looks
something this to give a CSV style output of Form Name,Field
Name,Field ID:
public static void getFTSIndexedFields() {
try {
ListString schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
System.out.println(\Schema Name\,\Field Name\,\Field ID\);
for (String schema : schemaList) {
ListField schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
for (Field field : schemaFields) {
FieldLimit fLimit = field.getFieldLimit();
if (fLimit != null) {
if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_CHAR) {
if
(((CharacterFieldLimit)fLimit).getFullTextOption() == 1) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
if (((DiaryFieldLimit)fLimit).getFullTextOption()
== 1) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
if
(((AttachmentFieldLimit)fLimit).getFullTextOption() == 1) {
System.out.println(\ + schema + \, + \
+ field.getName() + \, + \ + field.getFieldID
Re: how to identify FTS-indexed fields from the DB?
I spent far, FAR too much time working on getting FTS to work in 7.6.03 - and
it never was stable. It would stay up for a few weeks at most and then we'd
have to re-index. From what you've said it sounds like it is hung.
Part of our problem was tied to using a server group and virtual servers.
Anyway, I got REALLY good at the restart procedure.
To restart:
1. Disable FTS Indexing on your server(s)
2. Disable Full Text Searching on your server(s)
3. Shut down your AR Server. If you have more than one ar server shut
them all down.
4. Using your favorite sql tool - delete * from FT_PENDING
5. Delete ALL files from the FT Collection directory
6. Restart the server - if you are in a server group only restart the
server who is #1 in the Operartion Ranking form for FTS
7. Uncheck the Disable FTS Indexer and hit Reindex and then Apply/OK
8. Check the index directory - make sure it is building files. Often
times when it failed on us it was within the first 5 minutes.
9. Restart other servers if applicable
10. Keep checking the AR Server Admin Form/FTS tab - when the Reindex box
has cleared itself turn off Disable Full Text Searching (aka, turn it back on)
Good luck
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Curtis Gallant
Sent: Tuesday, May 28, 2013 2:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: how to identify FTS-indexed fields from the DB?
**
I just took a quick look again and the query needs a slight tweak, on the DB it
will store other possible values in the fullTextOptions if some of the other
FTS options are selected, like Literal FTS Index. So instead of = '1' you
should use 0.
select schemaId, fieldId from field_char where fullTextOptions 0
UNION
select schemaId, fieldId from field_diary where fullTextOptions 0
UNION
select schemaId, fieldId from field_attach where fullTextOptions 0
On the API side, a slight change as well:
public static void getFTSIndexedFields() {
try {
ListString schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
System.out.println(\Schema Name\,\Field Name\,\Field ID\);
for (String schema : schemaList) {
ListField schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
for (Field field : schemaFields) {
FieldLimit fLimit = field.getFieldLimit();
if (fLimit != null) {
if (fLimit.getDataType() == Constants.AR_DATA_TYPE_CHAR) {
if (((CharacterFieldLimit)fLimit).getFullTextOption()
Constants.AR_FULLTEXT_OPTIONS_NONE) {
System.out.println(\ + schema + \, + \ +
field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
if (((DiaryFieldLimit)fLimit).getFullTextOption()
Constants.AR_FULLTEXT_OPTIONS_NONE) {
System.out.println(\ + schema + \, + \ +
field.getName() + \, + \ + field.getFieldID() + \);
}
}
else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
if (((AttachmentFieldLimit)fLimit).getFullTextOption()
Constants.AR_FULLTEXT_OPTIONS_NONE) {
System.out.println(\ + schema + \, + \ +
field.getName() + \, + \ + field.getFieldID() + \);
}
}
}
}
}
} catch (ARException e) {
System.out.println(e.getMessage());
}
}
On Tue, May 28, 2013 at 3:07 PM, Andrew Hicox
and...@hicox.commailto:and...@hicox.com wrote:
**
EXCELLENT, dude! That's exactly what I was looking for.
Rock on!
thanks again,
-Andy
On May 28, 2013, at 1:57 PM, Curtis Gallant wrote:
**
While you've gotten some direction with FT_Pending which is good, to answer
your original question on a query for seeing what fields are currently set to
be indexed (full list)... you simply look to see what fields have FTS attribute
set. FTS will work against character, diary and attachment fields so you just
need to query those field_* tables and see where the fullTextOptions is set to
'1'.
e.g.
select schemaId, fieldId from field_char where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_diary where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_attach where fullTextOptions = '1'
If you want to use that to pull in field names and form names you can easily
build out the query to pull that in with the info provided by also querying the
field table and arschema table.
Hope this helps.
Also, to get at this info via Java API, you could have a method that looks
something this to give a CSV style output of Form Name,Field Name,Field
ID
FTS
hi All, My latest assignment requires me to setup FTS for the customer. I have some questions on that front can anyone help me with that. Our environment is ARS 7.5 P004 1) Can 1 Humming bird server be shared between 2 independent AR Servers. eg. Can QA and Dev environment have same FTS search engine instance. 2) Apart from the configurations mentioned in the documentation do I need to take care of anything special? 3) Should I be setting up FTS on Production server, Archival Server or Reporting server? Production and Reporting server have past 13 months data and Archival Server will have all the data since beginning of time. Implementing FTS on production server will it be beneficial? Thanks, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS
Vikrant,BMC recommendation is to Run FTS on single machine and not run on all servers in a server group and for best performance the Conf and Collection Directory should be on the same machine which is running FTS Plugins. Check BMC documentation on FTS Thanks Ravi Rai Date: Tue, 5 Mar 2013 08:29:16 -0500 From: vkulka...@columnit.com Subject: FTS To: arslist@ARSLIST.ORG hi All, My latest assignment requires me to setup FTS for the customer. I have some questions on that front can anyone help me with that. Our environment is ARS 7.5 P004 1) Can 1 Humming bird server be shared between 2 independent AR Servers. eg. Can QA and Dev environment have same FTS search engine instance. 2) Apart from the configurations mentioned in the documentation do I need to take care of anything special? 3) Should I be setting up FTS on Production server, Archival Server or Reporting server? Production and Reporting server have past 13 months data and Archival Server will have all the data since beginning of time. Implementing FTS on production server will it be beneficial? Thanks, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS on Virtual Machines - 7.6.04
We did do this configuration - and had sketchy results. BMC did update this document though - there's a new version. We just got it from support yesterday and we will look at the recommended changes and go from there. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Monday, February 04, 2013 1:36 PM To: arslist@ARSLIST.ORG Subject: Re: FTS on Virtual Machines - 7.6.04 ** We implemented the attached recommendations from BMC for FTS in our Linux Server Group. Could barely get FTS to last more than a couple of weeks and now since implementing the recommendations it's been stable for 2 months. Simon From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Tuesday, 5 February 2013 8:28 a.m. To: arslist@ARSLIST.ORG Subject: FTS on Virtual Machines - 7.6.04 ** I've spent a LOT of time on this with BMC support and I wanted to know if anyone else had similar problems and how they fixed it. Essentially we can not get FTS to remain stable. It will always eventually crash and need to be restarted, which essentially means restarting ARS since its' a plugin. We have Suse linux servers in the server group that are VM's. The mount points where the application is installed is pretty fast NAS (SAN? one of the two) and the index files live here as well. BMC has told us - by way of Lucene, which is the underlying product - that the actual mechanism that writes to SAN/NAS drives is not good for the types of file operations which FTS does in order to do it's work. Essentially we always end up with some form of file lock or read error. In short, you have to have an actual physical drive hooked up the box to make this work. That's NOT happening in our environment. Essentially there's a problem - BMC is saying they support VM's, but FTS can use virtual disks - and it's not really BMC's fault so much as the fault of the underlying engine. Anyone else run into this? Heck, we are getting FTS errors at times when it's been turned OFF for weeks. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 _ARSlist: Where the Answers Are and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.comhttp://www.avg.com Version: 2013.0.2890 / Virus Database: 2639/6063 - Release Date: 01/28/13 Internal Virus Database is out of date. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FTS on Virtual Machines - 7.6.04
I've spent a LOT of time on this with BMC support and I wanted to know if anyone else had similar problems and how they fixed it. Essentially we can not get FTS to remain stable. It will always eventually crash and need to be restarted, which essentially means restarting ARS since its' a plugin. We have Suse linux servers in the server group that are VM's. The mount points where the application is installed is pretty fast NAS (SAN? one of the two) and the index files live here as well. BMC has told us - by way of Lucene, which is the underlying product - that the actual mechanism that writes to SAN/NAS drives is not good for the types of file operations which FTS does in order to do it's work. Essentially we always end up with some form of file lock or read error. In short, you have to have an actual physical drive hooked up the box to make this work. That's NOT happening in our environment. Essentially there's a problem - BMC is saying they support VM's, but FTS can use virtual disks - and it's not really BMC's fault so much as the fault of the underlying engine. Anyone else run into this? Heck, we are getting FTS errors at times when it's been turned OFF for weeks. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS on Virtual Machines - 7.6.04
We have used FTS on virtual AR 7.5 servers before without an issue. You are using a hard server for your DB, aren't you? Because that's a known issue for things apart from FTS. Rick On Mon, Feb 4, 2013 at 11:28 AM, William Rentfrow wrentf...@stratacominc.com wrote: ** I've spent a LOT of time on this with BMC support and I wanted to know if anyone else had similar problems and how they fixed it. ** ** Essentially we can not get FTS to remain stable. It will always eventually crash and need to be restarted, which essentially means restarting ARS since its' a plugin. ** ** We have Suse linux servers in the server group that are VM's. The mount points where the application is installed is pretty fast NAS (SAN? one of the two) and the index files live here as well. ** ** BMC has told us - by way of Lucene, which is the underlying product - that the actual mechanism that writes to SAN/NAS drives is not good for the types of file operations which FTS does in order to do it's work. Essentially we always end up with some form of file lock or read error. In short, you have to have an actual physical drive hooked up the box to make this work. ** ** That's NOT happening in our environment. ** ** Essentially there's a problem - BMC is saying they support VM's, but FTS can use virtual disks - and it's not really BMC's fault so much as the fault of the underlying engine. ** ** Anyone else run into this? Heck, we are getting FTS errors at times when it's been turned OFF for weeks. ** ** William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 ** ** _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS on Virtual Machines - 7.6.04
We implemented the attached recommendations from BMC for FTS in our Linux Server Group. Could barely get FTS to last more than a couple of weeks and now since implementing the recommendations it's been stable for 2 months. Simon From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Tuesday, 5 February 2013 8:28 a.m. To: arslist@ARSLIST.ORG Subject: FTS on Virtual Machines - 7.6.04 ** I've spent a LOT of time on this with BMC support and I wanted to know if anyone else had similar problems and how they fixed it. Essentially we can not get FTS to remain stable. It will always eventually crash and need to be restarted, which essentially means restarting ARS since its' a plugin. We have Suse linux servers in the server group that are VM's. The mount points where the application is installed is pretty fast NAS (SAN? one of the two) and the index files live here as well. BMC has told us - by way of Lucene, which is the underlying product - that the actual mechanism that writes to SAN/NAS drives is not good for the types of file operations which FTS does in order to do it's work. Essentially we always end up with some form of file lock or read error. In short, you have to have an actual physical drive hooked up the box to make this work. That's NOT happening in our environment. Essentially there's a problem - BMC is saying they support VM's, but FTS can use virtual disks - and it's not really BMC's fault so much as the fault of the underlying engine. Anyone else run into this? Heck, we are getting FTS errors at times when it's been turned OFF for weeks. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Configuring FTS for performance in a server group.docx.docx Description: Configuring FTS for performance in a server group.docx.docx
FTS on Virtual Machines - 7.6.04
William The FTS engine is Lucense, an open source project, from what I recall. Sticking lucene san storage into Google reveals a set of results that suggest is should be fine, and if I recall, Lucene uses file based locking (correct me if I'm wrong) and hence it shouldn't care about the underlying physical storage. Indeed, for a small set of documents to index, I'd expect the index to be loaded into memory and disc access to be relatively light. But I don't think we know enough to tell. You'd need to post stack traces/etc, or perhaps join the Lucene forums and ask the experts? John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS on Virtual Machines - 7.6.04
**
Hi,We also had some problems with FTS on 7.6.04 sp2 and on Windows environment.At a time, search wasn't working anymore (for example in MFS) and you had a plugin error (can't remember the arerror).I left the project before BMC support found a solution but I gave the admins a script that killed the FTS plugin (java process) and armonitor relaunched it immediately (less than 2 seconds) and search worked again right away.Not perfect but it's a way to fast resolve this problem. Perhaps it should be linked to a "live" log analysis (?).Anyway, the thing is that FTS is a Java process, the way I identify it is via the command line where you can find "pluginsvr/fts" (or something like that), you know it's that java process.Then the script killed it and let armonitor do his job.Here is the script, it's in powershell for Windows but perhaps it'll give you a hint for your environment if it's not windows (or a kill should do the trick at least for testing)://////#Killing FTS plugin 0.1#lm...@me.com#Object:#This script will detect and kill FTS plugin (will be launched again#automatically by armonitor service).#History:#0.1, 31/01/2012:#First version#Use:#Powershell Script#Note:#Distant script needs to be allowed#Launch powershell as administrator and type#Set-ExecutionPolicy RemoteSigned##-#Parameter##Log file path$Log_File ="C:\tmp\log.log"#Don't change anything below##Log functionfunction Log_Me([string]$level,[string]$msg){ #Out-File -filepath $Log_File -append -inputObject $a "$(Get-Date):: $($level) :: $($msg)" | Out-File -filepath $Log_File -append}##ScriptClear-host###FTS plugin handle$p=Get-WmiObject Win32_Process -Filter "Name like '%java%' AND CommandLine like '%\\pluginsvr\\fts;%'" | select-Object Handle###Testing query resultif($p -eq $null){ Log_Me "WARNING" "No plugin detected..." exit}###Handle$my_handle=$p.Handle$nb_found=@($p).count###Test if only one plugin detectedif ($nb_found -eq 1){ Log_Me "OK" "Stopping FTS plugin handle $($my_handle)." Stop-Process -Id $my_handle -Force Log_Me "OK" "Plugin FTS handle $($my_handle) stopped." }else{ Log_Me "ERROR" "Several plugins detected..."}exit//Laurent.On 04 Feb, 2013,at 08:28 PM, William Rentfrow wrentf...@stratacominc.com wrote:I've spent a LOT of time on this with BMC support and I wanted to know if anyone else had similar problems and how they fixed it.Essentially we can not get FTS to remain stable. It will always eventually crash and need to be restarted, which essentially means restarting ARS since its' a plugin.We have Suse linux servers in the server group that are VM's. The mount points where the application is installed is pretty fast NAS (SAN? one of the two) and the index files live here as well.BMC has told us - by way of Lucene, which is the underlying product - that the actual mechanism that writes to SAN/NAS drives is not good for the types of file operations which FTS does in order to do it's work. Essentially we always end up with some form of file lock or read error. In short, you have to have an actual physical drive hooked up the box to make this work.That's NOT happening in our environment.Essentially there's a problem - BMC is saying they support VM's, but FTS can use virtual disks - and it's not really BMC's fault so much as the fault of the underlying engine.Anyone else run into this? Heck, we are getting FTS errors at times when it's been turned OFF for weeks.William Rentfrowwrentf...@stratacominc.comOffice: 715-204-3061Cell: 715-398-5056_ARSlist: "Where the Answers Are" and have been for 20 years_**_ARSlist: "Where the Answers Are" and have been for 20 years_
FTS on Virtual Machines - 7.6.04
William I note MT8.0 contains Lucene version 2.9.2. As far as I can tell, this is at least two major releases behind the current release. Version 2.6.2 was released in February 2010 and has been superseded by two minor releases. Perhaps you should download 2.9.4 from an ftp site, or even try 3.6.2. I'm not sure what came between 2.9 and 3.6. Ref: ftp://ftp.mirrorservice.org/sites/ftp.apache.org/lucene/java/2.9.4/ Ref: ftp://ftp.mirrorservice.org/sites/ftp.apache.org/lucene/java/3.6.2/ Simply delete the lucene-*.jar files from Mid Tier WEB-INF/lib and copy the replacement jars from the relevant download. John -- JSS SSO Plugin for BMC ITS http://www.javasystemsolutions.com/jss/ssoplugin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
OT: FTS on Virtual Machines - 7.6.04 (RE ADDM)
Regarding That's NOT happening in our environment. We have had the same trouble with ADDM. BMC's ideal design is to have virtual disks for ADDMhowever a 300gb VM disk is not welcome in our environment so we use NFS. In 9.0 an disk management UI was introduced and remove the need for a manual command line process to change disk configuration. Apparently this only works for VMdisks and since we are using NFS we still need to do the manual process. Our ADDM primary admin has been working with BMC support and I think the documentation is being updated to reflect this shortcoming. Jason On Mon, Feb 4, 2013 at 11:28 AM, William Rentfrow WRentfrow@stratacominc .com wrote: ** I've spent a LOT of time on this with BMC support and I wanted to know if anyone else had similar problems and how they fixed it. ** ** Essentially we can not get FTS to remain stable. It will always eventually crash and need to be restarted, which essentially means restarting ARS since its' a plugin. ** ** We have Suse linux servers in the server group that are VM's. The mount points where the application is installed is pretty fast NAS (SAN? one of the two) and the index files live here as well. ** ** BMC has told us - by way of Lucene, which is the underlying product - that the actual mechanism that writes to SAN/NAS drives is not good for the types of file operations which FTS does in order to do it's work. Essentially we always end up with some form of file lock or read error. In short, you have to have an actual physical drive hooked up the box to make this work. ** ** That's NOT happening in our environment. ** ** Essentially there's a problem - BMC is saying they support VM's, but FTS can use virtual disks - and it's not really BMC's fault so much as the fault of the underlying engine. ** ** Anyone else run into this? Heck, we are getting FTS errors at times when it's been turned OFF for weeks. ** ** William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 ** ** _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FTS on Virtual Machines - 7.6.04
William, Rick,
Just curious, can you please tell us if you are/were mounting your SAN FS
via NFS (which version) or iSCSI (on ethernet or fiber) ?
Thanks.
Sylvain
On Mon, Feb 4, 2013 at 8:48 PM, laurent matheo lm...@me.com wrote:
**
Hi,
We also had some problems with FTS on 7.6.04 sp2 and on Windows
environment.
At a time, search wasn't working anymore (for example in MFS) and you had
a plugin error (can't remember the arerror).
I left the project before BMC support found a solution but I gave the
admins a script that killed the FTS plugin (java process) and armonitor
relaunched it immediately (less than 2 seconds) and search worked again
right away.
Not perfect but it's a way to fast resolve this problem. Perhaps it should
be linked to a live log analysis (?).
Anyway, the thing is that FTS is a Java process, the way I identify it is
via the command line where you can find pluginsvr/fts (or something like
that), you know it's that java process.
Then the script killed it and let armonitor do his job.
Here is the script, it's in powershell for Windows but perhaps it'll give
you a hint for your environment if it's not windows (or a kill should do
the trick at least for testing):
//
#Killing FTS plugin 0.1
#lm...@me.com
#Object:
#This script will detect and kill FTS plugin (will be launched again
#automatically by armonitor service).
#History:
#0.1, 31/01/2012:
#First version
#Use:
#Powershell Script
#Note:
#Distant script needs to be allowed
#Launch powershell as administrator and type
#Set-ExecutionPolicy RemoteSigned
##-
#Parameter
##Log file path
$Log_File =C:\tmp\log.log
#Don't change anything below
##Log function
function Log_Me([string]$level,[string]$msg)
{
#Out-File -filepath $Log_File -append -inputObject $a
$(Get-Date):: $($level) :: $($msg) | Out-File -filepath $Log_File -append
}
##Script
Clear-host
###FTS plugin handle
$p=Get-WmiObject Win32_Process -Filter Name like '%java%' AND CommandLine
like '%\\pluginsvr\\fts;%' | select-Object Handle
###Testing query result
if($p -eq $null)
{
Log_Me WARNING No plugin detected...
exit
}
###Handle
$my_handle=$p.Handle
$nb_found=@($p).count
###Test if only one plugin detected
if ($nb_found -eq 1)
{
Log_Me OK Stopping FTS plugin handle $($my_handle).
Stop-Process -Id $my_handle -Force
Log_Me OK Plugin FTS handle $($my_handle) stopped.
}
else
{
Log_Me ERROR Several plugins detected...
}
exit
//
Laurent.
On 04 Feb, 2013,at 08:28 PM, William Rentfrow wrentf...@stratacominc.com
wrote:
I've spent a LOT of time on this with BMC support and I wanted to know if
anyone else had similar problems and how they fixed it.
Essentially we can not get FTS to remain stable. It will always
eventually crash and need to be restarted, which essentially means
restarting ARS since its' a plugin.
We have Suse linux servers in the server group that are VM's. The mount
points where the application is installed is pretty fast NAS (SAN? one of
the two) and the index files live here as well.
BMC has told us - by way of Lucene, which is the underlying product - that
the actual mechanism that writes to SAN/NAS drives is not good for the
types of file operations which FTS does in order to do it's work.
Essentially we always end up with some form of file lock or read error. In
short, you have to have an actual physical drive hooked up the box to make
this work.
That's NOT happening in our environment.
Essentially there's a problem - BMC is saying they support VM's, but FTS
can use virtual disks - and it's not really BMC's fault so much as the
fault of the underlying engine.
Anyone else run into this? Heck, we are getting FTS errors at times when
it's been turned OFF for weeks.
William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061
Cell: 715-398-5056
_ARSlist: Where the Answers Are and have been for 20 years_
**
_ARSlist: Where the Answers Are and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: FTS search on CI Name
I found the fix for this (with BMC's help I should add) - The FT Search Threshold was set to the default of 10,000. Even though the documentation says this is the number of results that will be returned it's sort of vague. What it really means is that FTS will return this many results that might match, evaluate them, and then return your result set. In our case the total result set was only 16. However, after doing some checking in the database we were able to determine there was 21,000+ Microsoft-esque possible search results. Since our new data would be at the end of the data considered (given that it is all in one table) it looks like FTS just grabs the first possible match up to the max in the threshold prior to evaluating which ones are good matches. Upping the FT Search Threshhold to 25,000 fixed the problem. William Rentfrow wrentf...@stratacominc.commailto:wrentf...@stratacominc.com http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell From: William Rentfrow Sent: Thursday, November 15, 2012 3:36 PM To: arslist@ARSLIST.ORG Subject: FTS search on CI Name We have indexed CI Name for FTS and MFS search. This is in CMDB 7.6.04 patch 002. All searches are QBE i.e., all examples below are typed into the field, not using the Advanced Search. When a QBE search is run against this field we are getting some weird (IMHO) results. If I search for microsoft (no quotes) I get all the three word or four word phrases I'd expect, like these: Microsoft Office Professional 2007 MICROSOFT OFFICE COMMUNICATOR MICROSOFT OFFICE PROJECT ...and a few others. What does NOT show up however is two word combination entries, like: MICROSOFT LYNC I can't figure out why. The QBE value for this field is set to leading. So by default any search for that would be the functional equivalent of this: microsoft% And in fact that is what I see in the logs: the SQL log says this: Thu Nov 15 2012 09:05:32.3209 */FTS: Search request for schema ID 3158, field ID 20020, search term ((microsoft%)) Even stranger, searching for just lync DOES find it, even though the FTS search issued is lync%. This does find it (all text below literally entered as a QBE entry): [microsoft test] I'msoconfusedI understand how things are tokenized, etc. but given the search being issued it should find it. William Rentfrow wrentf...@stratacominc.commailto:wrentf...@stratacominc.com http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: FTS search on CI Name
William, I am glad that you found the solution. And, that BMC support was able to help by providing the solution! Now, one thing I did want to comment on was your discussion of leading search and FTS. It is important to note that FTS is a word search capability. What this means is that FTS is a word centric search capability. Putting abc% will find words beginning with abc not the entire contents of the field starting with abc. Although the syntax may look like a LIKE, it is not really an SQL LIKE. It will also match words that are not exact matches using stemming and thesaurus. Stemming means that it will find words with standard endings. For example if you searched for hike, it would match hike, hikes, hiking, hiked, and similar permutations. Thesaurus means that it will find words from a dictionary where you have described the words as being the same thing. This dictionary can be expanded at your site to add things that are unique to your site where two words mean the same thing. Hopefully, this explains why the lync was matched even though it was not at the start of the entire string. It WAS at the start of a word. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Tuesday, November 20, 2012 12:31 PM To: arslist@ARSLIST.ORG Subject: Re: FTS search on CI Name ** I found the fix for this (with BMC's help I should add) - The FT Search Threshold was set to the default of 10,000. Even though the documentation says this is the number of results that will be returned it's sort of vague. What it really means is that FTS will return this many results that might match, evaluate them, and then return your result set. In our case the total result set was only 16. However, after doing some checking in the database we were able to determine there was 21,000+ Microsoft-esque possible search results. Since our new data would be at the end of the data considered (given that it is all in one table) it looks like FTS just grabs the first possible match up to the max in the threshold prior to evaluating which ones are good matches. Upping the FT Search Threshhold to 25,000 fixed the problem. William Rentfrow wrentf...@stratacominc.commailto:wrentf...@stratacominc.com http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell From: William Rentfrow Sent: Thursday, November 15, 2012 3:36 PM To: arslist@ARSLIST.ORG Subject: FTS search on CI Name We have indexed CI Name for FTS and MFS search. This is in CMDB 7.6.04 patch 002. All searches are QBE i.e., all examples below are typed into the field, not using the Advanced Search. When a QBE search is run against this field we are getting some weird (IMHO) results. If I search for microsoft (no quotes) I get all the three word or four word phrases I'd expect, like these: Microsoft Office Professional 2007 MICROSOFT OFFICE COMMUNICATOR MICROSOFT OFFICE PROJECT ...and a few others. What does NOT show up however is two word combination entries, like: MICROSOFT LYNC I can't figure out why. The QBE value for this field is set to leading. So by default any search for that would be the functional equivalent of this: microsoft% And in fact that is what I see in the logs: the SQL log says this: Thu Nov 15 2012 09:05:32.3209 */FTS: Search request for schema ID 3158, field ID 20020, search term ((microsoft%)) Even stranger, searching for just lync DOES find it, even though the FTS search issued is lync%. This does find it (all text below literally entered as a QBE entry): [microsoft test] I'msoconfusedI understand how things are tokenized, etc. but given the search being issued it should find it. William Rentfrow wrentf...@stratacominc.commailto:wrentf...@stratacominc.com http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell _attend WWRUG12 www.wwrug.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
FTS search on CI Name
We have indexed CI Name for FTS and MFS search. This is in CMDB 7.6.04 patch 002. All searches are QBE i.e., all examples below are typed into the field, not using the Advanced Search. When a QBE search is run against this field we are getting some weird (IMHO) results. If I search for microsoft (no quotes) I get all the three word or four word phrases I'd expect, like these: Microsoft Office Professional 2007 MICROSOFT OFFICE COMMUNICATOR MICROSOFT OFFICE PROJECT ...and a few others. What does NOT show up however is two word combination entries, like: MICROSOFT LYNC I can't figure out why. The QBE value for this field is set to leading. So by default any search for that would be the functional equivalent of this: microsoft% And in fact that is what I see in the logs: the SQL log says this: Thu Nov 15 2012 09:05:32.3209 */FTS: Search request for schema ID 3158, field ID 20020, search term ((microsoft%)) Even stranger, searching for just lync DOES find it, even though the FTS search issued is lync%. This does find it (all text below literally entered as a QBE entry): [microsoft test] I'msoconfusedI understand how things are tokenized, etc. but given the search being issued it should find it. William Rentfrow wrentf...@stratacominc.commailto:wrentf...@stratacominc.com http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Weird FTS issue
This is ARS 7.6.04 patch 003 running on Suse linux. We have 4 systems - Dev, Test, Cat, and Production Dev and Test have about the same amount of data. Cat and Prod have about the same amount of data. Prod's index files are 5 GB Cat's index files are just under 5 GB Test's index files are about 500 MB, which fits the proportion of records to index size. Dev howeverhas 13 GB of index files! Proportionally this is around 30X larger than the other three. I've blown all of these away and re-indexed. They stay the same size. I've done some fancy SQL to compare which fields are FTS enabled in each system. They are the same. I'm completely in the dark on this one. Everything is working fine but for some reason Dev's index files are huge. All the config options, ignore list, etc are the same across all systems. William Rentfrow wrentf...@stratacominc.commailto:wrentf...@stratacominc.com http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
