|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.1.x, 7.2.0, 7.2.1
|Issue||Pending Submission Change Requests are not cleaning up automatically in Requests > Pending Submissions. The list keeps accumulating instead of removing old ones. |
The aveksaServer.log logs the following:
|Cause||Stored procedure DELETE_PENDINGSUBMISSIONS is failing on some Change Requests due to an integrity constraint violation.|
This issue is resolved in the following versions.
|Workaround||Manually cancel the older pending submission change requests from the user interface. Once the Change Request with the integrity constraint issue is removed the rest will be deleted automatically next time DELETE_PENDINGSUBMISSIONS runs. This issue may reappear later if another CR with this scenario is encountered.|