ORA-02292: integrity constraint (AUTOMIC_ARA.FK_CUSTOMACTION) violated - child record found when upgrading to version 8 of ARA

Document ID : KB000087448
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 8

Error Message :
Warning! : ORA-02292: integrity constraint (AUTOMIC_ARA.FK_CUSTOMACTION) violated - child record found 

The ARA update from version 5 to 8 fails when the upgrade process is updating the data in the database with following error: 
 
Warning! : ORA-02292: integrity constraint (AUTOMIC_ARA.FK_CUSTOMACTION) violated - child record found 
============ Error Detail ============ 
Error in migration: 710201609201 
ORA-02292: integrity constraint (AUTOMIC_ARA.FK_CUSTOMACTION) violated - child record found 

 
Note:  This Knowledge Article only describes the issue if it's coming up during the Release Manager Upgrade to Version 8.0.0 from Version 6.0.0 or lower. If the error message occurs in any other situation, this Article might not be sufficient and you would need to contact support.

If this error message ORA-02292 comes up while upgrading from other versions, please check for other Knowledge Base entries, or open an Incident, or use our Community to get help.
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: A bug within the installation routine causes the Data Migration to fail to upgrade the database to version 8.0.0 (ARA 12.1) if the database contains custom actions.
Resolution:
Update to a fix version listed below or a newer version if available.

The issue was found and fixed with Release.Manager 8.0.0 HF1. The Package is available for download at the Automic-Support-Zone (https://support.automic.com). 

Hotfix-Description: Data Migrator tool fail to upgrade database if there is Custom Action 

A problem has been fixed where Data Migrator fails to upgrade database to version 8.0.0 (ARA 12.1) if the database contains custom actions.


Fix Status: Released

Fix Version(s):
Release Manager 8.0.0 HF 1 - Available
Additional Information:
Workaround :
N/A