Using BPEL Console, you can identify all stale instances and kill them as shown in the following screenshot:
Unfortunately, these stale instances can be searched for only on a specific domain. However, in a production environment, multiple processes will probably be deployed across different domains—resulting in a huge administrative burden. Besides, purging all stale instances at once within a specific domain is not possible.
As an alternative approach, you can find a unique cube instance key (cikey) for every stale instance via the following SQL query:
SELECT CUBE_INSTANCE.cikey, CUBE_INSTANCE.root_id, CUBE_INSTANCE.process_id, CUBE_INSTANCE.domain_ref FROM CUBE_INSTANCE WHERE STATE = 9
Once you have identified a CI key for each stale instance, you can use that key to delete stale instances from CUBE_INSTANCE and other tables that reference the cube instances by invoking delete_ci(CIKEY) for every cube instance found via the SQL query. delete_ci(CIKEY) is a stored...