CA Workload Automation AE Web Server URL does not load

Products

• Autosys Workload Automation

Issue/Introduction

The WAAE WebServer does not load the page. The web service log  $AUTOUSER/out/waae_webservices.log has the following message recorded.

2020-04-28 06:12:02,419 [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  "AEDB"

Error Code: 17002...Throwing AEConnFatalException.

Environment

CA workload Automation AE Web Server

Cause

The database is not accessible for the Autosys Web Server service.

 

Resolution

There are multiple reasons a database is not available for Autosys Web Service.

• It could be the network, configuration or user access related. Which needs to be verified first.

• The web server resides on the same box as the Autosys Application Server. Verify if the autosys native commands return successfully.

 

$ chk_auto_up

______________________________________________________________________________

 

CAUAJM_I_50054 Attempting (1) to Connect with Database: AEDB

CAUAJM_I_50055 *** Have Connected successfully with Database: AEDB. ***

______________________________________________________________________________

 

CAUAJM_I_50128 Connected with Event Server: AEDB

______________________________________________________________________________

 

______________________________________________________________________________

 

CAUAJM_I_50038 Checking AutoSys Primary Scheduler on Machine: autosys-primary.example.com

CAUAJM_I_50044 Primary Scheduler is RUNNING on machine: autosys-primary.example.com

______________________________________________________________________________

 

$ 

• Permissions for the web services filesystem [install directory] owner on the file 'tnsnames.ora'. 

$ ls -lrt $TNS_ADMIN/tnsnames.ora

-rw-r-----. 1 oracle oinstall 641 Aug 29  2019 /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora

$ id -nG oracle

oinstall dba oper backupdba dgdba kmdba racdba

$ id -nG autosys

autosys
$

• The Workload Automation AE Webserver's file system owner supposed to have the least 'read' permissions on the file. Update the same and restart the autosys webserver service.
  

# chmod o+r tnsnames.ora 

# ls -lrt tnsnames.ora 

-rw-r--r--. 1 oracle oinstall 641 Aug 29  2019 tnsnames.ora
#