Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle
Originally Published: 2020-09-28
Article Number
Applies To
RSA Version/Condition: 7.1.x, 7.2.0, 7.2.1
Issue
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
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
Related Articles
Workflow for Provisioning Requests Number of Views The Cancel Pending Requests button on the Pending Submissions page is disabled in RSA Identity Governance & Lifecycle Number of Views Change Requests in Pending Submission state are not being deleted by the daily scheduled task in RSA Identity Governance &… Number of Views Change Requests cancelled by Escalation Workflows progress to Fulfillment instead of getting cancelled in RSA Identity Gov… Number of Views Owner approvals are skipped if the owner previously approved at least one item in the request as a supervisor in RSA Ident… Number of Views
Trending Articles
Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update Authentication Manager How to Retrieve the LDAPS Certificate and Configure an External Identity Source to Use LDAPS
Don't see what you're looking for?
