UFT-8 Migration: Invalid 'ADD CONSTRAINT' statements in FINAL step

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The following error occurs running the 1st SQL script of the Offline Part of the migration generated running the FINAL mode of the UTF-8 Migration Package:

SQL Error [904] [42000]: ORA-00904: "AH_IDNR": invalid identifier
  Error : 904, Position : 79, Sql = alter table AV add constraint FK_AV_AH foreign key (AV_AH_IDNR) REFERENCES AV (AH_IDNR) NOVALIDATE, OriginalSql = alter table AV
add constraint FK_AV_AH foreign key (AV_AH_IDNR) REFERENCES AV (AH_IDNR) NOVALIDATE, Error Msg = ORA-00904: "AH_IDNR": invalid identifier
  ORA-00904: "AH_IDNR": invalid identifier

Environment

Oracle

Package.UTF8.DB.Migration v1.0.2

Cause

This is a defect

Resolution

Solution:

Update to a fix version listed below or a newer version if available.

Fix version:

Component(s): Package.UTF8.DB.Migration

Package.UTF8.DB.Migration v1.0.3 - Available

Additional Information

The reference of the fix is PCK_UTF8_DB-41