The job runs but never completes.
1. How many investments are marked for deletion?
Try deleting just one investment and check how long it takes.
2. Enable DEBUG logging on component com.niku.xql2 to review output of the job in the BG log.
3. Check with the DBA team to see if any issue with the database execution plan.