Customer upgraded Oracle database, and WCC failed to validate the AEWS server:
Error: E190098 (web services validation) - A connection exception was encountered: https://Autosys-webserver:9443/AEWS returned error java.net.SocketTimeoutException: Read timed out https://Autosys-webserver:9443/AEWS returned error java.net.SocketTimeoutException: Read timed out.
Confirmation: I190220 The CSAM is configured properly for the ports 9000, 49152.
The $AUTOUSER/out/waae_webservices.log contains this error:
2021-01-29 08:41:51,870 [AEConnMgr Monitor] ERROR com.ca.waae.dbaccess.dao.AEConnection - createEntityManager [EventServer_1] -> IllegalStateException encountered. Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier "Oracle-Alias"
Error Code: 17002...Throwing AEConnFatalException.
Autosys web server did not start properly because, the Oracle Alias that the web server uses is not resolvable.
Release : 12.0
Component : CA Workload Automation AE (AutoSys)
Web Server has its own reference to Oracle's TNS_ADMIN (or ORACLE_HOME) folders.
grep -i TNS $AUTOUSER/webserver/conf/*
It should show location of tnsnames.ora, verify the contents to the tnsnames.ora and ensure that correct Oracle reference to the database exists in that file. Restart web server after.