Autosys WCC WebUI won't connect to the database after upgrade ue to error: Socket read timed out

Products

• CA Workload Automation AE

Issue/Introduction

INFO   | jvm 1    | 2022/04/27 19:51:15 |        4 | Apr 27, 2022 7:51:14 PM com.ca.wcc.dbresource.datasource.UnlockingDatasource setParameters
INFO   | jvm 1    | 2022/04/27 19:51:15 |        4 | INFO: URL= jdbc:oracle:thin:@AUTOSYS_WCC, Driver= oracle.jdbc.driver.OracleDriver
INFO   | jvm 1    | 2022/04/27 19:51:15 |        4 | Apr 27, 2022 7:51:14 PM com.ca.wcc.dbresource.datasource.WccDataSource registerMBean
INFO   | jvm 1    | 2022/04/27 19:51:15 |        4 | INFO: Trying to create connection pool, retry attempt - 1
INFO   | jvm 1    | 2022/04/27 19:51:17 |        6 | Apr 27, 2022 7:51:17 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
INFO   | jvm 1    | 2022/04/27 19:51:17 |        6 | SEVERE: Unable to create initial connections of pool.
INFO   | jvm 1    | 2022/04/27 19:51:17 |        6 | java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
........
INFO   | jvm 1    | 2022/04/27 19:51:17 |        6 | Caused by: java.io.IOException: Socket read timed out, socket connect lapse 4 ms. /10.10.11.12 1521 3 1 true
.....
INFO   | jvm 1    | 2022/04/27 19:51:17 |        6 | Caused by: java.io.InterruptedIOException: Socket read timed out

Environment

Autosys  12.X

 

Cause

The customer's database was a load-balanced configuration.
The TRANSPORT_CONNECT_TIMEOUT of 3 seconds was not enough 

 

AUTOSYS_WCC =
  (DESCRIPTION = (CONNECT_TIMEOUT=90)(RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)
    (ADDRESS_LIST =
      (LOAD_BALANCE = ON)
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode1.company.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode2.company.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode3.company.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode4.company.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode5.company.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode6.company.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = dedicated)
      (SERVICE_NAME = AUTOSYS_WCC)
    )
 )

 

We did a tnsping AUTOSYS_WCC  repeatedly. 
On some occasions, it showed as taking >3 seconds

Resolution

Increased the Oracle TRANSPORT_CONNECT_TIMEOUT=30   
restarted WCC.
It connected to the database fine and started working normally