RE: Phase 3 Filter action threw ARERR and deleted record from form

2018-03-07 Thread Grooms, Frederick W
>From your description, as long as nothing else but the Filter that calls the 
>Run Process is executed on Submit then the record in your staging form should 
>still be there.

This is the same methodology we use for all of our external interfaces.

-  External system inserts record in Interface/Staging form as "New" 
(Usually thru a web service)

-  On Submit filter does Run Process action to call external utility to 
change status to "Ready".  (This filter should not have the `! )

-  Filters to process data run on Modify/Merge when status is "Ready" 
(and when complete set status to "Complete")

If there is an error in processing the data the Interface/Staging record is 
still there as "New".  The other main reason we use this method is if we are 
working with a complex web service call (with child forms), this will allow the 
AR System to save the child records (in the phase 2 of the web service process 
from the external system) so they are available when we go to process the data.

Fred

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Narayanan, 
Radhika
Sent: Wednesday, March 07, 2018 8:17 AM
To: ARSList <arslist@arslist.org>
Subject: Phase 3 Filter action threw ARERR and deleted record from form

Hi,

I was under the impression that if a Phase 3 action on a submit filter met with 
ARERR error, then the submitted record will still be present on the form , will 
not get deleted or rolled back. However, I observed quite the contrary on ARS 
8.1.02.  Have you come across this before and how did you overcome?

I have a custom form on ITSM 8.1.02. Another system creates records into the 
custom form by consuming Remedy's web service [USER: webservices.user]. A 
filter on submit on the custom form has a Run process action  that executes a  
batch file. The batch file uses BMC javadataimport utility to import status 
into the same record that was just submitted [User: import.user]. Merge filters 
fire when that particular status value is set. One of the merge filters met 
with ARERR. After that the record submitted also got deleted ! Is this expected 
behavior?

> 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!" (ARERR 
> 286)
    Error while performing filter action: Error 286
    Filter "SRM:SMI:InboundTxn_inbound-notify-ack`!": No enabled 
error handler
End of filter processing (phase 1) -- Operation - MERGE on SRM:SMI:StagingForm 
- TSF13524329

*/DELETE FROM T3636 WHERE C1 = 'TSF13524329'

Thanks,
Radhika Narayanan
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist


Re: Phase 3 Filter action threw ARERR and deleted record from form

2018-03-07 Thread LJ LongWing
Radhika,
Yes it's expected behavior.  Remedy is designed so that everything that
happens during an API call is a single transaction, and if that transaction
has an error, it rolls the entire thing back.  If you don't want that you
have a few options.  You can 'handle' the error and it won't roll back
anything, or you can do some 'release pending' run-process calls which
essentially commits everything in the transaction to the db before moving
onbut that may or may not be what you intend...

On Wed, Mar 7, 2018 at 7:17 AM, Narayanan, Radhika <
radhika.naraya...@cgi.com> wrote:

> Hi,
>
>
>
> I was under the impression that if a Phase 3 action on a submit filter met
> with ARERR error, then the submitted record will still be present on the
> form , will not get deleted or rolled back. However, I observed quite the
> contrary on ARS 8.1.02.  Have you come across this before and how did you
> overcome?
>
>
>
> I have a custom form on ITSM 8.1.02. Another system creates records into
> the custom form by consuming Remedy’s web service [USER: webservices.user].
> A filter on submit on the custom form has a Run process action  that
> executes a  batch file. The batch file uses BMC javadataimport utility to
> import status into the same record that was just submitted [User:
> import.user]. Merge filters fire when that particular status value is set.
> One of the merge filters met with ARERR. After that the record submitted
> also got deleted ! Is this expected behavior?
>
>
>
> > 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!"
> (ARERR 286)
>
>
>   >   Error while performing filter action:
> Error 286
>
>
>   >   Filter 
> > "SRM:SMI:InboundTxn_inbound-notify-ack`!":
> No enabled error handler
>
> End of filter processing (phase 1) -- Operation - MERGE on
> SRM:SMI:StagingForm - TSF13524329
>
>
>
> */DELETE FROM T3636 WHERE C1 = 'TSF13524329'
>
>
>
> *Thanks,*
>
> *Radhika Narayanan*
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist


Phase 3 Filter action threw ARERR and deleted record from form

2018-03-07 Thread Narayanan, Radhika
Hi,

I was under the impression that if a Phase 3 action on a submit filter met with 
ARERR error, then the submitted record will still be present on the form , will 
not get deleted or rolled back. However, I observed quite the contrary on ARS 
8.1.02.  Have you come across this before and how did you overcome?

I have a custom form on ITSM 8.1.02. Another system creates records into the 
custom form by consuming Remedy's web service [USER: webservices.user]. A 
filter on submit on the custom form has a Run process action  that executes a  
batch file. The batch file uses BMC javadataimport utility to import status 
into the same record that was just submitted [User: import.user]. Merge filters 
fire when that particular status value is set. One of the merge filters met 
with ARERR. After that the record submitted also got deleted ! Is this expected 
behavior?

> 1: Push Fields -> "SRM:SMI:InboundTxn_inbound-notify-ack`!" (ARERR 
> 286)
    Error while performing filter action: Error 286
    Filter "SRM:SMI:InboundTxn_inbound-notify-ack`!": No enabled 
error handler
End of filter processing (phase 1) -- Operation - MERGE on SRM:SMI:StagingForm 
- TSF13524329

*/DELETE FROM T3636 WHERE C1 = 'TSF13524329'

Thanks,
Radhika Narayanan
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist