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

After upgrading the Oracle database, WCC fails 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.

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Cause

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

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.

Please ensure to check format of the tnsnames.ora entries with DBAs