<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Times New Roman";
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:11.0pt;color:black'>Thanks for following through with us,
Mark.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:11.0pt;color:black'>I was wondering how much time I should
spend monitoring the size of that table.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:11.0pt;color:black'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>----</span></font><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>Susan R. Keohan</span></font><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>SAP Workflow Specialist</span></font><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:City w:st="on"><st1:place w:st="on"><font size=2
color=black face="Times New Roman"><span style='font-size:10.0pt;color:black'>Enterprise</span></font></st1:place></st1:City><font
size=2 color=black><span style='font-size:10.0pt;color:black'> Applications</span></font><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>Information Services Department</span></font><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>MIT <st1:City w:st="on"><st1:place w:st="on">Lincoln</st1:place></st1:City>
Laboratory</span></font><font color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=2
color=black face="Times New Roman"><span style='font-size:10.0pt;color:black'>244
Wood Street</span></font></st1:address></st1:Street><font size=2 color=black><span
style='font-size:10.0pt;color:black'>, LI-200</span></font><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=black face="Times New Roman"><span style='font-size:10.0pt;color:black'>Lexington</span></font></st1:City><font
size=2 color=black><span style='font-size:10.0pt;color:black'>, <st1:State
w:st="on">MA</st1:State></span></font></st1:place><font size=2 color=black><span
style='font-size:10.0pt;color:black'>. 02420</span></font><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>781-981-3561</span></font><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face="Times New Roman"><span
style='font-size:10.0pt;color:black'>keohan@LL.MIT.EDU</span></font><font
color=black><span style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Mark Pyc<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 05, 2009
5:10 AM<br>
<b><span style='font-weight:bold'>To:</span></b> WUG<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: SWWUSERWI filled with
Wait Events steps duplicated for EVERY USER!</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>G'day all,<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I was mistaken about this data. Once I got access to a recent copy of
Prod and wrote a couple of programs to analyse things became clearer. There was
actually only a weeks window where 7000 wait events were added to the
table, but these were then duplicated for each new WF user. So when 1000 users
were added this table jumped by a 7 million rows!<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Anyway, no explanation as to how or why these wait events made it into
the table a year ago, but SAP have confirmed that they shouldn't be there and
just to delete them.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Have fun,<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Mark<br>
<br>
<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 29/01/2009, <b><span style='font-weight:bold'>Mark
Pyc</span></b> <<a href="mailto:mark.pyc@gmail.com">mark.pyc@gmail.com</a>>
wrote:</span></font></span> <o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>G'day Wuggers,<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>A long time no nothing from me!<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I've got a system where table SWWUSERWI is being filled with WAIT EVENT
workitems duplicated for every user. This means that in a system with 10,000
users, 1 wait step in 1 workflow generates 10,000 items in this table. None of
these relate to a user. <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>To put it in perspective this table has almost 18 million entries and
around 100,000 of those relate to open Workitems assigned to users - well over
99% is rubbish. We have just gone through an upgrade and more than doubled the
user base so this table is going to start growing even faster!<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>These entries are not removed when the Workflows are achived nor by
running report RSWWWIDE_DEP<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Has anyone else experienced this?<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>ECC 6.0 700 SAPKB70013<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I do have an open customer message for this.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Have fun,<br>
<span class=sg>Mark</span><o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>