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

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

book

Article ID: 382550

calendar_today

Updated On:

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