SWN_SELSEN dump problem

Wed Aug 18 13:40:06 EDT 2010

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
***************************************