SWWUSERWI filled with Wait Events steps duplicated for EVERY USER!

[Mark Pyc]

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> 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/ce8b0391/attachment.htm