ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Webservices Call Fails


Article ID: 6938


Updated On:


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


Webservice calls fails with below error.

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



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


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











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


1) Let’s change this line in file.





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/ file with the following:  


 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 file under /opt/CA/WorkloadAutomationAE/autosys/config/cmplapp. Once these changes are done please restart the services of web services.