Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Delete data from WFACTVAR WFACTIVITY

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Rajeev
Basic Member
Posts: 5
Basic Member
8/19/2015 6:49 PM

    what could be best way to delete data from WFACTVAR WFACTIVITY files when you have huge record count in these two files.

    9674465 - WFACTIVITY

    15426057 - WFACTVAR

    Using Move work unites to history method is extremely slow.

    We are thinking of dropping these two tables and recreate them, any suggestions from experts out there?

     

    BarbR
    Veteran Member
    Posts: 306
    Veteran Member
    8/19/2015 6:54 PM
      We move to active to history every day (closed older than today-30 days) and purge history every week (today-365 days). These flows run in seconds. When we started this we had to catch up, so ran with different dates to move/purge in smaller pieces which is what you may have to do. I don't know how you can drop/add active tables as you probably have flows in progress (e.g. personnel actions waiting for task actions, etc.).
      John Henley
      Posts: 3353
      8/19/2015 7:12 PM
        +1 for Barb
        Thanks for using the LawsonGuru.com forums!
        John
        Rajeev
        Basic Member
        Posts: 5
        Basic Member
        8/19/2015 7:22 PM
          Thanks Barb, This is exactly our goal is to keep on 6 months of transactional data in these tables, to get there first we have to clear the old data. I did try using move/purge command but it was extremely slow, for example on average it deleted only 200 workunits in a day. That’s why we are looking into this method. So if we drop these two table and re-import last 6 months transactional data back then it won’t impact any outstanding/pending approvals(Pa52s).