Deleting a ProcessInstance having a running Sub-ProcessInstance fails --------------------------------------------------------------------- Key: JBPM-2491 URL: https://jira.jboss.org/jira/browse/JBPM-2491 Project: jBPM Issue Type: Bug Security Level: Public (Everyone can see) Components: Runtime Engine Affects Versions: jBPM 4.0 Reporter: Flavio Donzé When trying to delete a ProcessInstance using ExecutionService.deleteProcessInstance() an SQLException is thrown if the ProcessInstance has a running Sub-ProcessInstance. Trying to delete the Sub-ProcessInstance first doesn't work either. The problem here are the foreign key constraints: Deleting the super process: org.postgresql.util.PSQLException: ERROR: update or delete on table "jbpm4_execution" violates foreign key constraint "fk_exec_superexec" on table "jbpm4_execution" Detail: Key (dbid_)=(176) is still referenced from table "jbpm4_execution". Deleting the sub process: org.postgresql.util.PSQLException: ERROR: update or delete on table "jbpm4_execution" violates foreign key constraint "fk_exec_subpi" on table "jbpm4_execution" Detail: Key (dbid_)=(179) is still referenced from table "jbpm4_execution". Maybe loosen up the sub>super constraint? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira