Thanks for the feedback, I have had faced with a similar issue - a completely different one but identical to your example : - A script does a Push Fields to a form, but gets ARERR 382. - However, the Submit filters are executed after the operation as regular. - At the end of Phase, "Canceled filter processing due to error" appears.
The .log file has the line /* UPDATE xxx SET ... /* /* ROLLBACK This totally seems to be okay, and supports your example. On the other hand, the current case has all queries seem to be executed successfully - ending with /* OK. So I cannot see why or which statement fails at all. BR, Koray On Sep 29, 5:57 pm, LJ LongWing <lj.longw...@gmail.com> wrote: > Koray, > You have your answer right there....or more than likely, somewhere earlier > up....but the result is right there. > > > /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK > > I experience this type of scenario when I issue an out of phase delete of a > record that I'm updating...here is my typical scenario > > I want to delete a record....the easiest way to do a delete is to push to > that record and set a 'delete' field to 'yes', and have a filter on that > form do a record delete if that flag is yes.... > > Well...if that filter does an out of phase delete (phase 1), when phase 2 > goes through and tries to update the last mod by and last mod date on the > record, that record doesn't exist, and as such, the db throws an error and > causes a rollback... > > I don't know what your scenario is, but something in your processing is > causing the db to throw and error and rollback the transaction. > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:arsl...@arslist.org] On Behalf Of koray > Sent: Wednesday, September 29, 2010 1:47 AM > To: arsl...@arslist.org > Subject: Re: Is there any explanation for "Canceled filter processing due to > error"? > > And here is the SQL .log file corresponding to the same process : > > > /* Tue Sep 28 2010 12:24:43.4296 */SELECT C6 FROM T904 WHERE C1 = > '000000001308884' > > /* Tue Sep 28 2010 12:24:43.4317 */OK > > /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK > > /* Tue Sep 28 2010 12:24:43.4697 */COMMIT WORK > > /* Tue Sep 28 2010 12:24:43.4705 */COMMIT WORK > > /* Tue Sep 28 2010 12:24:45.3386 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,C112,... > > /* Tue Sep 28 2010 12:24:45.3738 */OK > > On Sep 29, 10:03 am, koray <ko...@alkankoray.net> wrote: > > Hello all, > > > I have a weird issue that seems to be happening continously. Below is > > a portion from server-side filter .log file that took my attention: > > > > /* Tue Sep 28 2010 12:24:43.4127 */ End of filter processing (phase > 1) -- Operation - SET on ZZZ - AD01589874 > > > /* Tue Sep 28 2010 12:24:43.4130 */ Restart of filter processing > (phase 2) -- Operation - SET on YYY - 000000001308884 > > > /* Tue Sep 28 2010 12:24:43.4159 */ <Filter Level:0 Number Of > Filters:404> Checking "IMSA:MAIN:TASK:Task:Get WIP Task" > > > 0: Push Fields -> "IMSA:MAIN:Automated Pending:Task" > > > <deferred from filter IMSA:MAIN:TASK:Task:Get WIP Task> > > > /* Tue Sep 28 2010 12:24:43.4189 */ End of filter processing (phase > 2) -- Operation - SET on YYY - 000000001308884 > > > /* Tue Sep 28 2010 12:24:43.4710 */Canceled filter processing due to > error > > > /* Tue Sep 28 2010 12:24:45.2824 */ Start filter processing (phase > 1) -- Operation - SET on XXX - 000000001308884 > > > The message "Canceled filter processing due to error" occurs but there > > are no details for it. The whole event restarts after a delay of 2- > > to-9 seconds, as seen in this example it was only 2. > > My question would be, > > > > In which circumstances this message would appear? > > > Best Regards, > > Koray > > ___________________________________________________________________________ > ____ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > > ___________________________________________________________________________ _ > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"