Unable to search or sort for reviewer when using Review Results -> Escalations tab in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2018-12-10
Article Number
000040314
Applies To
RSA Product Set: Identity Governance and Lifecycle
RSA Version/Condition: 7+
 
Issue
Unable to search or sort for reviewer values when using Review Results -> Escalations tab

The following screens demonstrate the issue.

These show the data that exists:
User-added image

And these shows the searches tried and not returning any results incorrectly.

User-added image

User-added image

User-added image

User-added image



 
Cause
"INITIATOR_ID" column value in “wp_proci” table was incorrectly mapped for Review Escalations
Resolution
Upgrade to 7.0.2 P12 or 7.1.0 P05 or later.