Clarity: Audit Trail performance problem on object instance pages

book

Article ID: 51055

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Description:

Audit Trail on object instance pages like Resource and Project, it has very slow performance.

Steps to Reproduce:

  1. Login Clarity, go to Admin Tool page

  2. Data Administration.

  3. Click on Audit Trial tab.

When verified in the customer's AWR report and validated their execution plans, the below tables have full table scan:

 ODF_AUDITED_ATTRIBUTES 
 ODF_AUD_OBJ_INST_CONTEXT   
 CMN_AUDITS
 SRM_RESOURCES   
 CMN_AUDITS_TSV

Expected Result: Page should be returned within reasonable time.

Actual Result: It took 20-30 minutes to finish or time out.

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

Resolved in Clarity 12.1.1.

Keywords: CLARITYKB, CLRT-54361, clarity12resolved, clarity1211resolved, performance.

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: