Webservices Call Fails

Document ID:  TEC1753887
Last Modified Date:  06/19/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA Workload Automation AE


  • CA Workload Automation AE:Release:11.3.5
  • CA Workload Automation AE:Release:11.3.6


  • CA Workload Automation AE (AutoSys):ATSYS

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


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

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.











1) Let’s change this line in connection.properties 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/connection.properties file with the following:  


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



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.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required


We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile

  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.

    Rate Your Chat Experience.


agent is typing