Article Number
000039088
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
Issue
When creating a report in RSA Identity Governance & Lifecycle (
Reports >
Tabular >
Create Report) that uses the AVUSER.PV_REVIEW_DEFINTION public view to get a list of review definitions, if deleted review definitions and/or revised review definitions exist, they appear on the report.
EXAMPLENote the following review names under
Reviews >
Definitions.
Image description
If review UA10 is deleted (Reviews > Definitions > UA10 > trash can icon top right corner), it no longer shows under Reviews > Definitions.
Image description
The expected behavior is that the report will show the list of current review definitions only. The same list as can be seen under Reviews > Definitions. However, the deleted reviews and all review definition revisions show on the report (Reports > Tabular > {Name of report} > Run Report). Note in the example below that UA10 and all of its revisions show on the report.
Report Definition:
Image description
Report Results:
Image description
Cause
This is a known issue reported in engineering ticket ACM-104869.
The PV_REVIEW_DEFINITION returns entries from the incorrect table. The view queries a table that tracks all review definitions including deleted definitions and version changes rather than the table that stores the current review definitions. This causes the view to return deleted definitions and duplicate entries when they exist.
Resolution
This issue is resolved in RSA Identity Governance & Lifecycle 7.2.0 P02.
Workaround
Please contact
RSA Identity Governance & Lifecycle Customer Support for a workaround and mention this RSA Knowledge Base Article ID 000039088 for reference.