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)" <[email protected]> 03/24/2008 08:44 AM Please respond to [email protected] To [email protected] 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: [email protected] > >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: [email protected] >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.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
