SWN_SELSEN dump problem
Rick Bakker
rbakker at gmail.com
Wed Aug 18 14:34:52 EDT 2010
Hello,
Earlier this year, Florin Wach (who I believe had the same problem)
wrote in this mailing list:
<quote>
I'm already using only DELTA filters, although there is an ALL_FULL
filter, but this is not checked at the selection, so it's there, but
it's not active.
I have debugged down to the SELECT statement and tracked back to where
the timestamp was read. In fact, although the DELTA filter was used,
the ALL_FULL still throws in between (probably, when the DELTA filter
has no timestamp set itself).
With the hint from Rick I could manually create a time stamp entry for
DELTA, using the ABAP OO class CL_SWN_FILTER, create an instance,
execute method LOAD_INSTANCE, use ID=WORKLOW, SCENARIO=STANDARD (or
whatever was appropriate), then select the interface IF_SWN_FILTER and
execute method SET_LAST_APPLIED and... e voila ... enter the TimeStamp
number here. (I have written a small report to run in the D-System to
write the timestamp to copy it into that field. It's basically the
exact format, Rick gave).
<unquote>
I hope it helps.
regards
Rick Bakker
Hanabi Technology
On Wed, Aug 18, 2010 at 12:40 PM, Vijayakumar, Sarawana K
<Sarawana.Vijayakumar at energyeast.com> wrote:
> Following is some information I learned when I faced this problem. Hope it helps other users.
>
> As everyone might know, a timeout occurs at the select statement indicated in the dump Srinivas had given in earlier posts.
>
> 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!
>
> 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.
>
> 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.
>
> But if any user can give me a way to update the timestamp, it will put an end to this problem.
>
> Thank you,
> -Sarawana
>
>
>
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of sap-wug-request at mit.edu
> Sent: Wednesday, August 18, 2010 12:06 PM
> To: sap-wug at mit.edu
> Subject: SAP-WUG Digest, Vol 69, Issue 36
>
> Send SAP-WUG mailing list submissions to
> sap-wug at mit.edu
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mailman.mit.edu/mailman/listinfo/sap-wug
> or, via email, send a message with subject or body 'help' to
> sap-wug-request at mit.edu
>
> You can reach the person managing the list at
> sap-wug-owner at mit.edu
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of SAP-WUG digest..."
>
>
> Today's Topics:
>
> 1. SWN_SELSEN dump (Karl Nietz)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 18 Aug 2010 11:44:31 +1100
> From: Karl Nietz <knietz at csc.com.au>
> Subject: SWN_SELSEN dump
> To: sap-wug at mit.edu
> Message-ID:
> <OF8503395E.9040788E-ONCA257783.0003E141-CA257783.0004142E at csc.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi,
> Check the size of the workflow log history file. If it is massive then
> this can cause this error. You may wish to experiment by running the
> program with the Delta filter only. Or run archiving to reduce the size
> of the file.
>
> Karl Nietz
>
> Check this note
> Note 1105696 - WF Notif: Memory consumption and performance of SWN_SELSEN
>
> Regards,
> Imthiaz
>
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
> Of
> sap-wug-request at mit.edu
> Sent: Tuesday, August 17, 2010 2:45 PM
> To: sap-wug at mit.edu
> Subject: SAP-WUG Digest, Vol 69, Issue 33
>
> Send SAP-WUG mailing list submissions to
> sap-wug at mit.edu
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mailman.mit.edu/mailman/listinfo/sap-wug
> or, via email, send a message with subject or body 'help' to
> sap-wug-request at mit.edu
>
> You can reach the person managing the list at
> sap-wug-owner at mit.edu
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of SAP-WUG digest..."
>
>
> Today's Topics:
>
> 1. SWN_SELSEN going to dump (srinivas)
> 2. SWN_SELSEN dump result (srinivas)
> 3. Re: SWN_SELSEN dump result (Rick Bakker)
> 4. Re: SWN_SELSEN dump result (srinivas)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 17 Aug 2010 22:05:44 +0530
> From: srinivas <ootasrinivasreddy at gmail.com>
> Subject: SWN_SELSEN going to dump
> To: "SAP Workflow Users' Group" <sap-wug at mit.edu>
> Message-ID:
> <AANLkTimgn-3SOuV2XFr5RCra7+gB9OR+_-=X3xC547y_ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi All,
>
> While executing the report SWN_SELSEN (extended notifications) via batch
> job
> or manually the report is going to dump.Can someone tell me what are the
> possible causes for the dump in SWN_SELSEN??Actually I dont have dump file
> at the moment,this issue is happening in production server.
>
> --
> Thanks and Regards
> Srini..
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/8bcbfbd8/attac
>
> hment-0001.htm
>
> ------------------------------
>
> Message: 2
> Date: Tue, 17 Aug 2010 23:04:06 +0530
> From: srinivas <ootasrinivasreddy at gmail.com>
> Subject: SWN_SELSEN dump result
> To: "SAP Workflow Users' Group" <sap-wug at MIT.EDU>
> Message-ID:
> <AANLkTikKNvHRDLvJxBwObAOGnAMn1b0a3p4S+9n283GX at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi All,
>
> Below is the dump result when the report SWN_SELSEN is executed. Does this
> issue related to memory??
>
>
> Memory consumption
> Roll.... 16192
> EM...... 12569520
> Heap.... 0
> Page.... 90112
> MM Used. 2145408
> MM Free. 2041808
>
> --
> Thanks and Regards
> Srini..
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/2578f7f7/attac
>
> hment-0001.htm
>
> ------------------------------
>
> Message: 3
> Date: Tue, 17 Aug 2010 13:01:40 -0500
> From: Rick Bakker <rbakker at gmail.com>
> Subject: Re: SWN_SELSEN dump result
> To: "SAP Workflow Users' Group" <sap-wug at mit.edu>
> Message-ID:
> <AANLkTikZGSUyM8GwXfFc+kecQsDGHz9UX+=R53TYH_6F at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello,
>
> Doesn't the dump show any sort of error?
>
> Has it been working in the past?
> Check also SLG1.
>
> regards
> Rick Bakker
> Hanabi Technology
>
> On Tue, Aug 17, 2010 at 12:34 PM, srinivas <ootasrinivasreddy at gmail.com>
> wrote:
>>
>> Hi All,
>>
>> Below is the dump result when the report SWN_SELSEN is executed. Does
> this
>> issue related to memory??
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20100818/0f46b8dc/attachment-0001.htm
>
> ------------------------------
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
> End of SAP-WUG Digest, Vol 69, Issue 36
> ***************************************
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
More information about the SAP-WUG
mailing list