<div>Hi Rick,Sarawana and all,</div>
<div> </div>
<div>Thanks for your inputs. I have executed SWN_SELSEN in background for the first time,as per your inputs may be this program will take a lot of time for the first time but going forward after the first run I assume and wish this program should consume less time.<br>
<br></div>
<div class="gmail_quote">On Thu, Aug 19, 2010 at 12:04 AM, Rick Bakker <span dir="ltr"><<a href="mailto:rbakker@gmail.com">rbakker@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hello,<br><br>Earlier this year, Florin Wach (who I believe had the same problem)<br>wrote in this mailing list:<br>
<br><quote><br>I'm already using only DELTA filters, although there is an ALL_FULL<br>filter, but this is not checked at the selection, so it's there, but<br>it's not active.<br><br>I have debugged down to the SELECT statement and tracked back to where<br>
the timestamp was read. In fact, although the DELTA filter was used,<br>the ALL_FULL still throws in between (probably, when the DELTA filter<br>has no timestamp set itself).<br><br>With the hint from Rick I could manually create a time stamp entry for<br>
DELTA, using the ABAP OO class CL_SWN_FILTER, create an instance,<br>execute method LOAD_INSTANCE, use ID=WORKLOW, SCENARIO=STANDARD (or<br>whatever was appropriate), then select the interface IF_SWN_FILTER and<br>execute method SET_LAST_APPLIED and... e voila ... enter the TimeStamp<br>
number here. (I have written a small report to run in the D-System to<br>write the timestamp to copy it into that field. It's basically the<br>exact format, Rick gave).<br><unquote><br><br>I hope it helps.<br>
<div class="im"><br>regards<br>Rick Bakker<br>Hanabi Technology<br><br><br></div>
<div>
<div></div>
<div class="h5">On Wed, Aug 18, 2010 at 12:40 PM, Vijayakumar, Sarawana K<br><<a href="mailto:Sarawana.Vijayakumar@energyeast.com">Sarawana.Vijayakumar@energyeast.com</a>> wrote:<br>> Following is some information I learned when I faced this problem. Hope it helps other users.<br>
><br>> As everyone might know, a timeout occurs at the select statement indicated in the dump Srinivas had given in earlier posts.<br>><br>> Whenever SWN_SELSEN is run, it looks at entries in table SWN_TIMESTAMPS to see when the program was run last for a given delivery schedule/filter/selection schedule. If the program is being called for the first time then there is no entry in this table and the timestamp is set to all zeros. In such a case, a sequential read of the SWWLOGHIST table will be done to get work items created after the timestamp in hand (which is all zeros). So depending upon the number of entries in table SWWLOGHIST it will take a long time. And thanks to the inner join on the SWWWIHEAD in the same select statement, it takes even longer than that!<br>
><br>> But once this program runs successfully, the time is recorded in the SWN_TIMESTAMPS table for the given delivery schedule/selection/filter. And when it runs the next time it selects WIs from SWWLOGHIST which were created only after this timestamp.<br>
><br>> In sandbox system I was able to run this program in debug mode and change the timestamp at the select statement to a very recent time (like right now!) and allowed the rest of the program to run. It completed in a jiffy. The next time I ran the program, no problems, it completes within seconds. My development has not been in QA or PRD, and I know going in debug mode is not an option.<br>
><br>> But if any user can give me a way to update the timestamp, it will put an end to this problem.<br>><br>> Thank you,<br>> -Sarawana<br>><br>><br>><br>> -----Original Message-----<br>> From: <a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a> [mailto:<a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a>] On Behalf Of <a href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>
> Sent: Wednesday, August 18, 2010 12:06 PM<br>> To: <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>> Subject: SAP-WUG Digest, Vol 69, Issue 36<br>><br>> Send SAP-WUG mailing list submissions to<br>
> <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>><br>> To subscribe or unsubscribe via the World Wide Web, visit<br>> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
> or, via email, send a message with subject or body 'help' to<br>> <a href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>><br>> You can reach the person managing the list at<br>
> <a href="mailto:sap-wug-owner@mit.edu">sap-wug-owner@mit.edu</a><br>><br>> When replying, please edit your Subject line so it is more specific<br>> than "Re: Contents of SAP-WUG digest..."<br>
><br>><br>> Today's Topics:<br>><br>> 1. SWN_SELSEN dump (Karl Nietz)<br>><br>><br>> ----------------------------------------------------------------------<br>><br>> Message: 1<br>> Date: Wed, 18 Aug 2010 11:44:31 +1100<br>
> From: Karl Nietz <<a href="mailto:knietz@csc.com.au">knietz@csc.com.au</a>><br>> Subject: SWN_SELSEN dump<br>> To: <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>> Message-ID:<br>> <<a href="mailto:OF8503395E.9040788E-ONCA257783.0003E141-CA257783.0004142E@csc.com">OF8503395E.9040788E-ONCA257783.0003E141-CA257783.0004142E@csc.com</a>><br>
> Content-Type: text/plain; charset="us-ascii"<br>><br>> Hi,<br>> Check the size of the workflow log history file. If it is massive then<br>> this can cause this error. You may wish to experiment by running the<br>
> program with the Delta filter only. Or run archiving to reduce the size<br>> of the file.<br>><br>> Karl Nietz<br>><br>> Check this note<br>> Note 1105696 - WF Notif: Memory consumption and performance of SWN_SELSEN<br>
><br>> Regards,<br>> Imthiaz<br>><br>> -----Original Message-----<br>> From: <a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a> [mailto:<a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a>] On Behalf<br>
> Of<br>> <a href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>> Sent: Tuesday, August 17, 2010 2:45 PM<br>> To: <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>> Subject: SAP-WUG Digest, Vol 69, Issue 33<br>
><br>> Send SAP-WUG mailing list submissions to<br>> <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>><br>> To subscribe or unsubscribe via the World Wide Web, visit<br>> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
> or, via email, send a message with subject or body 'help' to<br>> <a href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>><br>> You can reach the person managing the list at<br>
> <a href="mailto:sap-wug-owner@mit.edu">sap-wug-owner@mit.edu</a><br>><br>> When replying, please edit your Subject line so it is more specific<br>> than "Re: Contents of SAP-WUG digest..."<br>
><br>><br>> Today's Topics:<br>><br>> 1. SWN_SELSEN going to dump (srinivas)<br>> 2. SWN_SELSEN dump result (srinivas)<br>> 3. Re: SWN_SELSEN dump result (Rick Bakker)<br>> 4. Re: SWN_SELSEN dump result (srinivas)<br>
><br>><br>> ----------------------------------------------------------------------<br>><br>> Message: 1<br>> Date: Tue, 17 Aug 2010 22:05:44 +0530<br>> From: srinivas <<a href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>
> Subject: SWN_SELSEN going to dump<br>> To: "SAP Workflow Users' Group" <<a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>><br>> Message-ID:<br>> <AANLkTimgn-3SOuV2XFr5RCra7+gB9OR+_-=<a href="mailto:X3xC547y_@mail.gmail.com">X3xC547y_@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="iso-8859-1"<br>><br>> Hi All,<br>><br>> While executing the report SWN_SELSEN (extended notifications) via batch<br>> job<br>> or manually the report is going to dump.Can someone tell me what are the<br>
> possible causes for the dump in SWN_SELSEN??Actually I dont have dump file<br>> at the moment,this issue is happening in production server.<br>><br>> --<br>> Thanks and Regards<br>> Srini..<br>> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>> URL:<br>> <a href="http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/8bcbfbd8/attac" target="_blank">http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/8bcbfbd8/attac</a><br>
><br>> hment-0001.htm<br>><br>> ------------------------------<br>><br>> Message: 2<br>> Date: Tue, 17 Aug 2010 23:04:06 +0530<br>> From: srinivas <<a href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>
> Subject: SWN_SELSEN dump result<br>> To: "SAP Workflow Users' Group" <<a href="mailto:sap-wug@MIT.EDU">sap-wug@MIT.EDU</a>><br>> Message-ID:<br>> <<a href="mailto:AANLkTikKNvHRDLvJxBwObAOGnAMn1b0a3p4S%2B9n283GX@mail.gmail.com">AANLkTikKNvHRDLvJxBwObAOGnAMn1b0a3p4S+9n283GX@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="iso-8859-1"<br>><br>> Hi All,<br>><br>> Below is the dump result when the report SWN_SELSEN is executed. Does this<br>> issue related to memory??<br>><br>
><br>> Memory consumption<br>> Roll.... 16192<br>> EM...... 12569520<br>> Heap.... 0<br>> Page.... 90112<br>> MM Used. 2145408<br>> MM Free. 2041808<br>><br>> --<br>> Thanks and Regards<br>
> Srini..<br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>> URL:<br>> <a href="http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/2578f7f7/attac" target="_blank">http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/2578f7f7/attac</a><br>
><br>> hment-0001.htm<br>><br>> ------------------------------<br>><br>> Message: 3<br>> Date: Tue, 17 Aug 2010 13:01:40 -0500<br>> From: Rick Bakker <<a href="mailto:rbakker@gmail.com">rbakker@gmail.com</a>><br>
> Subject: Re: SWN_SELSEN dump result<br>> To: "SAP Workflow Users' Group" <<a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>><br>> Message-ID:<br>> <AANLkTikZGSUyM8GwXfFc+kecQsDGHz9UX+=<a href="mailto:R53TYH_6F@mail.gmail.com">R53TYH_6F@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset=ISO-8859-1<br>><br>> Hello,<br>><br>> Doesn't the dump show any sort of error?<br>><br>> Has it been working in the past?<br>> Check also SLG1.<br>><br>> regards<br>
> Rick Bakker<br>> Hanabi Technology<br>><br>> On Tue, Aug 17, 2010 at 12:34 PM, srinivas <<a href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>> wrote:<br>>><br>>> Hi All,<br>
>><br>>> Below is the dump result when the report SWN_SELSEN is executed. Does<br>> this<br>>> issue related to memory??<br>>><br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>
> URL: <a href="http://mailman.mit.edu/pipermail/sap-wug/attachments/20100818/0f46b8dc/attachment-0001.htm" target="_blank">http://mailman.mit.edu/pipermail/sap-wug/attachments/20100818/0f46b8dc/attachment-0001.htm</a><br>
><br>> ------------------------------<br>><br>> _______________________________________________<br>> SAP-WUG mailing list<br>> <a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
><br>><br>> End of SAP-WUG Digest, Vol 69, Issue 36<br>> ***************************************<br>><br>> _______________________________________________<br>> SAP-WUG mailing list<br>> <a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>><br><br>_______________________________________________<br>SAP-WUG mailing list<br>
<a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br></div></div></blockquote></div><br><br clear="all">
<br>-- <br>Thanks and Regards<br>Srini..<br>SAP Technical Consultant<br><a href="mailto:srinivasa.reddy.oota@sap.com">srinivasa.reddy.oota@sap.com</a><br>+919886760677<br><br>