<br><font size=2 face="sans-serif">Hi Jocelyn,</font>
<br>
<br><font size=2 face="sans-serif">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>
<br>
<br><font size=2 face="sans-serif">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<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">12/02/2009 05:42 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]RE: [LIKELY JUNK]]Extended
Notifications SDN blog</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">Try SWN_SELSEN_TEST to play around
with the timestamp. And apply the SAP Notes around performance....
important!</font>
<br><font size=2 color=blue face="Arial">Jocleyn</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> 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>
<br><font size=2 face="sans-serif"><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>
<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=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>
<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>
<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>
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=3><br>
</font><font size=2 face="sans-serif"><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>
<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>
<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 ... it's not under my name... </font><font size=3><br>
</font><font size=2 color=blue face="Arial"><br>
The blog search is playing up for me today.. sigh... </font><font size=3><br>
</font><font size=2 color=blue face="Arial"><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.
</font><font size=3><br>
</font><font size=2 color=blue face="Arial"><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>
<br>
</font><font size=2 color=blue face="Arial"><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><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 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>
<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</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>
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>
</tt></font>
<p>