<br><font size=2 face="sans-serif">Thanks Joceyn</font>
<br>
<br><font size=2 face="sans-serif">I checked again and could only find
1105696 and 1098805. If anyone else is aware of others please let me know.
I opened an OSS note and received corroborating feedback to your
own, (ie. too much data). The program is attempting a sequential read of
SWWLOGHIST which contains a whopping 24million records. Understandable
on the first run but not on subsequent runs using delta as the timestamps
were all set to the last couple of days so no need to read the older records.</font>
<br>
<br><font size=2 face="sans-serif">Karl Nietz<br>
<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Dart, Jocelyn"
<jocelyn.dart@sap.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: sap-wug-bounces@mit.edu</font>
<p><font size=1 face="sans-serif">17/02/2009 01:13 PM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">"SAP Workflow Users' Group"
<sap-wug@mit.edu></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">RE: [LIKELY JUNK]Extended Notifications
runtime</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">Hi Karl, </font>
<br><font size=2 color=blue face="Arial">There is definitely more than
one SAP Note to apply - please make sure you look for all notes relating
to the performance of SWN_SELSEN or SWNCONFIG.</font>
<br><font size=2 color=blue face="Arial">Regards,</font>
<br><font size=2 color=blue face="Arial">Jocelyn </font>
<br>
<br>
<hr><font size=2 face="Tahoma"><b>From:</b> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu]
<b>On Behalf Of </b>Karl Nietz<b><br>
Sent:</b> Friday, 13 February 2009 6:20 PM<b><br>
To:</b> SAP Workflow Users' Group<b><br>
Subject:</b> [LIKELY JUNK]Extended Notifications runtime</font><font size=3><br>
</font>
<br><font size=2 face="sans-serif"><br>
Hi Jocelyn,</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
I've been investigating a number of your suggestions. I am attempting
to create notifications for leave approvals in the dev system (a backup
of prod) and when running swn_selsen/swn_selsen_test it runs forever. Last
night for 6 hours until the system went down, which is indeed long. I
have established that there are 870 leave approvals in 'Ready' status (and
1000's of 'completed' as archiving is not done in this site). Is
this number (780) likely to be deleterious? The SM50 txn seems to
show the program performing a sequential read of table SWWLOGHIST which
contains 24,000,000 records(!). This makes me nervous and I asked an ABAPer
to check note 1105696. This note is applicable to SAPKB70015 but
we are running SAPKB70017 and an initial check indicated we had the changes.
Is there another note that I have overlooked? It's worth mentioning
that the program runs acceptably for a different schedule referencing a
workflow I execute via SWUI_VERIFY - for this workflow there are almost
no prior instances. Trying to manually complete 870 leave approval
instances is not going to be easy so if you have any other ideas based
on this info i would appreciate it. Thanks.</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
Karl Nietz<br>
Senior Consultant<br>
CSC Australia<br>
Ph: 61 3 8695 1157<br>
Mob: 61 434 181303<br>
<br>
Please consider the environment before printing this e-mail.<br>
<br>
CSC - This is a private message. If you are not the intended recipient,
please delete without copying and kindly advise us by e-mail of the mistake
in delivery. Note: Regardless of content, this e-mail shall not operate
to bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose - CSC Australia Pty Limited; Registered Office:
5B/26 Talavera Road, Macquarie Park NSW 2113 Australia; Incorporated in
Australia. ACN: 008 476 944</font><font size=3><br>
<br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=39%><font size=1 face="sans-serif"><b>"Dart, Jocelyn"
<jocelyn.dart@sap.com></b> <br>
Sent by: sap-wug-bounces@mit.edu</font><font size=3> </font>
<p><font size=1 face="sans-serif">12/02/2009 05:42 PM</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<p>
<td width=60%>
<br>
<table width=100%>
<tr valign=top>
<td width=10%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=89%><font size=1 face="sans-serif">"SAP Workflow Users'
Group" <sap-wug@mit.edu></font><font size=3> </font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">RE: [LIKELY JUNK]RE: [LIKELY JUNK]]Extended
Notifications SDN blog</font></table>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
</font><font size=2 color=blue face="Arial"><br>
Try SWN_SELSEN_TEST to play around with the timestamp. And apply
the SAP Notes around performance.... important!</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Jocleyn</font><font size=3> <br>
<br>
</font>
<hr><font size=2 face="Tahoma"><b>From:</b> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu]
<b>On Behalf Of </b>Karl Nietz<b><br>
Sent:</b> Thursday, 12 February 2009 5:26 PM<b><br>
To:</b> SAP Workflow Users' Group<b><br>
Subject:</b> [LIKELY JUNK]RE: [LIKELY JUNK]]Extended Notifications SDN
blog</font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
<br>
Thanks, I was wondering whether that was the case. Does the program
read every record in 'Ready' status and then apply the task filter? - if
so then it will be a long slog. Is there a way to initialise the
date/timestamp so that the program starts from the current date? Otherwise
i see a similar situation when moving to prod. Thanks.</font><font size=3>
</font><font size=2 face="sans-serif"><br>
<br>
Karl Nietz<br>
Senior Consultant<br>
CSC Australia<br>
Ph: 61 3 8695 1157<br>
Mob: 61 434 181303<br>
<br>
Please consider the environment before printing this e-mail.<br>
<br>
CSC - This is a private message. If you are not the intended recipient,
please delete without copying and kindly advise us by e-mail of the mistake
in delivery. Note: Regardless of content, this e-mail shall not operate
to bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose - CSC Australia Pty Limited; Registered Office:
5B/26 Talavera Road, Macquarie Park NSW 2113 Australia; Incorporated in
Australia. ACN: 008 476 944</font><font size=3><br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=46%><font size=1 face="sans-serif"><b>"Dart, Jocelyn"
<jocelyn.dart@sap.com></b> <br>
Sent by: sap-wug-bounces@mit.edu</font><font size=3> </font>
<p><font size=1 face="sans-serif">12/02/2009 04:46 PM</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<br>
<td width=53%>
<br>
<table width=100%>
<tr valign=top>
<td width=13%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=86%><font size=1 face="sans-serif">"SAP Workflow Users'
Group" <sap-wug@mit.edu></font><font size=3> </font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">RE: [LIKELY JUNK]]Extended Notifications
SDN blog</font></table>
<br><font size=3><br>
</font>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
</font><font size=2 color=blue face="Arial"><br>
<br>
Hi Karl, <br>
If you have a lot of work items in READY status hanging around then the
first run of the program can be very long. It's even worse if most
of your users don't have email addresses yet while the system exhausts
all options trying to find an email address. Both typical scenarios
in a DEV System. </font><font size=3><br>
</font><font size=2 color=blue face="Arial"><br>
So if you can do a bit of cleansing of dead work items first. </font><font size=3><br>
</font><font size=2 color=blue face="Arial"><br>
You should also look for and apply performance notes - search service.sap.com/notes
using the term SWN_SELSEN or SWNCONFIG. Depending on your release/support
pack it's definitely worth applying some of these as well. <br>
Regards,</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Jocelyn </font><font size=3><br>
</font>
<hr><font size=2 face="Tahoma"><b>From:</b> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu]
<b>On Behalf Of </b>Karl Nietz<b><br>
Sent:</b> Thursday, 12 February 2009 4:36 PM<b><br>
To:</b> SAP Workflow Users' Group<b><br>
Subject:</b> [LIKELY JUNK]]Extended Notifications SDN blog</font><font size=2 face="sans-serif"><br>
<br>
<br>
Thanks Jocelyn. This reaffirmed things well. I have query about
the Delta setting, which I presume relates to entering for items new or
changed since last run, rather than all items. Whe I config this and run
SWN_SELSEN_TEST with schedule id of xxxxxx_delta and a test case of 10
the program runs interminably. Doesn't seem to end so I cancel it.
Is this a config error or is it because it is reading through all
data in the system? I there a way to address this?</font><font size=3>
</font><font size=2 face="sans-serif"><br>
Karl Nietz<br>
<br>
<br>
Please consider the environment before printing this e-mail.<br>
<br>
CSC - This is a private message. If you are not the intended recipient,
please delete without copying and kindly advise us by e-mail of the mistake
in delivery. Note: Regardless of content, this e-mail shall not operate
to bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose - CSC Australia Pty Limited; Registered Office:
5B/26 Talavera Road, Macquarie Park NSW 2113 Australia; Incorporated in
Australia. ACN: 008 476 944</font><font size=3><br>
</font>
<table width=100%>
<tr valign=top>
<td width=46%><font size=1 face="sans-serif"><b>"Dart, Jocelyn"
<jocelyn.dart@sap.com></b> <br>
Sent by: sap-wug-bounces@mit.edu</font><font size=3> </font>
<p><font size=1 face="sans-serif">12/02/2009 11:49 AM</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<p>
<td width=53%>
<br>
<table width=100%>
<tr valign=top>
<td width=13%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=86%><font size=1 face="sans-serif">"SAP Workflow Users'
Group" <sap-wug@mit.edu></font><font size=3> </font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">RE: [LIKELY JUNK]Extended Notifications
SDN blog</font></table>
<br><font size=3><br>
<br>
</font>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
</font><font size=2 color=blue face="Arial"><br>
<br>
<br>
Hi Karl ... it's not under my name... <br>
<br>
The blog search is playing up for me today.. sigh... <br>
<br>
Basically there are 5 steps:</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
1. Create a delivery schedule</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
2. In scenario WORKFLOW category STANDARD, create a subscription and set
up your subscription parameters. <br>
Set the Granularity to the multiple option, set the recipient to * using
the CL_SWN_SUBSCRIPTION handler - this identifies all agents who have an
email address maintained</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
3. Set up schedule selection for DELTA</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
4. Adjust your general settings - particularly the email address determination
priorities (number them 1 to 4) - URL fragments for links and adjust texts
- texts starting NA are SE91 T100 messages, texts starting DT are SE61
dialog texts.</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
5. Schedule a job for program SWN_SELSEN with WF-BATCH as the executing
user and of course matching your delivery schedule/schedule selection time.
<br>
<br>
I usually start with a Monday to Friday - hourly during business hours
approach and keep both schedules the same until you know what you are doing.</font><font size=3>
</font><font size=2 color=blue face="Arial"><br>
<br>
Hope that helps.</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Regards,</font><font size=3> </font><font size=2 color=blue face="Arial"><br>
Jocelyn </font><font size=3><br>
<br>
<br>
</font>
<hr><font size=2 face="Tahoma"><b>From:</b> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu]
<b>On Behalf Of </b>Karl Nietz<b><br>
Sent:</b> Thursday, 12 February 2009 11:33 AM<b><br>
To:</b> SAP Workflow Users' Group<b><br>
Subject:</b> [LIKELY JUNK]Extended Notifications SDN blog</font><font size=2 face="sans-serif"><br>
<br>
<br>
Hi Jocelyn,</font><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
Must admit I couldn't find your blog on SDN (I'm assuming you are the author).
I had a good look but no success. Can you please send along the link
when you get a moment. Thanks.</font><font size=3> </font><font size=2 face="sans-serif"><br>
<br>
Karl Nietz<br>
Senior Consultant<br>
CSC Australia<br>
Ph: 61 3 8695 1157<br>
Mob: 61 434 181303<br>
<br>
Please consider the environment before printing this e-mail.<br>
<br>
CSC - This is a private message. If you are not the intended recipient,
please delete without copying and kindly advise us by e-mail of the mistake
in delivery. Note: Regardless of content, this e-mail shall not operate
to bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose - CSC Australia Pty Limited; Registered Office:
5B/26 Talavera Road, Macquarie Park NSW 2113 Australia; Incorporated in
Australia. ACN: 008 476 944</font>
<table width=100%>
<tr valign=top>
<td width=46%><font size=1 face="sans-serif"><b>"Dart, Jocelyn"
<jocelyn.dart@sap.com></b> <br>
Sent by: sap-wug-bounces@mit.edu</font><font size=3> </font>
<p><font size=1 face="sans-serif">12/02/2009 09:51 AM</font><font size=3>
</font>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<br>
<td width=53%>
<br>
<table width=100%>
<tr valign=top>
<td width=13%>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td width=86%><font size=1 face="sans-serif">"SAP Workflow Users'
Group" <sap-wug@mit.edu></font><font size=3> </font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">RE: [LIKELY JUNK]Extended Notifications</font></table>
<br><font size=3><br>
<br>
<br>
</font>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=50%></table>
<br></table>
<br><font size=3><br>
<br>
</font><font size=2 color=blue face="Arial"><br>
<br>
<br>
<br>
Jerry - there's a blog on SDN which gives you the basics. Don't have
the link on me but you should be able to find it easily enough. Regards,Jocelyn</font><font size=3>
<br>
<br>
</font>
<hr><font size=2 face="Tahoma"><b>From:</b> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu]
<b>On Behalf Of </b>Miller, Jerry<b><br>
Sent:</b> Thursday, 12 February 2009 4:06 AM<b><br>
To:</b> sap-wug@mit.edu<b><br>
Subject:</b> [LIKELY JUNK]Extended Notifications</font><font size=3> </font>
<p><font size=3> </font><font size=3 color=blue face="Arial">We
are moving to ECC6 6.0 so this is my 1st attempt using Extended Notifications.</font><font size=3>
<br>
</font><font size=3 color=blue face="Arial">I have it working
for 1 "filter" but what do I need to do to add more filters?</font><font size=3>
<br>
</font><font size=3 color=blue face="Arial">Can I add more
filters for the same Subscription?</font><font size=3> <br>
</font><font size=3 color=blue face="Arial">tks,</font><font size=3>
</font><font size=3 color=blue face="Arial">Jerry</font><font size=2><tt>_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug<br>
</tt></font>
<p>