000039347 - Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle

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

Article Content

Article Number000039347
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.x, 7.2.0, 7.2.1
 
IssuePending 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


 
CauseStored 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
WorkaroundManually 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.

Attachments

    Outcomes