000036774 - Overall slow performance navigating the user interface and user sessions are timing out when displaying new pages in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jul 7, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036774
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition:  All
 
IssueOverall system performance is slow, especially navigating the user interface and user sessions are timing out when accessing new pages.

The Oracle AWR shows a lot of long-running SQL queries similar to the following:

SELECT COUNT(*) AS NUM_ROWS FROM ...

For more information on the Oracle AWR, see RSA Knowledge Base Article 000037779 - How to generate an Oracle Automatic Workload Repository (AWR) report for RSA Identity Governance & Lifecycle.
 
CauseThis is a known issue reported in engineering ticket ACM-85934.

The queries that look like this:
 

SELECT COUNT(*) AS NUM_ROWS FROM ....


are used to gather counts displayed in the user interface. We have seen this issue when a system is undersized with huge amounts of data and many users logging into the system concurrently.
 
ResolutionThe disk space needs to be managed. Options available such as Data Purging and Data Archiving depend on your version of RSA Identity Governance & Lifecycle. See RSA Knowledge Base Article 000038168 -- How to manage database growth in RSA Identity Governance & Lifecycle to find the best solution for your environment.
 
WorkaroundIf you are on RSA Identity Governance & Lifecycle 7.1.0 P04 or higher, there is a workaround available. Please contact RSA Identity Governance & Lifecycle Customer Support for the workaround and mention this RSA Knowledge Base Article ID 000036774 for reference.
 

Attachments

    Outcomes