Skip to main content

Queries to delete data for particular Process Template

Aurea Support
  • Updated

Question/Problem Description

How to remove the data that belongs to a Process Template from SBM tables?
 

Environment

Product: Savvion Version: 6.x.x,7.x.x,8.x.x, 10.0.x OS: ANY Application Server: ANY Database: ANY Browser: ANY

Resolution

Run the below mentioned queries to delete the data for a particular ProcessTemplate :


delete FROM BIZLOGIC_AVAILABLEWORKITEM where WORKITEM_ID in (select WORKITEM_ID from BIZLOGIC_WORKITEM WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_VOTE where process_instance_id in (select process_instance_id  from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_WORKITEM_PERFORMER where process_instance_id in (select process_instance_id  from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_EXCLUDE_PERFORMER where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_WORKSTEP_MESSAGES where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_PITEMPLATE where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_PIXML where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_PI_LOCK where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_AVAILABLE_CWORKITEM where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_CSTEP_DS where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_SUBPROCESSINSTANCE where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_DEBUG_WORKSTEP where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete FROM BIZLOGIC_DEBUG_PI where process_instance_id in (select process_instance_id from BIZLOGIC_PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>);

delete from PROCESSRESOURCEINFO where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_DOCDS_FOLDER where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_WORKSTEPINSTANCE where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_WORKITEM where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_CWORKITEM where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_WAITWORKSTEP where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_PROCESSTEMPLATE where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_CSTEP where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_PROCESS_NOTES where PROCESS_TEMPLATE_ID=<PTID>;
delete from PROCESSXML where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_TIMERACTION where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_PT_REPLACE_INFO where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_PROCESSINSTANCE where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_DS_<PTID> where PROCESS_TEMPLATE_ID=<PTID>;
delete from BIZLOGIC_GLOBALDS_<PTID> where PROCESS_TEMPLATE_ID=<PTID>;

delete  from BIZEVENT WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from PROCESSTEMPLATE WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from PROCESSINSTANCE WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from WORKITEM WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from WORKSTEP WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from PROCESSDATAINFO WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from PROCESSWORKSTEPINFO WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from WORKSTEPVOTEINFO WHER.E PROCESS_TEMPLATE_ID=<PTID>;
delete  from CWORKITEM WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from CSTEP WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from CSTEP_DS WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from PROCESS_NOTES WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from WI_RESOURCE_USAGE WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from PROCESS_STATUS WHERE PROCESS_TEMPLATE_ID=<PTID>;
delete  from BS_<PTID> where PROCESS_TEMPLATE_ID=<PTID>;

In addition to these queries, there is a table with the same name as that of the installed application(ProcessTemplate name), that needs to be dropped as well.
In 10.x version, one view and an object gets created for the process template with name <ProcessTemplateName> _VIEW and <ProcessTemplateName> _WSV .
These two need to be dropped as well.


 

Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information. Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.