Application server is failing to start

Products

• CA Workload Automation AE

Issue/Introduction

Hi Team,

We seemed to have a latency issue in getting the job status updated, when we tried restarting the application server it failed to start and it was throwing following error

[04/11/2022 14:50:15]      CAUAJM_I_40244 LogMaxEndLines value set to <0>.
[04/11/2022 14:50:16]      CAUAJM_I_40211 Using TZ = EST5EDT.
[04/11/2022 14:50:16]      CAUAJM_I_10654 System is running in dual server mode.  Event server 1:  asysp2s.  Event server 2:  asysp1s.
[04/11/2022 14:51:31]      CAUAJM_E_18416 Event Server: <name of database>  Failed Query: <select str_val from ujo_alamode where type='BINARY_VERSION'>
[04/11/2022 14:51:31]      CAUAJM_E_18402 ORA-12571: TNS:packet writer failure
[04/11/2022 14:51:31]      CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
[04/11/2022 14:51:31]      CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <902>
[04/11/2022 14:51:31]      CAUAJM_E_40213 AutoSys Application server does not start as the AEDB version does not match with the product    version.
[04/11/2022 14:51:31]      CAUAJM_I_30004 AutoSys Application Server shutdown complete.
[04/11/2022 14:51:31]      CAUAJM_I_30000 AutoSys Application Server exiting.

 

We tried restarting the entire instance but no luck, application server is still not responding.

 

Below are scheduler information:

Autoflags output:

0028 AIX ORA 12.0 01.00 3019db54 <machine name> <machine name>

 

 

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

The main error to focus on is:

CAUAJM_E_18402 ORA-12571: TNS:packet writer failure

The Oracle client on the Application server machine is having problems getting the to AutoSys database. Went to the tnsnames.ora file and updated the server that the database is installed on to be the ip address, instead of the hostname.