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
The Cancel Pending Requests button on the Pending Submissions page is disabled in RSA Identity Governance & Lifecycle Number of Views RSA Governance & Lifecycle Blueprint - Bulk Application Creation Number of Views RSA Identity Governance and Lifecycle 7.1.0.7 Release Notes Number of Views Poor performance when processing SoD Rules that use a Correlation Attribute in RSA Identity Governance & Lifecycle Number of Views Access Fulfillment Express (AFX) is not provisioning requests after running out of disk space in RSA Identity Governance &… Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to import CA signed console cert from AM 8.x primary into a new primary with same FQDN How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. How to delete old or pending certificate signing requests for RSA Authentication Manager console or virtual host replaceme…
Don't see what you're looking for?
