Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle
4 years ago
Originally Published: 2020-09-28
Article Number
000043505
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: 
08/14/2020 07:53:00.159 INFO  (ThreadPool-7) [com.aveksa.server.db.persistence.PersistenceServiceProvider] executeCallableStatement giving up after hitting SQLException: ORA-02292: integrity constraint (AVUSER.FK_CRDETAIL_DEPENDENCY_CRI_ID) violated - child record found
ORA-06512: at "AVUSER.ACCESS_REQUEST_PKG", line 1844
ORA-06512: at "AVUSER.ACCESS_REQUEST_PKG", line 1892
ORA-06512: at line 1
08/14/2020 07:53:00.160 WARN  (ThreadPool-7) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 2292, SQLState: 23000
08/14/2020 07:53:00.160 ERROR (ThreadPool-7) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-02292: integrity constraint (AVUSER.FK_CRDETAIL_DEPENDENCY_CRI_ID) violated - child record found
ORA-06512: at "AVUSER.ACCESS_REQUEST_PKG", line 1844
ORA-06512: at "AVUSER.ACCESS_REQUEST_PKG", line 1892
ORA-06512: at line 1

 
Cause
Stored procedure DELETE_PENDINGSUBMISSIONS is failing on some Change Requests due to an integrity constraint violation.
Resolution

This issue is resolved in the following versions.
 

  • RSA Identity Governance & Lifecycle 7.1.1 P11
  • RSA Identity Governance & Lifecycle 7.2.0 P05
  • RSA Identity Governance & Lifecycle 7.2.1 P01
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.
Don't see what you're looking for?