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: arslist@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 at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
