Wednesday , 26 April 2017

Delete Unnecessary Workitems

If you find tables like SWWWIHEAD, SWWLOGHIST and SWWCNTP0 growing large, compared to other workflow tables, there might be entries in these tables that are no longer referenced in the header table SWWWIHEAD.

Such orphaned entries can be cleaned up by running RSWWWIDE_DEP report. If the report cleaned up a lot of entries, it is a good idea to reorganize the tables (listed in the report).

 

 

 

Check Also

HANA Log Volume is full

Symptom The logvolume is full and the database doesn’t accept any new requests. Other Terms …