Performance of Risks, Issues and Changes module slow Modern UX

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Problem Statement: The performance of Risk, Issues and Changes are slow on a system which has lot of instance rights. 

STEPS TO REPRODUCE: 

1. Log in to the Modern UX as a user with OBS or Instance access rights 
2. Go to the Project Tiles list and click into an existing project that has some Risks, Issues, and Change Requests 
3. Go to one the following Modules: Risks, Issues, and Changes 

Expected Results: The items from the Risks, Issues, and Changes modules are listed with little or no delay. 

Actual Results: For some users trying to list items from the Risks, Issues, and Changes modules, the results do not appear for minutes. 

 

 

 

Cause

Upon tracing the user, the below query is slow

SELECT SEC.OBJECT_INSTANCE_ID
FROM CMN_SEC_CHK_INST_V0 SEC, CMN_SEC_OBJECTS O
WHERE SEC.OBJECT_ID = O.ID
AND O.OBJECT_CODE like 'RIM_RISK_ISSUE'
AND SEC.USER_ID = %replace the impacted user Id%

This was logged as defect DE59867. 

Environment

Release : 15.8

Component : CA PPM PROJECT MANAGEMENT

Resolution

• The Defect DE59867 is fixed in Clarity 15.9.2
• This may not be feasible for some users, but you could assign the user global access rights and the query works as expected.