Users tab slow to load in SecurID Governance & Lifecycle
2 years ago
Article Number
000067939
Applies To

This is a known issue in the following versions when using Oracle 19c as the datastore:

  • RSA Governance & Lifecycle 7.2.1
  • RSA Governance & Lifecycle 7.5.0
  • SecurID Governance & Lifecycle 7.5.2
Issue

The Users page under the Users menu is slow to load.

The following query shows in the AWR report as being executed for a very large number of times:

gnf27z7h9fvd1SELECT MAX(LAST_NAME || ', ' || FIRST_NAME) FROM T_MASTER_ENTERPRISE_USERS WHERE ID = :B1

 

Cause
The query mentioned above is part of an internal function used as a virtual column in many internal tables.  This internal function performs poorly in Oracle 19c.
Resolution

This issue is resolved in the following versions:

  • RSA Governance & Lifecycle 7.5.0 P08
  • SecurID Governance & Lifecycle 7.5.2 P04