search cancel

CA Workload Automation AE Web Server URL does not load

book

Article ID: 189635

calendar_today

Updated On:

Products

CA Workload Automation AE

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.

Cause

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

 

Environment

CA workload Automation AE Web Server

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.broadcom.net
CAUAJM_I_50044 Primary Scheduler is RUNNING on machine: autosys-primary.broadcom.net
______________________________________________________________________________
 
$ 

  • 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
#

Additional Information

https://knowledge.broadcom.com/external/article/44542/ae-web-server-errors-related-to-oracle.html