BPEL Database Schema

Submitted by code_admin on Tue, 07/17/2018 - 14:09

Find composite instances:

  1. select ci.created_time, ci.source_name, ci.title, ci.conversation_id, ci.*
  2. from dev_soainfra.composite_instance ci
  3. where 1=1
  4. and ci.state=17
  5. and ci.source_name not in ('aiaerrortaskadministrationprocess_client_ep')
  6. order by ci.created_time desc

ci.state = 17 Terminated

RJM Article Type
Quick Reference