Applying Autosys CUM patch fails database errors not finding expected objects

Products

• Autosys Workload Automation

Issue/Introduction

The patching failed When applying the CUM3 patch to the R12.1.01CUM1 Autosys server.
In the refresh_aedb.log the following errors were seen :

Mar 10 17:51:08 2025 SQL> DROP INDEX xak4ujo_event;
Mon Mar 10 17:51:08 2025 DROP INDEX xak4ujo_event
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:51:08 2025 SQL> DROP INDEX xak1ujo_event;
Mon Mar 10 17:51:08 2025 DROP INDEX xak1ujo_event
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:51:08 2025 SQL> DROP INDEX xak4ujo_job;
Mon Mar 10 17:51:08 2025 DROP INDEX xak4ujo_job
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:51:08 2025 SQL> ALTER TABLE ujo_jobblob DROP CONSTRAINT xpkujo_jobblob;
Mon Mar 10 17:51:08 2025 ALTER TABLE ujo_jobblob DROP CONSTRAINT xpkujo_jobblob
Mon Mar 10 17:51:08 2025                                         *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-02443: Cannot drop constraint  - nonexistent constraint

Mon Mar 10 17:51:08 2025 SQL> DROP INDEX xak2ujo_job_status;
Mon Mar 10 17:51:08 2025 DROP INDEX xak2ujo_job_status
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:51:08 2025 SQL> DROP INDEX xak1jo_machine;
Mon Mar 10 17:51:08 2025 DROP INDEX xak1jo_machine
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:51:08 2025 SQL> ALTER TABLE ujo_temp_jobruns DROP CONSTRAINT xpkujo_temp_jobruns;
Mon Mar 10 17:51:08 2025 ALTER TABLE ujo_temp_jobruns DROP CONSTRAINT xpkujo_temp_jobruns
Mon Mar 10 17:51:08 2025                                              *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-02443: Cannot drop constraint  - nonexistent constraint

Mon Mar 10 17:51:08 2025 SQL> DROP INDEX xpkujo_temp_jobruns;
Mon Mar 10 17:51:08 2025 DROP INDEX xpkujo_temp_jobruns
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:51:08 2025 SQL> DROP INDEX xa1ujo_wait_que;
Mon Mar 10 17:51:08 2025 DROP INDEX xa1ujo_wait_que
Mon Mar 10 17:51:08 2025            *
Mon Mar 10 17:51:08 2025 ERROR at line 1:
Mon Mar 10 17:51:08 2025 ORA-01418: specified index does not exist

Mon Mar 10 17:52:03 2025 SQL> INSERT INTO ujo_real_resource(roid, type, optional, keyword, name, max_value, min_value)
Mon Mar 10 17:52:03 2025   2           VALUES (1, 1, 1, 'VALUEOP', 'SYSTEM_OS_TYPE', '', '');
Mon Mar 10 17:52:03 2025 INSERT INTO ujo_real_resource(roid, type, optional, keyword, name, max_value, min_value)
Mon Mar 10 17:52:03 2025 *
Mon Mar 10 17:52:03 2025 ERROR at line 1:
Mon Mar 10 17:52:03 2025 ORA-00001: unique constraint (AEDBADMIN.XPKUJO_REAL_RESOURCE) violated

Environment

Autosys 12.x

Cause

an incorrect file in the $AUTOSYS/dbobj folder

Resolution

remove the file rdo_realresources.adb from the $AUTOSYS/dbobj folder and then run the CUM patch again

cd $AUTOSYS
find . -name "*.adb"

Example output:
./dbobj/binaryid.adb
./dbobj/ddl.adb
./dbobj/pre_upgrade.adb
./dbobj/rdo_intcodes.adb
./dbobj/rdo_metadata.adb
./dbobj/rdo_upgrade.adb
./dbobj/seed_misc.adb
./dbobj/seed_timezones.adb
./dbobj/ESJ/CT_K8S.adb
./dbobj/ESJ/CT_PROXYPROFILE.adb
./dbobj/ESJ/JT_K8S_CMD.adb
./dbobj/ESJ/JT_K8S_JOB.adb
./dbobj/ESJ/JT_K8S_SCALE_DEP.adb
./dbobj/ESJ/JT_OPENSHIFT_SCALE_DEP_CFG.adb
./dbobj/rdo_realresources.adb

cd dbobj
rm ./rdo_realresources.adb