000034615 - RSA Identity Governance and Lifecycle T_AV_ROLE_METRICS table is very large

Document created by RSA Customer Support Employee on Jan 5, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034615
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 6.9.1, 7.0.0, 7.0.1
IssueThe Aveksa Statistics Report (ASR) shows a very large number of columns 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 
TableNo of RowsLast Analyzed DateTable Size (MB)Index Size (MB)Number of IndexesNumber of Valid IndexesNumber of 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. Customers 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.