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.
Release : 15.8
Component : CA PPM PROJECT MANAGEMENT
Upon tracing the user, the below query is slow
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.