SWWUSERWI filled with Wait Events steps duplicated for EVERY USER!

[Keohan, Susan]

Thanks for following through with us, Mark.
I was wondering how much time I should spend monitoring the size of that table.

----
Susan R. Keohan
SAP Workflow Specialist
Enterprise Applications
Information Services Department
MIT Lincoln Laboratory
244 Wood Street, LI-200
Lexington, MA. 02420
781-981-3561
keohan at LL.MIT.EDU

________________________________
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Mark Pyc
Sent: Thursday, February 05, 2009 5:10 AM
To: WUG
Subject: Re: SWWUSERWI filled with Wait Events steps duplicated for EVERY USER!

G'day all,

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!

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.

Have fun,
Mark


On 29/01/2009, Mark Pyc <mark.pyc at gmail.com<mailto:mark.pyc at gmail.com>> wrote:
G'day Wuggers,

A long time no nothing from me!

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.

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!

These entries are not removed when the Workflows are achived nor by running report RSWWWIDE_DEP

Has anyone else experienced this?

ECC 6.0 700 SAPKB70013

I do have an open customer message for this.

Have fun,
Mark

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20090205/1da06aa8/attachment.htm