CAUAJM_E_18000 Database function call <ct_connect> failed

Products

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

Issue/Introduction

We did a server migration this morning and changed the IP address on our existing server that runs the Linux agent. Now, we cannot connect to this server to run any jobs. 

We get the following error when running chk_auto_up: 

CAUAJM_E_10029 Communication attempt with the CA WAAE Application Server has failed! [localhost:9000] 
CAUAJM_E_10221 Exhausted list of available Application Server(s). Failing request. 
CAUAJM_E_50033 Error initializing tx subsystem: CAUAJM_E_10062 Failed to get initial configuration from CA WAAE Application Server(s). 

 

The event_demon log shows the following error: 

CAUAJM_E_18000 Database function call <ct_connect> failed in <openProc while creating connection> with return code: 0 
CAUAJM_E_18014 OS error: Failed to connect to the server - Error is 10061 No connection could be made because the target machine actively refused it. CAUAJM_E_18015 Client message: Message number: layer (5), Origin (3), text (ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed), SEVERITY = (5), NUMBER = (4) 

How do I resolve this error 'CAUAJM_E_18000 Database function call <ct_connect> failed' and get the scheduler backup and running again?

Environment

Release: ATSAGE99000-11.3-Workload Automation AE-Remote Agent
Component:

Resolution

You need to make sure that you change the IP address for the server on the database side, to reflect the new IP address.

For Sybase, go to your $SYBASE directory and edit the sql.ini file. Make the necessary change for IP address, then restart the Autosys services.