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.

book

Article ID: 207554

calendar_today

Updated On:

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.