Job(Delete Investments and Time Reporting Periods) Performance

Products

• Clarity PPM On Premise

Issue/Introduction

The job runs but never completes.

 

Environment

Clarity 15.7+

Resolution

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.