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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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