AE Webservice does not start. Error "could not resolve the connect identifier"

Products

• CA Workload Automation AE

Issue/Introduction

Autosys Webservice 11.3.6 SP6 Cum1 fails to start with the following error:

INFO   | jvm 1    | 2021/08/22 23:03:02 | [EL Severe]: ejb: 2021-08-22 23:03:02.939--ServerSession(1162615814)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
INFO   | jvm 1    | 2021/08/22 23:03:02 | Internal Exception: java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier  "AUTOSYS_PR1"
INFO   | jvm 1    | 2021/08/22 23:03:02 | Error Code: 17002

Cause

Web Server referring TNS_ADMIN variable fails to connect to oracle database

Environment

Release : 11.3.6

 

Resolution

- Refer TNS_ADMIN variable from  $AUTOUSER/webserver/waae_webserver.<INS>

- If it is referencing incorrect path, Please correct the right path to tnsnames.ora file location to resolve TNS_ADMIN variable