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
'Critical Error' with software Token for Windows Number of Views Hibernate WARN messages flooding logs in RSA Identity Governance & Lifecycle Number of Views What is the meaning of yellow flags in Microsoft Internet Explorer's icons for critical extensions? Number of Views Error: 'null; nested exception is: java.lang.NullPointerException' in RSA Federated Identity Manager (FIM) 2.5 Number of Views C_SetCertBER returns error E_UNKNOWN_CRITICAL_EXTENSION Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
