Forums » Interstage BPM Knowledgebase Articles

• admin admin

  
   

  September 27, 2011 9:45:12 PM PDT

  Interstage BPM Version: 7.4.2.1

   

  Problem Description:

   

  Need a procedure to delete the entire data related to process instance/work item from IBPM database for the specified dates range.

  e.g.

  
  Through the SQL scripts want to delete history data from the backend (IBPM database).

  
  Solution:

   

  For deleting closed process instances and related data you will have to delete data from the following tables:
  ProcessInstance
  History
  ActivityInstance
  ArrowInstance
  TimeInstance
  ProcessDataSet
  ProcessInstanceOwner
  ProcInstAccess
  UdaValues

  Need to write sql query for retreiving closed processes (state=8) and closedTime before a particular date (both state and closedTime columns are in ProcessInstance table) to delete those.

  You can find more information on our DB Schema in Interstage BPM v7.4 Administration Guide (Appendix D).

   

  Author: Nitin Kumar
  Attachment: