Delete Log Analysis Data job only deleting 20K rows

book

Article ID: 224044

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The Delete Log Analysis Data Job is only deleting 20k rows each time it runs, no matter the parameters (retention in days) being specified


STEPS TO REPRODUCE: 

1. Execute the Delete Log Analysis Data Job.

2. Specify the retention in days parameter, so that more than 20K rows are to be deleted from the LOG* tables.


Expected Results: All the rows on the tables are deleted, as per the parameter being specified.
Actual Results: Only the top 20k rows are deleted.

Cause

This is being investigated as Defect DE62529

Environment

Clarity PPM 15.x on MS SQL DB.

Resolution

This has been investigated as Defect DE62529.

Workaround: Execute the job multiple times, until all required rows are deleted.

This Defect is resolved and will be addressed as from version 16.0.