Audit Tab Performance issue(PostgreSQL)

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When a user navigates to Audit Module within a Project/CIT or any other object instance there is a delay for the details to appear. This happens even if the number of Audit records for a particular instance are less.

Steps :-

1. Login to Clarity.
2. Create a Custom Investment with multiple sub objects.
3. Enable auditing on the Custom Investment.
4. Create data for the custom investment.
5. On the Modern UX, add the Audit Module to the Custom Investment Blueprint.
6. Navigate to Audit module on an Investment.
7. Filter for Operation Code = 'U' and 60 Days prior data in the date filter.

Expected Results :- Audit Data should be retrieving very fast.
Actual Results :- Audit Data retrieval is consuming 3 mins.

Environment

Clarity PPM 16.4.0+

Cause

DE180933

Resolution

This is fixed in 16.4.2 release