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
