Autosys upgrade from 11.3.6 SP8 to 11.3.6 SP8 CUM1 failed

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

When applying SP8 cum1 patch SO12221 it fails at the refresh_aedb portion.

The "refresh_aedb.log" ends with:

SQL> BEGIN
  2  DBMS_OUTPUT.PUT_LINE('Fixing ujo_afm table to fix wrong data in ujo_afm.source column.');
  3  END;
  4  /
Fixing ujo_afm table to fix wrong data in ujo_afm.source column.

PL/SQL procedure successfully completed.

SQL> EXIT;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Return code = 0

CA Workload Automation AE database was not refreshed.

Cause

RefreshAEDB.pl fails due to fact that there are machine names starting with ORA-
This caused the RefreshAEDB.pl script to fail during the patch run.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

You can use following workaround:


Adapt the $AUTOSYS/dbobj/ORA/RefreshAEDB.pl script as follows:

Modify

if ($outLine =~ m/ORA-/) {
$SUCCESS="N";
}

to

if ($outLine =~ m/ORA-\d\d\d\d\d: /) {
$SUCCESS="N";
}

After this, the patch succeeded and the update is complete.