Is there an Automated way to clean up the Approval Flow tables?

  • 3046093
  • 23-Jan-2007
  • 26-Apr-2012


Novell User Application 3.0.1
Novell User Application 3.0
Novell Identity Manager 3.0.1
Novell Identity Manager 3.0


Yes, there is an automated way to clean up the Approval Flow tables in the 3.0 and 3.0.1 releases of the Novell User Application. By default, there is a clean up thread the runs every 12 hours and it will remove any Approval Flow and its associated comments that are older than 120 days, which are in the state of "Terminated" or "Completed"


In the current 3.0 and 3.0.1 releases of the Novell User Application, there is no User Interface to change the frequency of when the clean up thread runs. This can be accomplished at the database level by updating the CLEANUP and CPTIMEOUT columns in the AFENGINE table

The AFENGINE table contains one row for all the workflow engine configuration settings:

The column CLEANUP specifies the interval in millisecond when the thread runs to check for "Terminated" or "Completed" Approval Flows (the default is 12 hours).

The column CPTIMEOUT specifies the number of days that a process' state will remain in the database before being removed (the default is 120).