Requests Pending Submissions queue accumulating in RSA Identity Governance & Lifecycle
Originally Published: 2020-09-28
Last Modified: 2022-06-20
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
Menu bar is not refreshed after creating a Change Request or Pending Submission in RSA Identity Governance & Lifecycle 47Number of Views The Cancel Pending Requests button on the Pending Submissions page is disabled in RSA Identity Governance & Lifecycle 69Number of Views Change Requests in Pending Submission state are not being deleted by the daily scheduled task in RSA Identity Governance &… 73Number of Views Workflow for Provisioning Requests 17Number of Views What is the Change Request Pending Submission State in RSA Identity Governance & Lifecycle 199Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities
Don't see what you're looking for?