Webservices Call Fails
search cancel

Webservices Call Fails

book

Article ID: 6938

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent

Issue/Introduction

Webservice calls fails with below error.

24-MAY-2017 09:57:59 * (CONNECT_DATA=(SID=XXXXX)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=XXXXX))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.
XX.XX.XX)(PORT=XXXX)) * establish * XXXXX* 12505 

Below error occurs in waae_webservices_wrapper.log

INFO   | jvm 1    | 2017/05/24 10:00:27 | Error Code: 12505
INFO   | jvm 1    | 2017/05/24 10:00:27 | [EL Severe]: ejb: 2017-05-24 10:00:27.745--ServerSession(1553225196)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
INFO   | jvm 1    | 2017/05/24 10:00:27 | Internal Exception: java.sql.SQLException: Listener refused the connection with the following error:
INFO   | jvm 1    | 2017/05/24 10:00:27 | ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Environment

Issue May Occur in Oracle RAC with r11.3+ WAAE versions.

Cause

This issue occurs when $TNS_ADMIN variable is not setup in the AutoSys environment, because when the TNS_ADMIN variable is set, the compliance app or WAAE Web Server uses the “oracle.tns.connection.string” parameter and skips the “oracle.connection.string=” setting in the $AUTOSYS/config/cmplapp/connection.properties file.

Note # And, by default the $TNS_ADMIN is set in the autosys environment profiles.

 

 

 

 

Resolution

1) Let’s change this line in connection.properties file.

oracle.connection.string=jdbc:oracle:thin:@${servername}:${port}:${dbname} 

to 

oracle.connection.string=jdbc:oracle:thin:@//<hostname>:<port>:<SID>

2) To get WAAE Web Server to use the Oracle Servicename instead of SID, you need to ensure the $AUTOUSER/config.$AUTOSERV (EventServer_1) contains the servicename, and update the $AUTOSYS/config/cmplapp/connection.properties file with the following:  

 oracle.connection.string=jdbc:oracle:thin:@${servername}:${port}/${dbname}

 instead of: oracle.connection.string=jdbc:oracle:thin:@${servername}:${port}:${dbname}

Another location to check is   /opt/CA/WorkloadAutomationAE/webserver/bin/  folder and look for  waae_webserver.*  scripts.  Make sure the TNS_ADMIN  and any other ORACLE related variables are correct. If not, correct them and restart the web server

 

Additional Information

By default you can find this connection.properties file under /opt/CA/WorkloadAutomationAE/autosys/config/cmplapp. Once these changes are done please restart the services of web services.

Powered by Wolken Software