Richard,
If its an escalation doing a set fields, look at the ones that are tied to
the "AAS:ActivityInterface_Create" form, and then pay attention to the
filters that might be triggered. (use your logs)
If its an escalation doing a push fields, the following Oracle SQL will
help you find which ones are pushing values to the
"AAS:ActivityInterface_Create" form.
------------------------------
select s.name Form, e.name Escalation, decode
(e.firetmtype,1,'Interval',2,'Time') Type, e.queryshort || e.querylong
RunIf, sf.actionindex, sf.fieldid fieldidPushed, sf.assignshort ||
sf.assignlong PushAssign
from escalation e, escal_mapping em, arschema s, filter_push sf
where e.escalationid = em.escalationid
and em.schemaid = s.schemaid
and e.escalationid = sf.filterid
and e.enable = 1
and (sf.assignshort || sf.assignlong like '%\AAS:ActivityInterface_Create
\%') //form name in push fields
------------------------------
(the usual caveats apply when digging around at the db level)
Hope that helps.
Thad Esser
Remedy Developer
"Now... Just where did I put that cheese...?"
|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|LJ Longwing <lj.longw...@gmail.com>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|arslist@ARSLIST.ORG
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|09/10/2009 12:09 PM
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Re: Strange errors...help appreciated....
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
**
You have an escalation that's firing, from the looks of it at 5 after
midnight. It is likely doing a set which is causing a push via filter, or
it is doing a push that's causing the error defined.
From: Action Request System discussion list(ARSList) [
mailto:arsl...@arslist.org] On Behalf Of copits.rich...@bwc.state.oh.us
Sent: Thursday, September 10, 2009 11:44 AM
To: arslist@ARSLIST.ORG
Subject: Strange errors...help appreciated....
**
Each day we seem to be getting the 4 error lines shown below right after
midnight. There is no one here to
be on the system to be doing anything. These errors are in arerror.log and
occur at the same time each day.
There aren’t any errors in any of the other log files. Any
suggestions/help/information on what might be
causing these errors? We’re stumped… Thanks!!
Thu Sep 10 00:05:02 2009 390603 : Required field (without a default) not
specified : AAS:ActivityInterface_Create : Company (ARERR 307)
Thu Sep 10 00:05:02 2009 390603 : Required field (without a default) not
specified : AAS:ActivityInterface_Create : First Name (ARERR 307)
Thu Sep 10 00:05:02 2009 390603 : Required field (without a default) not
specified : AAS:ActivityInterface_Create : Last Name (ARERR 307)
Thu Sep 10 00:05:02 2009 390603 : : Required field (without a default)
not specified : Location Company* (ARERR 45649)
Portions of this message may be confidential under an exemption to Ohio's
public records law or under a legal privilege. If you have received this
message in error or due to an unauthorized transmission or interception,
please delete all copies from your system without disclosing, copying, or
transmitting this message. _Platinum Sponsor: rmisoluti...@verizon.net
ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net 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.
*
