Forums » Interstage BPM Knowledgebase Articles

• C.Y. Chen

  

  • 33 posts
   

  March 14, 2012 3:47:30 AM PDT

  Goal: How to Restore BPM Database to Empty Tables

  
  

  Fact: Oracle 10g

  
  

  Fact: Oracle 11g

  
  

  Fact: Interstage BPM (Business Process Manager) Version 10.1

  
  

  Fact: JBoss v4.0.5 GA

  
  

  Fact: WebLogic Server Version 10.3.2

  
  

  Fix:

  If there is a need to clear the processinstance and

  processdefinition tables, just execute a sql script that 

  contains the following SQL statements:

  
  

  DELETE FROM PROCESSDEFINITION

  DELETE FROM PROCESSDEFINITIONVERSION

  DELETE FROM ARCHIVEDPROCESSDEFINITION

  DELETE FROM ARCHIVEDPROCESSINSTANCE

  DELETE FROM WORKFLOWAPPLICATION

  
  

  These commands will clear all the tables and will restore the table to the newly

  created phase.

  Author: C.Y. Chen
  Attachment: