CA Workload Automation AE Web Server URL does not load
search cancel

CA Workload Automation AE Web Server URL does not load


Article ID: 189635


Updated On:


CA Workload Automation AE


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 - 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.


CA workload Automation AE Web Server


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



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

  • 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/
$ id -nG oracle
oinstall dba oper backupdba dgdba kmdba racdba
$ id -nG 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