Delete Process Instances Job is consuming longer time after upgrade to 16.4.0

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrading Clarity to version 16.4.0, users have observed a significant degradation in the execution speed of the Delete Process Instances Job compared to previous releases.

Database monitoring indicates that a frequently executing and resource-intensive SQL statement is contributing to this slowdown:

delete from bpm_errors ......

Environment

Clarity PPM 16.4.0

Cause

DE180180

Resolution

Fixed in 16.4.0 Patch 1