Workunit Purge?

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
klippe
Basic Member
Posts: 14
Basic Member
    I created a very simple Processflow that does nothing more than send me an email and exit. I tested the creation and execution by initiating the flow from within a LID form. Everything worked fine. I received the email, could view the completed workunit in the Processflow Administrator console and all was fine...until...I accidentally created an infinite loop that continuously created workunits (~10,000) of them. (Talk about clogging the network and stress testing the email server!)

    I force killed the UNIX process associated with the form, but it was too late by then. We ran out of tablespace for the workunits. The dba allocated more space, but something is still not right. I have 1000's of workunits in "Ready Status" within Processflow Administrator. I've tried to highlight the workunits 100 at a time and "Terminate" them. They change to "Cancel Requested". 100 at a time was taking too long and I figured out how to change the view in Processflow Administrator to show 10,000 workunits at a time. I've highlighted a large chunk of the workunits in "Ready" status and attempted to "Terminate" them. The Processflow Administrator just hangs and never comes back to life. When I bring up a new instance of the Processflow Administrator, the workunits are still in "Ready Status". It appears something is not functioning properly.

    Any suggestions on how to get my Processflow Installation back in order? I've really messed it up.
    Michael Thedford
    Advanced Member
    Posts: 19
    Advanced Member
      It sounds like you will need to have your DBA to update the records in the WFWORKUNIT table to change the status to 4 - processing complete. Then you should be able to run the WF140 in ENV 8.0.3.x or the BPM script in LSF9 that will move the WU's to history. Then you can run the purge program (for each ENV respectively) to delete the WU's from the database altogether.