AutoSys Fails to start in High Availability

Products

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

Issue/Introduction

Description:

When starting AutoSys in High Availability fails with CAUAJM_E_10192 Configuration indicates that the Application Server on host xxx is already running with the same AutoServerId: Exiting.

Solution:

1. Execute given SQL query to verify current High Availability status for both Scheduler Servers;
   - SELECT * from ujo_ma_process;
   
   NOTE: Value of "1" for ma_status_id means the Scheduler is ACTIVE and Value of "3" means the Scheduler is Dormant
   
   
2. For the problem reported ma_status_id should return value of "1" for both Primary and Secondary Scheduler; which means both Primary and Secondary Scheduler are marked as active on the database
   
   
3. Reset ma_status_id value to "3" executing given SQL statement;
   - UPDATE ujo_ma_process SET ma_status_id = 3 WHERE ma_status_id = 1;
   
   
4. Verify AutoSys High Availability configuration and it is Dual Server configuration perform this on both databases
   
   
5. Now you can bring up AutoSys in HA successfully without CAUAJM_E_10192 error message
   
   Another option is to delete the incorrect entry from that table with:
   
   delete from ujo_ma_process where hostname=YOUR_HOST_NAME
   
   Run these commands on your both databases when running in full HADS. Then restart the application severs

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: