SWWUSERWI filled with Wait Events steps duplicated for EVERY USER!

[Mark Pyc]

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.

What is being experienced here is an anomaly.

Things can get left hanging around, but RSWWWIDE_DEP does seem to clean them
up.

Have fun,
Mark


On 05/02/2009, Keohan, Susan <keohan at ll.mit.edu> wrote:
>
>  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> 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
>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20090206/2cd5a5ea/attachment.htm