000039088 - View PV_REVIEW_DEFINITION returns entries for deleted and/or revised review definitions in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jul 7, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039088
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
IssueWhen 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.


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

CauseThis 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.
ResolutionThis issue is resolved in RSA Identity Governance & Lifecycle 7.2.0 P02.
WorkaroundPlease contact RSA Identity Governance & Lifecycle Customer Support for a workaround and mention this RSA Knowledge Base Article ID 000039088 for reference.