<div>Well it _should_ (always a powerful word) only contain items while they are active and so given a stable user base and number of WFs activated the table size should remain fairly static. The more items you have with relatively generic agent determination, the more entries you'll see in the table.</div>
<div> </div>
<div>What is being experienced here is an anomaly.</div>
<div> </div>
<div>Things can get left hanging around, but RSWWWIDE_DEP does seem to clean them up. </div>
<div> </div>
<div>Have fun,<br>Mark<br><br> </div>
<div><span class="gmail_quote">On 05/02/2009, <b class="gmail_sendername">Keohan, Susan</b> <<a href="mailto:keohan@ll.mit.edu">keohan@ll.mit.edu</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="blue" link="blue">
<div>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 11pt; COLOR: black">Thanks for following through with us, Mark.</span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 11pt; COLOR: black">I was wondering how much time I should spend monitoring the size of that table.</span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 11pt; COLOR: black"> </span></font></p>
<div>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">----</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">Susan R. Keohan</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">SAP Workflow Specialist</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">Enterprise</span></font><font color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black"> Applications</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">Information Services Department</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">MIT Lincoln Laboratory</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">244 Wood Street</span></font><font color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">, LI-200</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">Lexington</span></font><font color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">, MA</span></font><font color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">. 02420</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black">781-981-3561</span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="2"><span style="FONT-SIZE: 10pt; COLOR: black"><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:keohan@LL.MIT.EDU" target="_blank">keohan@LL.MIT.EDU</a></span></font><font color="black"><span style="COLOR: black"></span></font></p>
<p><font face="Times New Roman" color="black" size="3"><span style="FONT-SIZE: 12pt; COLOR: black"> </span></font></p></div>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a>] <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></p>
</div>
<div><span class="e" id="q_11f471025e12ebf3_1">
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">G'day all,</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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!</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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.</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Have fun,</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Mark<br><br> </span></font></p></div>
<div>
<p><span><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">On 29/01/2009, <b><span style="FONT-WEIGHT: bold">Mark Pyc</span></b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mark.pyc@gmail.com" target="_blank">mark.pyc@gmail.com</a>> wrote:</span></font></span> </p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">G'day Wuggers,</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">A long time no nothing from me!</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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. </span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">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!</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">These entries are not removed when the Workflows are achived nor by running report RSWWWIDE_DEP</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Has anyone else experienced this?</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">ECC 6.0 700 SAPKB70013</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I do have an open customer message for this.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Have fun,<br><span>Mark</span></span></font></p></div></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"> </span></font></p></span></div></div></div><br>_______________________________________________<br>SAP-WUG mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br><br></blockquote></div><br>