<div>G'day all,</div>
<div> </div>
<div>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!</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Have fun,</div>
<div>Mark<br><br> </div>
<div><span class="gmail_quote">On 29/01/2009, <b class="gmail_sendername">Mark Pyc</b> <<a href="mailto:mark.pyc@gmail.com">mark.pyc@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>G'day Wuggers,</div>
<div> </div>
<div>A long time no nothing from me!</div>
<div> </div>
<div>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. </div>
<div> </div>
<div>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!</div>
<div> </div>
<div>These entries are not removed when the Workflows are achived nor by running report RSWWWIDE_DEP</div>
<div> </div>
<div>Has anyone else experienced this?</div>
<div> </div>
<div>ECC 6.0 700 SAPKB70013</div>
<div> </div>
<div>I do have an open customer message for this.</div>
<div> </div>
<div>Have fun,<br><span class="sg">Mark</span></div></blockquote></div><br>