The Delete Investment job is not deleting Ideas marked for deletion with processes attached.
Steps to Reproduce:
- Create a process on the idea that does not complete
- Mark the Idea for Deletion
- Run the Delete Investment job
- Verify the idea has been removed from Clarity
Expected: the Idea investment is gone
Actual: the Idea investment is still in Clarity
Note: the bg-niku.log file will have the following warning:
WARN 2014-09-17 02:00:07,511 [Dispatch Thread-10856 : bg@HOSTSERVER] xql2.xbl (none:none:none) IDEA20000 (5002073) cannot be deleted because it has associated with non finished process instances.
Let the process complete, then delete the process attached to the idea.
If the process on the idea is in a status of 'Aborting' and after waiting some time, it is determined to be 'stuck', you can run the below query to change it to 'Aborted'. Once it is in this state you can delete the process instance through the application UI.
UPDATE BPM_RUN_PROCESSES SET status_code = 'BPM_PIS_ABORTED' WHERE
status_code = 'BPM_PIS_ABORTING';
Initially this was logged as CLRT-20747 and it was tested, verified and closed for Clarity 13.0. If you find that you experience the symptoms on a current release, please open a new support case for further investigation.