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.
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.
Release : 12.0.01
Component : CA Workload Automation AE (AutoSys)
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';