Intermittently SQL select node queries are seen in runtime in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2020-11-03
Article Number
000044528
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.2.0, 7.2.1
 
Issue
Starting version 7.2.0 flag "acm.cleanuponcompletion" is added under workflow and it is set to 'True' by default. When this flag is set to true all user data including sql queries is expected to be cleaned up once the job completes.

User-added image


Following is the sql select node query in the workflow:
User-added image

As expected you do not see the query populating in run time.
User-added image
 

But sometimes you do see the query populating.

User-added image

Cause
 Since the option under workflow "acm.cleanuponcompletion" is set to true, the queries cleanup is expected behavior but due to a defect the cleanup is not working in few cases. 

This is a known issue reported in engineering ticket ACM-107552.
Resolution
This issue is resolved in the following RSA Identity Governance & Lifecycle patch levels: 
  • RSA Identity Governance & Lifecycle 7.2.0 P06
  • RSA Identity Governance & Lifecycle 7.2.1 P02