View PV_REVIEW_DEFINITION returns entries for deleted and/or revised review definitions in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2020-07-02
Article Number
000043553
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.

EXAMPLE

Note the following review names under Reviews > Definitions.

User-added image


If review UA10 is deleted (Reviews > Definitions > UA10 > trash can icon top right corner), it no longer shows under Reviews > Definitions.

User-added image


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:

User-added image

Report Results:

User-added image


 
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.
 

Related Articles

Trending Articles

Don't see what you're looking for?