Archiving

[Gordy, Lynn L.]

Simon,
We had the same situtation and we are currently on 3.0f.  Archiving of the
workitems will reduce the size of this table.  Particularly the type 'c'
status 'ready' workitems.  These are not archived but deleted directly
through programs RSWWWIDE (delete workitem) and RSWWHIDE (delete workitem
history).   The SAP supplied archiving programs only delete Cancelled and
Completed workitems.  These are executed from SARA, object Workitem.  Take a
look at some of the oss notes that address this issue,
126678,49545,145291,149368,153205.
 
 Just a tip, we had to run the deletes in small chunks otherwise the program
would abend with space problems.  When you run these programs I recommend
you run rswwwide for a chunk then run rswwhide for the same group of
workitems. The reason is the first program makes an entry in the SWWLOGHIST
table for each entry deleted and in our case the table maxed out and
shutdown all workflow processing. The second program (rswwhide) deletes
these entries from the table.
 
lynn
 
> ----------
>> From:         SIMON ORCHARD[SMTP:ORCHARDS at gkn-whl.co.uk]
> Reply To:     SAP Workflow Users' Group
> Sent:         Friday, November 17, 2000 9:27 AM
> To:   SAP-WUG at MITVMA.MIT.EDU
> Subject:      Archiving
>
> All,
>
> I have ran today the "Watchdog for Runtime Tables" which shows a RED light
> next to the "Container Instances". There are 14 million records and so I
> would agree with SAP that a clean up is required.
>
> However, looking at SAP help, there is no talk of how to archive
> containers. Obviously we do not want to lose the data as it would be
> required in the future either for audit purposes or any other information.
>
> Does anyone have any information or help / tips on carrying out this task?
>
> We are currently using version 3.1I if that helps.
>
> Thank you in advance.
>
> Simon Orchard
> GKN Westland Helicopters Ltd.
>