000034615 - The T_AV_ROLE_METRICS table is very large in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jan 5, 2017Last modified by RSA Customer Support on Feb 16, 2018
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000034615
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 6.9.1, 7.0.0, 7.0.1
IssueThe Aveksa Statistics Report (ASR) shows a very large number of rows in the T_AV_ROLE_METRICS table.

In the ASR report under the Aveksa Internal Table Summary note the size of the T_AV_ROLE_METRICS table.

Aveksa Internal Table Summary:
Table# of RowsLast Analyzed DateTable Size (MB)Index Size (MB)# Indexes# Valid Indexes# Non-Valid Indexes
T_AV_ROLE_METRICS2767662212016-10-10 20:11:1636677.517862.63220

CauseInefficient algorithms for maintaining the size of this table may cause it to grow excessively during role metric calculations. Sites with a large number of roles will be most affected. 
ResolutionThis issue is resolved in the following patches:
  • RSA Identity Management Governance and Lifecycle 6.9.1 P21
  • RSA Identity Governance and Lifecycle 7.0.1 P03
The patch migration script will purge these tables during the application of the patch.  The patch includes updates that prevent the table from increasing in size during use.