As several people suggested, the problem seemed to be in the "Run If" of "'TR.Status' = "Completed"" causing an endless loop.
That would only make sense if the filter were setting the value to "Completed", but all it is doing is sending an email. But I changed "Run If" to "'Status' = "Completed" AND 'DB.Status != "Completed"", and that seems to have fixed it. I don't understand WHY it fixed it, but is seems to have done so. Thanks everyone, Dwayne Martin ---- Original message ---- >Date: Mon, 24 Mar 2008 13:15:14 -0400 (EDT) >From: Dwayne Martin <[EMAIL PROTECTED]> >Subject: Re: Runaway filter >To: arslist@ARSLIST.ORG > >All the emails go to the same person, the assignee. > >Another things that puzzles me; why is "Send Message" set to "No"? I'm glad >it is or the poor assignee would have actually gotten those 100 emails. > >Dwayne > >---- Original message ---- >>Date: Mon, 24 Mar 2008 11:55:29 -0500 >>From: "Opela, Gary L Contr OC-ALC/ITMA" <[EMAIL PROTECTED]> >>Subject: Re: Runaway filter >>To: arslist@ARSLIST.ORG >> >>Thad is correct. If you put a numerical value in the assigned to field, >>and you send an email to $assigned to$, then everyone that has the group >>name that translates to that group ID will receive the email. >> >>I've seen this happen a few times, thankfully users would generally put >>a '1' in the assigned to field, so only members of the administrator >>group would receive an email. >> >>It is advisable to put some kind of checking on the filter side on your >>fields like this to avoid it. >> >>Thanks, >> >> >>Gary Opela, Jr >> >>Sr. Remedy Developer >> >>RSP Certified >> >>Leader Communications, Inc. >> >>405 736 3211 >> >> >>-----Original Message----- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser >>Sent: Monday, March 24, 2008 11:47 AM >>To: arslist@ARSLIST.ORG >>Subject: Re: Runaway filter >> >>** >>Gary beat me to it, but your first issue is using the TR value. Don't. >> >>Also, I seem to recall reading that if you put a dash/hyphen in the >>"To:" field (or was it a 0), it would send the email to all users. I've >>never experienced this, so I'm a little light on the details, but maybe >>somebody else could expound on it. That seems to match your symptom of >>sending emails to an unexpectedly high number of users. >> >>Thad Esser >>Remedy Developer >>"Argue for your limitations, and sure enough, they're yours."-- Richard >>Bach >> >> >> >>"Dwayne Martin" <[EMAIL PROTECTED]> >>Sent by: "Action Request System discussion list(ARSList)" >><arslist@ARSLIST.ORG> >> >>03/24/2008 08:44 AM >>Please respond to >>arslist@ARSLIST.ORG >> >>To >>arslist@ARSLIST.ORG >>cc >>Subject >>Re: Runaway filter >> >> >> >> >> >> >>Thanks, William, >> >>We did have the problem of duplicate emails before upgrading to 7.1, but >>that was just two, or once in a great while, three copies. This is >>about 100, followed by a core dump. >> >>Yes, we did rename "Status" to "Remedy Status" to keep it separate from >>the other "Statuses". Maybe that has something to do with it. >> >>Dwayne >> >>---- Original message ---- >>>Date: Mon, 24 Mar 2008 09:58:10 -0500 >>>From: William Rentfrow <[EMAIL PROTECTED]> >>>Subject: Re: Runaway filter >>>To: arslist@ARSLIST.ORG >>> >>>I'm not sure how you are setup to send messages - specifically how your >>workflow is structured to email the person - but there was a bug in >>earlier versions of 7.x (prior to 7.1) where users would occassionally >>multiple copies of emails. This sounds like something similar. >>> >>>One thing to check though - did you rename the core "Status" field to >>something else? You could be causing some internal workflow conflicts. >>> >>>William Rentfrow >>>Principal Consultant, StrataCom >>>[EMAIL PROTECTED] >>>O 952-432-0227 >>>C 701-306-6157 >>> >>>________________________________ >>> >>>From: Action Request System discussion list(ARSList) on behalf of >>Dwayne Martin >>>Sent: Mon 3/24/2008 9:36 AM >>>To: arslist@ARSLIST.ORG >>>Subject: Runaway filter >>> >>> >>> >>>Hello Everyone, >>> >>>Here is a problem that you would expect on Halloween, not Easter. It >>appeared on Friday, and now has disappeared. >>> >>>We have a "Request" form, with a filter that emails the assignee >>whenever the "Status" changes to "Completed." ("Status" is a regular >>char field, not the core Status.) We also have an "Authorization" >>sub-file form which allows special people to authorize or reject the >>request. >>> >>>On Friday it suddenly happened that whenever I created an >>"Authorization" entry, or Authorized or Rejected an entry, the system >>hung for about ten seconds, created a core dump, and churned about a >>hundred AR System Email Messages entries to the assignee saying that the >>Request had been closed. Fortunately "Send email" was set to "No" so >>nobody got flooded with the emails. >>> >>>This happened in both our test and live ARS Systems, but it would >>happen to some entries, not others. The ones it happened to seemed to >>have no characteristics distinguishing them from those it didn't' happen >>to. The filter runs if "TR.Status = "Completed." Some of the offending >>entries were already "Completed," and some weren't. Creating >>"Authorization" entries or Authorizing or Rejecting them shouldn't have >>triggered the filter at all, let alone send it spinning into a cycle. >>> >>>There were no entries at all in the filter log, or any other error log. >>> >>>I came in early this morning to work on the problem, and behold! it has >>vanished. I can't get it to happen. Our AR System re-starts every nite >>so maybe that cured it. But problems that vanish mysteriously can also >>reappear mysteriously. >>> >>>Any idea what to look for if this should happen again. >>> >>>(ARS 7.1 no patch, Oracle 10.2 db) >>> >>>Dwayne Martin >>>James Madison University >>> >>>_______________________________________________________________________ >>________ >>>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >>________________________________________________________________________ >>_______ >>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >> >> >> >>***IMPORTANT NOTICE: This communication, including any attachment, >>contains information that may be confidential or privileged, and is >>intended solely for the entity or individual to whom it is addressed. If >>you are not the intended recipient, you should delete this message and >>are hereby notified that any disclosure, copying, or distribution of >>this message is strictly prohibited. Nothing in this email, including >>any attachment, is intended to be a legally binding signature.*** >> >> >>__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>html___ >> >>_______________________________________________________________________________ >>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"