Web Server does not start properly, Internal Exception: java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier "Oracle_Alias" Error Code: 17002...Throwing AEConnFatalException.

Products

• CA Workload Automation AE

Issue/Introduction

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.

Cause

Autosys web server did not start properly because, the Oracle Alias that the web server uses is not resolvable.

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

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.