I did a search on the field number, cross referencing 'ARS' and came up with the following link:
http://communities.bmc.com/communities/message/80194#80194 The label for field 200000020 is 'Name', at least in this particular instance referenced in the message above. that might help narrow the search. --- On Sat, 5/30/09, Tim Widowfield <tim_widowfi...@yahoo.com> wrote: From: Tim Widowfield <tim_widowfi...@yahoo.com> Subject: Re: ARERR [311] Field ID is not related to this form : 200000020 To: arslist@ARSLIST.ORG Date: Saturday, May 30, 2009, 11:40 AM ** Since you've searched the field database table and all the form tables, it's time to direct your attention to workflow. Can an active link or filter refer to a field ID and without that reference appearing in a log? Of course. This is Remedy. If I were in your shoes, I'd export a definition dump of all my workflow, and then open it in a text editor (plug for Vim and gVim here) and search for the field ID. Now you need to play master detective and start the process of elimination. No matter where you find the field ID, open up the workflow object in the Admin tool and start editing. It could be lurking in a set fields action, a get fields query, a run if qualification, a PERFORM-ACTION process, etc. If you open up that workflow definition file and find nothing, cast your net farther and dump all your forms into a def file. An orphan field ID could be hiding in a table field query. If you strike out after all that, then maybe the problem is local. Delete all your ARF and ARV files, and log back in to your AR Server. Try doing the same operations from a different PC. Try it from Mid Tier. The nice thing about Remedy is the possibilities are practically endless. --Tim From: Dwayne Martin <marti...@jmu.edu> To: arslist@ARSLIST.ORG Sent: Friday, May 29, 2009 3:09:21 PM Subject: Re: [ARSLIST] ARERR [311] Field ID is not related to this form : 200000020 Thanks, but I've run Active Link and Filter logs, and there is no workflow triggered that references 200000020. Dwayne ---- Original message ---- >Date: Fri, 29 May 2009 15:26:36 -0400 >From: rem...@arutilities.com >Subject: Re: ARERR [311] Field ID is not related to this form : 200000020 >To: arslist@ARSLIST.ORG > >Is any additional workflow being triggered on Display, Window Open, Search >etc.. If so, perhaps one of those is referencing that field. > >> Dear List, >> >> I have a form (Form A) with 20,000 records. I can open the form in the >> client User tool, and run an unqualified query and retrieve all records. >> On Form B and C I have buttons that call Active Links, which are supposed >> to open particular records in Form A. But instead I get the above error- >> usually. >> >> On Form B there is a character field, and a button that calls a link that >> opens the single record in Form A that matches the character field. That >> button/link works. >> >> If I click a button that should display 35 records I get the error.. But >> I can display each of the 35 records one at a time by pasting the value in >> the character field and clicking button that opens the matching record. >> >> I checked the BMC Knowledge Base and found an entry about an “embedded >> query.â€・ 200000020 is the “Nameâ€・ fieldid in the Asset Management >> module, which we have. So somewhere in our set-up there must be a >> reference to this “Nameâ€・ field. But I’ve checked the Database data >> for every field on the form, as well as the form itself. >> >> There is no error or reference to 200000020 in the Active Link, Filter, or >> SQL logs. There are no tables with references to 200000020 . >> >> Any suggestions? >> >> Dwayne Martin >> James Madison University >> >> (ARS 7.1 p 3, RH Linux Server, Oracle 10.2 db) >> >> >> >> >> > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"