Integrity constraint error seen while deleting a connector from the UI. The following error is seen in aveksaServer.log:
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
... 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.
The integrity constraint error is caused by both connectors, the original one and the modified one, as they have the same "CONN_TYPE_ID" in T_AV_AFX_CONNECTOR table.
The contents of an exported connector package/xml should not be edited for the purpose of importing back the modified connector, as such an operation is NOT supported.
If you have run into this issue and need assistance with deleting those connectors, contact RSA Customer Support and quote this KB article for a procedure to delete those connectors directly from the database.