ORA-02292: integrity constraint (AVUSER.FK_CONN_PROP_TO_CONN_TYPE_PROP) violated - child record found error when deleting a connector in RSA Identity Governance & Lifecycle
Originally Published: 2020-12-14
Last Modified: 2023-10-06
Article Number
Applies To
RSA Version/Condition: 7.2.0
Issue
[com.aveksa.afx.common.packagemgmt.connector.ConnectorInstaller] Cannot_Write_To_Database com.aveksa.server.db.PersistenceException: n/a at com.aveksa.server.db.persistence.PersistenceServiceProvider.commitTransaction(PersistenceServiceProvider.java:2467) at com.aveksa.server.db.persistence.PersistenceServiceProvider.deleteAll(PersistenceServiceProvider.java:1368) ... ... Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ... ... at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) at com.aveksa.server.db.persistence.PersistenceServiceProvider.commitTransaction(PersistenceServiceProvider.java:2456) ... 70 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (AVUSER.FK_CONN_PROP_TO_CONN_TYPE_PROP) violated - child record found
This error is seen when deleting a connector that was exported, the name in xml file was updated, and then the connector was imported back.
The following steps were followed to clone a connector:
- Exported a connector.
- Edited the exported connector xml to change the connector name, descriptor name, and display name.
- Imported the updated connector xml.
- Moved the imported connector to the running state.
Now when you try to delete any connector you get an error saying unable to delete the connector, and the logs show the same constraint error.
Cause
Resolution
Workaround
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).
Related Articles
Error: 'Error running sdrepmgmt. Unable to connect to database. A replica management session may already be running. Only … 53Number of Views Radius Server Crashed with status Unknown after adding alternate IP to authentication Agent on AM 8.x 127Number of Views RSA MFA Agent 2.1.5 for Microsoft Windows Release Notes 45Number of Views Root Cause Analysis Available for SecurID 3.0.0 for iOS Token Import Issue and SecurID 3.0.2 for iOS Beta Announcement 8Number of Views What is process to change the nCipher Operator Card Set (OCS) in RSA Certificate Manager? 40Number 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?