CAUAJM_E_40212 Error When Starting the Scheduler After Upgrade from 12.0.0 to 12.0.01

Products

• Autosys Workload Automation

Issue/Introduction

After upgrading AutoSys from 12.0.0 to 12.0.01, the following error is received when attempting to start the Scheduler...

CAUAJM_E_40212 AutoSys Scheduler does not start as the AEDB version does not match with the product version.

The upgrade did not receive any errors and the output of 'autoflags -a' shows that AutoSys has been upgraded to 12.0.01.

Environment

Release : 12.0.01

Component : CA Workload Automation AE (AutoSys)

Cause

This error will appear when there is a mismatch in version information stored in the ujo_alamode table within the AutoSys database. Run these two queries to check the values...

select str_val from ujo_alamode where type='AEDB_VERSION';

select str_val from ujo_alamode where type='BINARY_VERSION';

The output from these queries should both be 12.0.01.00 after an upgrade to R12SP1.

Resolution

If the AEDB_VERSION still shows the old version, it is likely the database did not get upgraded. Check the cawa_installer.log for errors while attempting to upgrade the schema.

If the AEDB_VERSION shows 12.0.01.00, but the BINARY_VERSION still shows the old version, check the output of 'autoflags -a'. If 'autoflags -a' still shows the old version, then something went wrong with the upgrade after it had updated the schema. Check the cawa_installer.log for errors. However, if autoflags shows the AutoSys version to be 12.0.01, you should be able to correct the problem by running the following sql update...

update ujo_alamode set str_val='12.0.01.00' where type='BINARY_VERSION';