Skip to Content
avatar image
Former Member

Cleanup of Unnecessary Work items

Hi All,

In our production system, we have table SWPNODELOG of size 236 GB & its growing rapidly. We checked few snotes for housekeeping of unnecessary work items from system.

one of them was snote 49545, where its mentioned to use reports for deletion through reports RSWWWIDE and RSWWHIDE, also found snote 573656, where it is mentioned, It is NOT recommended you use report RSWWWIDE in a production system.

So, we are confused, what is best approach in terms of removing unwanted work items from system,to go with archiving or deletion with specific variant (like older than X days).

Also, in case, if our customer don't want to go with archiving, can we go with deletion approach, what are disadvantages of this ?

Pls provide your valuable response on this topic.

Regards,

Manish

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • May 20, 2015 at 09:42 PM

    Hello Manish,

    SAP does not recommend to delete WORKITEMs in productions systems. Check below link.

    Delete Work Item - SAP Business Workflow - SAP Library

    We are archiving and then deleting WORKITEMs in our systems.

    You can check

    "Do not delete any business/audit relevant workflows even if no longer required. They form part of the object's history, and it's no good ending up with a document with a change log that says WF-BATCH and no workflow. Auditors won't be happy if they spot something like that." from Mike Pokraka



    Regards,

    Yuksel AKCINAR

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Mike Pokraka

      We are moving to HANA and we trying to get our WF tables smaller. We archive everything after 2 years. But, our tables are still quite large. To reduce the sizes more, we set this to 18 months, then archive. Still very large tables. I recommended that we could archive all WFs that are "completed" after 30,60, or 90 days, but some did not like that idea. Some didn't like the view from the archive vs actual wf log. Our SWWW_CONT table alone is like 3 billion records.

      What is best practice for retention length of WFs before archiving?