Application server is failing to start

Products

• CA Workload Automation AE

Issue/Introduction

Observing latency issue in getting the job status updated.

 

Restarting application server gave 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:  ORCL1.  Event server 2:  ORCL2
[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.

 

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.