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
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 Change requests provisioned by AFX remain in "pending action" or "pending verification" in RSA Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update How to Forward RSA Authentication Manager 8.4 or Later Logs to Multiple Syslog Servers Using rsyslog RSA Authentication Manager 8.9 Patches and Hotfixes Readme
Don't see what you're looking for?
