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"
