search cancel

Job(Delete Investments and Time Reporting Periods) Performance

book

Article ID: 189383

calendar_today

Updated On:

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.