Article Number
000034615
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 6.9.1, 7.0.0, 7.0.1
Issue
The 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 Rows | Last Analyzed Date | Table Size (MB) | Index Size (MB) | # Indexes | # Valid Indexes | # Non-Valid Indexes |
|---|
| T_AV_ROLE_METRICS | 276766221 | 2016-10-10 20:11:16 | 36677.5 | 17862.63 | 2 | 2 | 0 |
Cause
Inefficient 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.
Resolution
This 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.
