WCC(Workload Control Center) service fails to start with error "SQLRecoverableException: IO Error: The Network Adapter could not establish the connection"

Products

• Autosys Workload Automation

Issue/Introduction

WCC (Workload Control Center) service unable to start with below errors in CA-wcc.log file:
INFO   | jvm 1    | 2021/11/19 03:34:15 |      271 | SEVERE: Unable to create initial connections of pool.
INFO   | jvm 1    | 2021/11/19 03:34:15 |      271 | java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
INFO   | jvm 1    | 2021/11/19 03:34:15 |      271 | Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
INFO   | jvm 1    | 2021/11/19 03:34:15 |      271 | Caused by: java.io.IOException: Connection timed out, socket connect lapse 127346 ms. /10.1.2.3 1521 0 1 true
INFO   | jvm 1    | 2021/11/19 03:34:15 |      271 | Caused by: java.net.ConnectException: Connection timed out

Environment

Release : 11.4.X

Component : Workload Control Center

Cause

WCC server unable to connect to Database server. 

Resolution

Check with your DBA to verify below:

• Check if the Database is up and running.
• Any port changes happened on Database side.
• In WCC server, try ping, nslookup, telnet  to Database server 
• In WCC server, check the DB connection using MSSQLServer Management Studio(in case of SQL Server), tnsping <SId>(in case of Oracle)

If all looks good, try restarting the DB and WCC Servers.