Job to Delete Investments not deleting investments "marked for Deletion"

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When a user is trying to delete the ideas using the Delete Investments Job, the Job is getting completed, but the instances are not getting removed.

Environment

Release : 16.0.2

Cause

Check the bg-ca logs for further details.  

If there are actuals and you did not mark the job to delete actuals the investment will not be deleted.

 

Check for processes on any of the tabs.

For instance they could be on the investment itself, Tasks, Financial Plans or any other sub objects.

- Normally the logs will show you which object the process is associated.

- If the logs show that it cannot lock the cost plan check the pk_id associated in the bg-ca log.  These could be on cost plans, benefit plans, budget plans.

 

 

 

Resolution

Abort the Processes and delete those instances.

• • If the process is stuck in Aborting Status you can run this update statement to change the status to Aborted: 
    
    
    • Run this query to verify the correct process:
      
      
      • • SELECT * FROM  bpm_run_processes
          WHERE  status_code ='BPM_PIS_ABORTING'
          
    • Run this query to update the status:
      
      

      • UPDATE bpm_run_processes
        SET status_code = 'BPM_PIS_ABORTED'
        WHERE  status_code ='BPM_PIS_ABORTING'
        
        commit;

• Re-run the Delete Investments Job.