Read full tutorial here : https://cedricleruth.com/how-to-mass-abort-instances-and-reset-your-oracle-soa-bpel-environment/
--Performance/Development Action | |
--Script to mass abort all running instances. (Usefull during perf testing to keep volumetry between runs) | |
update YOUR_YOUR_SOA_USER.composite_instance set state=16 where state=32; | |
update YOUR_YOUR_SOA_USER.work_item set state = 10, modify_date = sysdate where state<5; | |
update YOUR_YOUR_SOA_USER.cube_instance ci set ci.state = 8 , | |
ci.scope_revision = (select cit.scope_revision+1 from YOUR_YOUR_SOA_USER.cube_instance cit where cit.ecid = ci.ecid) , | |
ci.modify_date = sysdate where ci.state < 4; | |
update YOUR_YOUR_SOA_USER.dlv_message set state = 3 where state in (0, 2); | |
update YOUR_YOUR_SOA_USER.dlv_subscription set state = -1 where state=0; | |
COMMIT; | |
-- Delete all data (Only in Dev/VBox env to restart fresh) | |
truncate table YOUR_SOA_USER.edn_clusters; | |
truncate table YOUR_SOA_USER.edn_retry_count; | |
truncate table YOUR_SOA_USER.edn_log_messages; | |
truncate table YOUR_SOA_USER.EDN_EVENT_ERROR_STORE; | |
truncate table YOUR_SOA_USER.audit_details; | |
truncate table YOUR_SOA_USER.audit_trail; | |
truncate table YOUR_SOA_USER.brdecisionunitofwork; | |
truncate table YOUR_SOA_USER.composite_instance; | |
truncate table YOUR_SOA_USER.cube_instance; | |
truncate table YOUR_SOA_USER.cube_scope; | |
truncate table YOUR_SOA_USER.document_dlv_msg_ref; | |
truncate table YOUR_SOA_USER.dlv_message; | |
truncate table YOUR_SOA_USER.dlv_subscription; | |
truncate table YOUR_SOA_USER.document_ci_ref; | |
truncate table YOUR_SOA_USER.instance_payload; | |
truncate table YOUR_SOA_USER.headers_properties; | |
truncate table YOUR_SOA_USER.reference_instance; | |
truncate table YOUR_SOA_USER.composite_sensor_value; | |
truncate table YOUR_SOA_USER.wi_fault; | |
truncate table YOUR_SOA_USER.mediator_case_detail; | |
truncate table YOUR_SOA_USER.mediator_case_instance; | |
truncate table YOUR_SOA_USER.mediator_instance; | |
truncate table YOUR_SOA_USER.mediator_case_detail; | |
truncate table YOUR_SOA_USER.MEDIATOR_CASE_INSTANCE; | |
truncate table YOUR_SOA_USER.mediator_instance; | |
truncate table YOUR_SOA_USER.EDN_LOG_MESSAGES; | |
alter table YOUR_SOA_USER.B2B_DATA_STORAGE disable constraint B2B_DS_DOC_ID_FK ; | |
truncate table YOUR_SOA_USER.XML_DOCUMENT; | |
alter table YOUR_SOA_USER.B2B_DATA_STORAGE enable constraint B2B_DS_DOC_ID_FK ; | |
--commit; | |
truncate table YOUR_SOA_USER.wfassignee; | |
truncate table YOUR_SOA_USER.wfcomments; | |
truncate table YOUR_SOA_USER.wfmessageattribute; | |
truncate table YOUR_SOA_USER.wfroutingslip; | |
truncate table YOUR_SOA_USER.wfheaderprops; | |
truncate table YOUR_SOA_USER.WFTASKASSIGNMENTSTATISTIC; | |
truncate table YOUR_SOA_USER.wftaskhistory; | |
truncate table YOUR_SOA_USER.work_item; | |
truncate table YOUR_SOA_USER.wftaskhistory_tl; | |
COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment