Clarity: When we run the Delete Investment job, the ideas marked for deletion are not removed, why?

Document ID : KB000023912
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

The Delete Investment job is not deleting Ideas marked for deletion with processes attached.

Steps to Reproduce:

  1. Create a process on the idea that does not complete

  2. Mark the Idea for Deletion

  3. Run the Delete Investment job

  4. 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.

Solution

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.