Web UI Upgrade Failed with ORA-02298 from 12.1-> 12.1.01
search cancel

Web UI Upgrade Failed with ORA-02298 from 12.1-> 12.1.01

book

Article ID: 370591

calendar_today

Updated On: 07-10-2024

Products

Autosys Workload Automation

Issue/Introduction

WCC upgrade fails from 12.1 to 12.1.01 with below error.

2024-06-19 22:40:54,102 [main] ERROR com.ca.wcc.db.DBChangesForUpgrade(251) - There was a problem with database while running the upgrade: ORA-02298: cannot validate (DBNAME.AO_SCHAGENT_PLUGIN_FK) - parent keys not found
java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (DBNAME.AO_SCHAGENT_PLUGIN_FK) - parent keys not found

Environment

Web UI # 12.1

Cause

Since we introduced foreign key in table AO_SCHAGENT_PLUGIN.

Resolution

This a known issue, please contact support for resolution.